Skip to content

Registered aircraft · 22,416

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.

N98UAKnox Kevin J · Verdi, NVBuilt 1980 · S/N 28R-8018035 N98WLN7876p LLC · Monument, COBuilt 1998 · S/N 3257051 N98WWSmith Kent L · Doniphan, MOBuilt 1972 · S/N 28-7305179 N9900KLong Jimmie Brian · Cropwell, ALBuilt 2005 · S/N 2843617 N9900WGinther Wallace S · Quincy, ILBuilt 1967 · S/N 28-23420 N9901WWilliams Air Power Inc · Lowell, MIS/N 28-23421 N9902WDavis Robert D · Murfreesboro, TNBuilt 1967 · S/N 28-23422 N9904WTraweek Parrish C · San Manuel, AZBuilt 1967 · S/N 28-23424 N9906WBelmont Thomas M · Boca Raton, FLBuilt 1967 · S/N 28-23426 N9908KG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7890198 N9909WVafaie Frederick · Williston, FLBuilt 1967 · S/N 28-23429 N990AMAmerican Asset Leasing LLC · Aurora, ORBuilt 2022 · S/N 2881580 N990DMAerolance LLC · Atlantic Beach, FLBuilt 1977 · S/N 32R-7780357 N990FGFlightgest Academy LLC · Morrisville, NCBuilt 2023 · S/N 2881649 N990PHSanchez Leonides R · Alton, ILBuilt 1965 · S/N 28-2797 N990SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881877 N990VTWang Jinrao · Peachtree City, GABuilt 1969 · S/N 28-25910 N990XDl Industries Inc · Claremont, NHBuilt 1968 · S/N 28-5251 N9911WCategory One Aviation LLC · Atascadero, CABuilt 1967 · S/N 28-23433 N9913WJcl Equipment Rental · Coleta, ILBuilt 1967 · S/N 28-23434 N9914SSheffield Robert A · Mooresville, NCBuilt 1967 · S/N 28-23672 N9914WYellow Bird Flying Club · Toledo, OHBuilt 1967 · S/N 28-23435 N9915WAlimardani Shahrakh · Aguanga, CABuilt 1967 · S/N 28-23436 N9916WCulp Mason J · Bonney Lake, WABuilt 1967 · S/N 28-23438 N9917WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23439 N9919TFour M Aviation LLC · Saint Petersburg, FLBuilt 1994 · S/N 3213075 N991AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843807 N991ASAero Training Services Inc · Lake City, FLBuilt 1982 · S/N 32R8229019 N991BJSilver Express Co · Miami, FLBuilt 1986 · S/N 28-16008 N991CBBorg Derek F · Dallas, TXBuilt 1969 · S/N 28-11173 N991FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881869 N991TALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 2021 · S/N 28020029 N991VTCrosswinds Flying Club Inc · Bloomington, ILBuilt 1978 · S/N 28R-7837267 N9921WPhoenix Composite Solutions LLC · Oscoda, MIS/N 28-23443 N9924WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23448 N9925WBigler Danny L · Owasso, OKBuilt 1967 · S/N 28-23449 N9929WLalor David P · Montello, WIBuilt 1967 · S/N 28-23453 N992FGFlightgest Academy LLC · Morrisville, NCBuilt 2023 · S/N 2881693 N992TFFriendswood Aviation LLC · Friendswood, TXBuilt 1974 · S/N 28-7405237 N9933WSantangelo Troy M · Akron, PABuilt 1967 · S/N 28-23477 N9936WBrown Thrasher Aero LLC · Midland, GAS/N 28-23480 N99374Martin Douglas C · Boca Raton, FLBuilt 1965 · S/N 28-20942 N9938WBerger Alexander W · Richmond, VAS/N 28-23482 N9939WHoward Dwight · Beverly Hills, FLBuilt 1967 · S/N 28-23483 N993FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881830 N993GAtp Aircraft 9 LLC · Wilmington, DES/N 2881494 N9940WStaley Harvey Russell · Brandon, FLBuilt 1967 · S/N 28-23484 N9942WMccafferty R Joseph · Winfield, MOBuilt 1967 · S/N 28-23486 N9946CTheodorou Evangelos A · Bakersfield, CAS/N 28R-7931300 N9946WHangar 0205 Inc · Calhoun, GABuilt 1967 · S/N 28-23491

Back to AD 87-08-08 R3