Registered aircraft · 26,231

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N177GEHolmgren David P · Kamas, UTS/N 1 N17807Gross Steven Bradley · Rockville, MDBuilt 2019 · S/N BM001 N1780QDabone Salim · Dell City, TXBuilt 1971 · S/N 15073080 N1782DRegistration Pending · Homer, AKRegistration pendingS/N 20350 N1782FCfi Care Inc · Woodbury, CTS/N 17255177 N1783ASatra Jerry · Savage, MTBuilt 1952 · S/N 18-1328 N1783VMark Uhlman Dpe LLC · Perry, OKBuilt 1947 · S/N 13968 N1784FTompkins Wyatt · Pearland, TXBuilt 1966 · S/N 17255179 N1784KTony Flies Inc · Sparta, NCS/N 4511 N1784QRed Cardinal Aviation LLC · Chantilly, VAS/N 15073084 N1784VHarlow Nathan D · Milton, VTBuilt 1947 · S/N 13969 N1785FSale Reported · Farragut, TNSale reportedBuilt 1966 · S/N 17255180 N1786KClemens Ryan · Wasilla, AKBuilt 1946 · S/N 4513 N1786NLivingston Lyle R · Chico, CABuilt 1946 · S/N 12030 N1787FSchroder Robert D · Buckeye, AZBuilt 1966 · S/N 17255182 N1787QHancock Aviation LLC · Baton Rouge, LABuilt 1971 · S/N 15073087 N1788NLahti Matt · Waterford, MIBuilt 1946 · S/N 12032 N1788QElgamil Noureldin M · West New York, NJBuilt 1971 · S/N 15073088 N178CSHiflite LLC · Athens, ALBuilt 2022 · S/N 001 N1790FTaylor Henry F · Urbana, OHBuilt 1966 · S/N 17255185 N1790VThompson Randy L · Anderson, CABuilt 1947 · S/N 14023 N1791NKieser Jason P · Bloomington, ILBuilt 1946 · S/N 12035 N1791QNearpass Stephen J · Seneca Falls, NYS/N 15073091 N1792VScholz Paul W · Clifton Park, NYBuilt 1948 · S/N 14520 N1793DThompson Joshua L · Delta Junction, AKBuilt 1951 · S/N 20235 N1793KRegistration Pending · Jupiter, FLRegistration pendingBuilt 1946 · S/N 4520 N1793NDaigh Eric B · Ketchum, IDS/N 12027 N1793QFreedom Aviation Inc · Lynchburg, VABuilt 1971 · S/N 15073093 N1794NRedsun Oren D · Fairfield, CABuilt 1946 · S/N 12038 N1795KNeeser Ryan R · Anchorage, AKBuilt 1946 · S/N 4522 N1795NBeckham Joseph D · New Waverly, TXBuilt 1946 · S/N 12039 N1796DRacoon Aviation LLC · San Antonio, TXBuilt 1951 · S/N 20238 N1797DBb Tacos And More Inc · Kalispell, MTBuilt 1951 · S/N 20239 N1797ESmokovitz Daniel J · Brighton, MIBuilt 1946 · S/N 7AC-5364 N1797NStrebel David P · Oroville, CABuilt 1946 · S/N 12041 N1797VValle Perez Kevin · Castroville, TXBuilt 1947 · S/N 13982 N1798NHissam Joshua K · Pasco, WAS/N 12042 N1798VBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 13983 N179CCSantore William F II · Laguna Niguel, CABuilt 2013 · S/N CC11-00268 N179DBBrisco Daniel J · Fort Myers, FLS/N 15075498 N179GAnderson John P · Knoxville, TNBuilt 1946 · S/N 1802 N179MMDe Schweinitz Christian R · Anchorage, AKS/N 19423 N17BSSell William T · Orofino, IDBuilt 1965 · S/N 17252856 N17DHStewart Grant W · Dallas, ORBuilt 2002 · S/N 024 N17EZWittig Bill W · Fort Mohave, AZS/N 1522 N17FGWard Bruce L · Key West, FLBuilt 1976 · S/N 15077906 N17GSTingle Terence M · Desmoines, IABuilt 1946 · S/N 17 N17KTThomason J H III · New Smyrna Beach, FLBuilt 2007 · S/N 1-17 N17LLDempsey Brian L · Millersville, MDS/N 1 N17NHPalmer Ronald E Trustee · Hopkinton, NHBuilt 1947 · S/N 17567

Back to AD 94-05-05 R1