Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N40862Ratliff William Thomas III · Knoxville, TNBuilt 1973 · S/N 28-7405072 N40865Fischer William T · Ventura, CABuilt 1973 · S/N 32-7440066 N4086WMorgan Gabriel A Sr · Newport News, VABuilt 1967 · S/N 32-40137 N40874Jones Sherman Farrell · Buena Park, CABuilt 1973 · S/N 28-7425184 N40876Gray John W · Rohnert Park, CABuilt 1973 · S/N 28-7415100 N4087RWatt Nathan A · Walnut Creek, CABuilt 1967 · S/N 32-40405 N40881Hsu Feng · Albuquerque, NMS/N 28-7425185 N40882Flight Factory LLC · Danville, CABuilt 1973 · S/N 28-7415105 N4088FCole Warren G · Watkinsville, GABuilt 1976 · S/N 28-7725002 N4088RKako Retreat Center Inc · Russian Mission, AKS/N 32-40407 N408CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881119 N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184 N408LWParis Air Inc · Vero Beach, FLS/N 28-7716114 N408PBBaich Michael V · Bovey, MNBuilt 1979 · S/N 28-7911143 N408WBNew England Airlines · Westerly, RIBuilt 1972 · S/N 32-7240092 N408ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881669 N40903Boyer Aviation LLC · Kiel, WIBuilt 1973 · S/N 28-7415108 N40904Allred Klein Enterprise LLC · San Diego, CABuilt 1973 · S/N 28-7415109 N40905Martin James Christopher · South Jordan, UTBuilt 1973 · S/N 28R-7435140 N4090QWieczorek Alan · Lees Summit, MOS/N 28-7716171 N4090RWiebe Aerial Applications LLC · Peabody, KSBuilt 1967 · S/N 32-40410 N40913Matlock Joshua · Squaw Valley, CABuilt 1975 · S/N 32-7540126 N40925High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 28-7415112 N4092RWings Of Eagles LLC · Saline, MIBuilt 1968 · S/N 32-40413 N4092WM & M Aircraft LLC · Lewis Center, OHBuilt 1967 · S/N 32-40151 N40934Southern Style Equipment LLC · Sulphur, LABuilt 1974 · S/N 32-7440071 N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191 N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077 N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193 N40953Cws Capital Holdings LLC · Saint Petersburg, FLBuilt 1973 · S/N 28-7415118 N40963Grant Matthew D · Alvord, TXBuilt 1974 · S/N 28-7415120 N40965Portsmouth Flying Club LLC · Epsom, NHBuilt 1973 · S/N 28-7415121 N40966Skytech Hc Ltd · Fredericksburg, OHBuilt 1973 · S/N 28-7415122 N40967Mcbroom Darrin · Des Moines, IABuilt 1973 · S/N 28R-7435146 N40969Papa Bravo LLC · Decatur, ALBuilt 1974 · S/N 28-7410052 N4096WCruisers Pacific LLC · Discovery Bay, CABuilt 1967 · S/N 32-40159 N40972Terry Aaron D · Glendale, AZS/N 28-7425196 N40984Four Zero Niner LLC · Granger, IABuilt 1973 · S/N 28-7425199 N40987Besl Thomas J · Cincinnati, OHBuilt 1973 · S/N 28-7415126 N4098FN4098f LLC · Ypsilanti, MIBuilt 1976 · S/N 28-7715004 N4098QLongleaf Auction LLC · Williamston, NCS/N 28-7790471 N4098RLawler Christy · Livingston, MTBuilt 1968 · S/N 32-40406 N40993Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405159 N4099WWilde Stephen · Elverta, CAS/N 32-40162 N409AFThomas Douglas M Jr · Blue Bell, PABuilt 1966 · S/N 28-21915 N409AKHenderson Kim · Everett, WABuilt 1998 · S/N 3257072 N409CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881120 N409CCPappy Air LLC · Pickerington, OHBuilt 2023 · S/N 28020113 N409DParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020224 N409TPParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020073

Back to AD 87-08-08 R3