Skip to content

Registered aircraft · 22,430

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.

N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200 N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007 N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226 N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203 N15979Tron Aviation LLC · Newburgh, INBuilt 1973 · S/N 28-7310079 N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104 N1597JLs Aviation LLC · Searcy, ARS/N 28-24008 N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218 N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009 N15994Self Thomas C · Madisonville, TNS/N 28-7325222 N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210 N15999Emmert Jason L · Douglas, WYBuilt 1973 · S/N 28-7310081 N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845 N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245 N159ERTetterton Marshall O · Crescent City, FLBuilt 1989 · S/N 2841211 N159LHFarmingdale State University · Farmingdale, NYS/N 2842200 N159NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842031 N15BCWingsleasing LLC · Wichita, KSBuilt 1964 · S/N 28-1712 N15BREllis David E Jr · Midlothian, TXBuilt 1978 · S/N 32R-7880004 N15CASpirit Of Life Ministries International Inc · Carthage, TXBuilt 2005 · S/N 3257401 N15CBAaviation LLC · Telford, PABuilt 1976 · S/N 28R-7635291 N15CHOrlando Flight Academy Inc · Apopka, FLBuilt 1974 · S/N 28-7415277 N15KFH Aviation LLC · Celina, TXBuilt 1980 · S/N 32-8006073 N15MZCaillarec Philippe · Le RheuNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28R-7803274 N1601SRussell Bryan E · Joshua, TXS/N 28-7790057 N160RFYank-N-Bank LLC · Greeley, COBuilt 1966 · S/N 28-21867 N160THolmberg Michael G · Hinckley, OHBuilt 1978 · S/N 28-7816373 N160TPContrail Aviation Inc · Cheboygan, MIBuilt 1963 · S/N 28-796 N161AWAir Ward Inc · Columbia, CABuilt 1979 · S/N 28-8016078 N161BGWilson James R · Midlothian, VABuilt 1978 · S/N 287816527 N161DERegistered aircraftBuilt 1977 · S/N 28-7816295 N161KMParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716136 N161MABarnes Gordon R · Manalapan, NJBuilt 2000 · S/N 3257161 N161MBKerf 25 Corp · Wilmington, DEBuilt 1982 · S/N 28-8216163 N161PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841156 N161RPCrucial LLC · Kalispell, MTBuilt 1982 · S/N 32R-8213049 N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508 N161SWLober Cameron K · Matthews, NCBuilt 1966 · S/N 28-3752 N161TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881549 N1622PBaker Kenneth C · Brenham, TXBuilt 1992 · S/N 3213040 N16244Oakland William S · New Port Richey, FLBuilt 1973 · S/N 28-7305211 N162505b Aviation LLC · Duncan, OKBuilt 1973 · S/N 28-7305212 N16252Robbins Warren N · Chandler, AZBuilt 1973 · S/N 28-7305213 N16253Quincy Aircraft LLC · Quincy, ILS/N 32-7340080 N16257Chauvet Nicolas · North Kingstown, RIBuilt 1973 · S/N 28-7305216 N1625JCain Philip K · Escondido, CABuilt 1968 · S/N 28-24818 N16269Kelley John Charles · Hot Springs Ntl, ARBuilt 1973 · S/N 32-7340081 N1626JLawrence Gavin · Borger, TXBuilt 1967 · S/N 28-24013 N16273Taildraggers LLC · Syracuse, KSBuilt 1973 · S/N 28-7305217 N16278Cademartori Joel T · Norris, TNBuilt 1973 · S/N 28R-7335121

Back to AD 87-08-08 R3