Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N6489XBargainnier Devin T · Carson City, NVBuilt 1961 · S/N 18050989 N648BDHansen Robert C · Delavan, WIBuilt 1978 · S/N 18266461 N648DWDewhipet LLC · Sibley, LABuilt 1966 · S/N P206-0252 N648FRegistered aircraftS/N 18255185 N648NHVenice Group LLC · Hopkinton, NHS/N P3370063 N64901Gwaviation Consulting LLC · Woodstock, GABuilt 1974 · S/N 17262428 N64908Fauver Russell J · Hartsville, SCBuilt 1978 · S/N 15281470 N6490BPontoni Peter D · Athens, MIBuilt 1957 · S/N 29690 N6490DCampbell James W · Joshua, TXBuilt 1979 · S/N 17272832 N6490LAlpha Aircraft International LLC · Lake Worth, FLS/N 15284417 N6490XHansen Mark A · Traverse City, MIBuilt 1961 · S/N 18050990 N64912Suburban Air Corporation · Castro Valley, CABuilt 1978 · S/N 15281473 N64915Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275649 N64918Loeser Harold · Boca Raton, FLBuilt 1982 · S/N 17275651 N64919Hawk III Flyers Club · Republic, PABuilt 1973 · S/N 17262850 N6491BTerrill Guy J · Dillon, MTBuilt 1978 · S/N 21062774 N6491EToepfer Kendra · BielefeldBuilt 1959 · S/N 46591 N6491HBlue Air 3 LLC · Miami, FLBuilt 1979 · S/N 20700543 N6491KFisher Air LLC · Cardington, OHS/N 15077726 N6491ZAndolina Richard F Jr · Hornell, NYBuilt 1981 · S/N U20606293 N6492BPatno Delviny A · Daniel, WYBuilt 1978 · S/N 21062775 N6492DVessey Benjamin S · Fort Collins, COBuilt 1959 · S/N 7383 N6492ELeadmon Lorren Dale Jr · Mechanicsville, MDBuilt 1978 · S/N 17272024 N6492FSkywagon Aero LLC · Wilmington, DES/N 15063092 N6492HSpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1979 · S/N 20700544 N6492NOrmand Philip M · Tyrone, NMBuilt 1978 · S/N 21063066 N6492UWisber Peter F Jr · Perkasie, PABuilt 1979 · S/N U20605489 N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404 N64939Street Paul G · Anniston, ALBuilt 1978 · S/N 15281487 N6493AThornton Anthony D · Mckinney, TXBuilt 1956 · S/N 33293 N6493BBoyd Ryan D · Stockton, CABuilt 1956 · S/N 29693 N6493EJones Jeffrey Marlin · Westminster, MDBuilt 1984 · S/N 18268370 N6493FHatcher Jess · Lehi, UTBuilt 1975 · S/N 18264202 N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067 N6493YNeed To Fly LLC · Yukon, OKBuilt 1981 · S/N 21064405 N64942Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281489 N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657 N64944Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15281490 N64949Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15281494 N6494ARoot Jeff G · Pound Ridge, NYBuilt 1956 · S/N 33294 N6495AP Ponk Aviation · Camano Island, WABuilt 1956 · S/N 33295 N6495BSanford George W Jr · Montross, VABuilt 1957 · S/N 29695 N6495KBauknecht Daniel P · Antigo, WIBuilt 1975 · S/N 15077730 N6495NBusiness Trip Corp Inc · Cape Coral, FLBuilt 1978 · S/N 21063069 N64962Wingsleasing LLC · Wichita, KSBuilt 1982 · S/N 17275659 N64964Dodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275660 N64966Hill Mark T · Gloucester, VABuilt 1982 · S/N 17275661 N6496BStartup Aviation Management LLC · Lakeway, TXBuilt 1957 · S/N 29696 N6496FFisher Justin T · Lewes, DEBuilt 1975 · S/N 18264204 N6496GJbm Aviation LLC · Mc Leansboro, ILS/N 15071996

Back to AD 87-20-03 R2