Skip to content

Registered aircraft · 6,349

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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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.

N9939LPaquet Michael D · Milton, FLS/N AA1B-0239 N993GWSol Aviation LLC · Salem, ORBuilt 2012 · S/N 000219 N9941LWelch Steven R · North Aurora, ILS/N AA1B-0241 N9944LSimpson Robert W · Farmerville, LABuilt 1973 · S/N AA1B-0244 N9946URiffel Betty Grace · Clinton, MOBuilt 1978 · S/N AA1C0161 N9949ULindquist Bonnie C Trustee · Webster, MNBuilt 1978 · S/N AA1C0163 N994ACCoonan James A · Streator, ILBuilt 2019 · S/N JA395-07-14 N994RSShane Richard D · Canandaigua, NYBuilt 1978 · S/N 15282505 N9953UCarey William H · Henderson, NVS/N AA1C0169 N9958LGilbert Michael D · Grants Pass, ORBuilt 1973 · S/N AA1B-0258 N9959LIkaros Aviation Group Inc · Naperville, ILBuilt 1973 · S/N AA1B-0259 N9960LRegistered aircraftBuilt 1973 · S/N AA1B-0260 N9962LHjermstad Scott J · Louisville, NEBuilt 1973 · S/N AA1B-0262 N9963LQuadrex Associates Inc · Indialantic, FLBuilt 1973 · S/N AA1B-0263 N9970LOates Thomas J · Chicago, ILBuilt 1973 · S/N AA1B0270 N9971LMarmon Joanna A · Merion Station, PABuilt 1973 · S/N AA1B-0271 N9972TOliver Randy Martin · Kent, WABuilt 1978 · S/N 38-78A0266 N9973RHeller Kurt L · Willow, AKBuilt 1982 · S/N 898 N9973TMenno David L · Lancaster, NYBuilt 1978 · S/N 38-78A0268 N9974TArgos Retail LLC · Mcallen, TXBuilt 1978 · S/N 38-78A0269 N9975LSass Ryan E · Pleasanton, CABuilt 1973 · S/N AA1B-0275 N9976TAlvarez Humberto H · Kingsville, TXBuilt 1978 · S/N 38-78A0270 N9978TMaletich Dustin S · Pilot Rock, ORBuilt 1978 · S/N 38-78A0271 N9979UBest David E · Newalla, OKBuilt 1978 · S/N AA1C0173 N9980LJenkins Allyn Terry · Boynton Beach, FLBuilt 1973 · S/N AA1B-0280 N9981TLadegard Paul E · Wasilla, AKBuilt 1978 · S/N 38-78A0272 N9982LCarter Robert J Jr · Oak Ridge, TNBuilt 1973 · S/N AA1B-0282 N998TJJenkins Teal W · Buckeye, AZBuilt 2007 · S/N 90866 N9991LStory Norwood P Jr · Plano, TXBuilt 1973 · S/N AA1B-0291 N9993HCarlsfrom Thomas A · Bonita Springs, FLBuilt 1943 · S/N 5-1473 N9994LMclanahan John P · Culpeper, VABuilt 1973 · S/N AA1B-0294 N9995LGoertz Anton O · Santa Fe, NMBuilt 1973 · S/N AA1B-0295 N9996LPadilla Francisco · Spring, TXS/N AA1B-0296 N9997LTaylor Eric C · Mooresville, INBuilt 1973 · S/N AA1B-0297 N9999LWhitman John L · Coopersville, MIBuilt 1973 · S/N AA1B-0299 N999EOwens Wilbur · Rancho Palos Verde, CABuilt 1947 · S/N 12-2060 N99BLLeaman Gary R · Lafayette, INBuilt 1999 · S/N 191 N99DTHougham Roger F · Mc Lean, ILBuilt 1975 · S/N 1122-75 N99HRSilver Express Co · Miami, FLBuilt 1978 · S/N 15282972 N99HTKnowles John H · Iowa Park, TXS/N 099 N99JQQuayle John P · Pleasanton, CABuilt 1999 · S/N 1374-99 N99NRCarney Jeffery L Sr · Gallatin, TNBuilt 1974 · S/N 1069-75 N9CQSemeine Roman · Brooklyn, NYBuilt 1972 · S/N AA1B-0085 N9ECWagner Roger P · Jasper, TXBuilt 1988 · S/N 2033L N9FALandon Easton · Quartz Hill, CAS/N AA1A-0336 N9FCEldridge Erin A · Seabrook, TXBuilt 1993 · S/N 2029L N9KAEssex Aviation · Indianapolis, INS/N 15284552 N9TSRegistered aircraftBuilt 1986 · S/N 1378 N9VTWarren Keith · Delta Junction, AKBuilt 1978 · S/N 1271-78

Back to AD 80-25-02 R2