Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N49DSSalinger David L · Verdi, NVBuilt 1998 · S/N 27-0251 N49FMRockin R&L Ranch · Kaufman, TXBuilt 1999 · S/N 27-0260 N49LBOwen Walter M · Arlington, TNBuilt 1976 · S/N 32R-7680481 N49RDDziak Chester · Jackson, MIBuilt 1966 · S/N 27-3192 N4AVSouthwest Aircraft LLC · Fairacres, NMBuilt 1949 · S/N NAV-4-1844 N4DRTotah John E · Kailua Kona, HIBuilt 1966 · S/N 27-3175 N4EPPilots Landing Aviation LLC · Lampasas, TXBuilt 1979 · S/N 70032 N4QSPonderosa Aviation LLC · Safford, AZBuilt 1968 · S/N 1755-1 N4SGCp Aero LLC · Missoula, MTBuilt 2002 · S/N 3257282 N4VSAircraft Montana LLC · Helena, MTBuilt 1974 · S/N 27-7405426 N4WBBe Positive Holdings LLC · Bloomsburg, PABuilt 1977 · S/N 32R-7880018 N5008AWings Like Eagles LLC · Wilmington, DES/N 27-3695 N500EGElliott Candice H Brown · Santa Rosa, CABuilt 1974 · S/N 27-7405453 N500GWFeldtman Enterprises Inc · Wilmington, DEBuilt 1964 · S/N 1476-170 N500HMTalos Aviation Group LLC · Blackstone, VABuilt 1973 · S/N 3155 N500HRDese Enterprises LLC · Huntsville, ALBuilt 1981 · S/N 318152133 N500LCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954060 N500QSanborn Map Co Inc · Colorado Springs, COBuilt 1973 · S/N 31-7300934 N500TDPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7854027 N5014TGalati David R · Sebring, FLBuilt 1972 · S/N 32-7240098 N5015HKnox Fred · Los Altos, CABuilt 2001 · S/N T18208096 N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157 N501BTCloud Chasers LLC · Columbus, MSBuilt 1976 · S/N 32R-7780039 N5020ABrown Jonathan Corey · Sherman Oaks, CABuilt 2001 · S/N T18208097 N5033TJulol Investments LLC · Miami, FLBuilt 2005 · S/N T18208454 N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165 N503VFC&H Aviation LLC · Greenwood Village, COBuilt 2003 · S/N 3255004 N505HVHelivision LLC · Concord, NCBuilt 2000 · S/N T20608152 N505JWCampbell Matthew P · Visalia, CABuilt 1975 · S/N 75-31118 N5061CMatheny Robert Gregg · Kingman, AZBuilt 2002 · S/N T18208166 N5066HDohr William F · Williamsburg, VABuilt 2001 · S/N T18208098 N506CVail Jeffrey · Kennett Square, PABuilt 2004 · S/N 3255015 N506TMTall Timber Flying Service LLC · Kalispell, MTBuilt 2005 · S/N T20608585 N507JBDi Marco Michael G · Orlando, FLBuilt 1979 · S/N 27-7954051 N507MAAviation Consultants US Inc · Beaver Falls, PABuilt 2004 · S/N 3255014 N508ACKtaz Air LLC · Niceville, FLBuilt 2001 · S/N T18208012 N508YLally Michael M · Miami, FLBuilt 1969 · S/N 31-452 N50BFStephenson Keith · Studio City, CABuilt 2004 · S/N 4636355 N50CCScott Macdonald Aircraft Sales Inc · Stuart, FLBuilt 1974 · S/N 27-7405360 N50DJWest Chester Air LLC · West Chester, PABuilt 1981 · S/N 32-8124021 N50PSExecutive Airshares LLC · St Thomas, VIBuilt 1973 · S/N 31-7405165 N50RNOn Three Angels Wings LLC · Melbourne, FLBuilt 1983 · S/N 31P-8414013 N50VVVictor Victor Leasing LLC · Pompton Plains, NJBuilt 2004 · S/N T18208277 N5107YBrown Peter B · Salem, VABuilt 2001 · S/N T18208099 N510ADDj Aztec LLC · Springfield, OHBuilt 1980 · S/N 27-8054044 N510CCAwmr LLC · Conroe, TXBuilt 1978 · S/N 31-7812127 N510KCProcoff LLC · Shreveport, LABuilt 1993 · S/N 4622151 N511CABas Part Sales LLC · Greeley, COS/N 14035 N511HPPattison Aero Inc · Henderson, NVBuilt 2000 · S/N T20608251 N5127WRegistration Pending · Kalispell, MTRegistration pendingBuilt 2002 · S/N T20608360

Back to AD 84-19-03 R1