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.

N8088BRegistered aircraftBuilt 1979 · S/N 32-7940250 N8088EMoscardelli David · Mount Pleasant, MIBuilt 1979 · S/N 28-7921045 N8088HCosey R Daniel · Knoxville, TNBuilt 1979 · S/N 28-7921046 N8088TCorcoran Brandon P · Ashland, ORS/N 28-7921053 N8088ZFritch Michael Trustee · Orem, UTBuilt 1979 · S/N 28-7921054 N8089BBader Bradley C · Monroe, WIS/N 28-7921057 N8089CNelco Farms Inc · Fairfield, IAS/N 28-7690102 N8089VPhb LLC · Mesa, AZBuilt 1979 · S/N 28-7921060 N8089WBrind F Alan · Ionia, NYFirst renewal noticeBuilt 1965 · S/N 28-2180 N808DCWaters John Klas · San Marcos, CABuilt 1976 · S/N 28-7690456 N808DLSons Aviation Inc · Moody, ALBuilt 1967 · S/N 32-40309 N808EHChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843935 N808KASchlomer Lyle M · Osseo, WIS/N 28-4583 N808KMCti Aircraft Leasing LLC · Memphis, TNS/N 2881301 N808MWMy Wings LLC · Senoia, GABuilt 1979 · S/N 28-7911316 N808NDSilver Express Co DBA · Miami, FLBuilt 1989 · S/N 2837011 N808RKGoehl Jeffrey A · College Station, TXBuilt 1974 · S/N 28-7415225 N808TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881701 N808VTInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 28R-7737051 N808WDJones Colby C · Honolulu, HIBuilt 1972 · S/N 28R-7235270 N80908International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-8016074 N8090ELeslie H Mcelhany DBA · Watertown, SDBuilt 1979 · S/N 28-8016072 N8090FDouglas Malik · Mcdonough, GABuilt 1976 · S/N 28-7790233 N8090LWilliams Chris B · Reno, NVBuilt 1979 · S/N 28-8090092 N8090TN8090t LLC · Austin, TXBuilt 1979 · S/N 32R-8029020 N8090YFlyin Gators LLC · New Smyrna Beach, FLBuilt 1979 · S/N 28-7911323 N8091RParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016077 N8091WClement Timothy S · Skidmore, MOS/N 28-2182 N8091XBlack Hunter F · Blanding, UTBuilt 1966 · S/N 28-21777 N8091YStevens Charles R · Williamsburg, MIBuilt 1979 · S/N 28-8016079 N80926Flight Leasing Corp · Wilmington, DEBuilt 1979 · S/N 28-8090098 N8092ERaleigh Flying Club LLC · Chapel Hill, NCBuilt 1979 · S/N 28-8090093 N8092GEarly Stephen · Sharpsburg, GABuilt 1979 · S/N 28-8090095 N8092HUnited States Air Force Owner · Hanscom Afb, MABuilt 1979 · S/N 28-8016082 N8092NCash Management Consulting LLC · Granite Springs, NYBuilt 1968 · S/N 28-25335 N8092WDidea Aviation LLC · Orlando, FLBuilt 1965 · S/N 28-2183 N80934Cogelia Joseph M · Winchester, VABuilt 1979 · S/N 28-8090105 N8093GFargo Jet Center LLC · Fargo, NDBuilt 1979 · S/N 28-8090100 N8093HSarraf Majid · Aliso Viejo, CABuilt 1979 · S/N 28-8090101 N8093NSaraland High School · Saraland, ALS/N 28-25336 N8094AMuhlenberg Barry Vk · Pottstown, PABuilt 1982 · S/N 32R-8213030 N8094CPowell David J · Endicott, NYBuilt 1975 · S/N 28R-7635130 N8094NEggan Mark A · Lee Center, NYBuilt 1968 · S/N 28-25337 N8094RDoll William J · Carlisle, PABuilt 1979 · S/N 28-7911325 N8094VJeppesen LLC · Champlin, MNBuilt 1979 · S/N 28-7911327 N8094WMatney Tara · Abingdon, VABuilt 1965 · S/N 28-2188 N8095ADay Gordon Jr · Fort Atkinson, WIBuilt 1979 · S/N 28-7911329 N8095GTrulock Todd N · Ontario, CABuilt 1979 · S/N 28-7911330 N8095HSimmer Aviation LLC · Missoula, MTBuilt 1979 · S/N 28-7911331 N8095MPlow Boy Aviation LLC · Forrest City, ARS/N 28-7911332

Back to AD 87-08-08 R3