Skip to content

Registered aircraft · 20,678

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N11MBYoungstown Warren Development Partners · Youngstown, OHBuilt 1979 · S/N 17272769 N11NNLamm Russell N · Wernersville, PABuilt 1974 · S/N 17263954 N1200USowers Harry D · S Bloomingvle, OHBuilt 1978 · S/N 17272035 N1200VTampa Bay Aviation Inc · Clearwater, FLBuilt 2006 · S/N 172S10394 N1201EN1201e LLC · Wilmington, DEBuilt 2006 · S/N 172S10352 N1201FRed Door Aviation LLC · Dover, DEBuilt 1979 · S/N 17272966 N1203FRawson Aviation LLC · Collinsville, OKBuilt 1979 · S/N 17272968 N1205UBordeaux Marvin · Willcox, AZBuilt 1976 · S/N 17266904 N12064Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 2005 · S/N 172S9839 N1206UFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2006 · S/N 172S10417 N1207UKasakoff Lloyd · Diamond Bar, CAS/N 17266906 N12082Lopez George · Dover, DES/N 17261797 N12090Diaz Aviation LLC · Mount Upton, NYBuilt 1973 · S/N 17261800 N12091K D Farms Inc · Cosmos, MNBuilt 1973 · S/N 17261801 N12097Aerolease Aviation Rental LLC · Cartersville, GABuilt 1973 · S/N 17261807 N12098Traywick James D · Cope, SCBuilt 1973 · S/N 17261808 N120DHHiester Donald J · Sicklerville, NJBuilt 1961 · S/N 17248694 N120FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13210 N120SUOklahoma State University · Stillwater, OKBuilt 2016 · S/N 172S11674 N12100Tita LLC · Fajardo, PRBuilt 1973 · S/N 17261810 N12104Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261812 N12105N12105 LLC · Tavares, FLBuilt 1973 · S/N 17261813 N1210KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13048 N12110Port Townsend Air LLC · Puyallup, WABuilt 1973 · S/N 17261815 N12113Arlins Aircraft Service Inc · Belgrade, MTBuilt 1973 · S/N 17261817 N12115Jones Kenneth A · Mogadore, OHBuilt 1973 · S/N 17261818 N12123Aerospatial LLC · Selah, WABuilt 1973 · S/N 17261822 N12128Temme Robert E · West End, NCBuilt 1973 · S/N 17261826 N12129Champagne Patrick D · San Angelo, TXBuilt 1973 · S/N 17261827 N1212MVondullen Ken A · Laplace, LABuilt 1970 · S/N 17259412 N1212USun Country Aero Club Inc · The Villages, FLBuilt 1976 · S/N 17266909 N12133Skoog Kurtis · Glennallen, AKBuilt 1973 · S/N 17261831 N12138Falcon Air LLC · Anchorage, AKBuilt 1973 · S/N 17261835 N1213FFlight Answers LLC · Miami Lakes, FLBuilt 1979 · S/N 17272972 N12141Aircraft Management Services Inc · Milton, FLS/N 17261837 N12147Carstens Sandra A · Cary, NCBuilt 1973 · S/N 17261842 N12148Railing Terry L · Lake Mills, WIBuilt 1973 · S/N 17261843 N1214UThomas William R · Eyota, MNBuilt 1976 · S/N 17266911 N12150Baker Daniel Ray · Jacksonville, FLBuilt 1973 · S/N 17261845 N12153Wertz Richard L · Huron, SDBuilt 1973 · S/N 17261848 N1215UCarbon Six LLC · San Diego, CAS/N 17266912 N12161Cessna 12161 LLC · Santa Rosa, CABuilt 1973 · S/N 17261851 N12168Boardman Thomas M · Greenwich, NYBuilt 1973 · S/N 17261855 N12169Hammond Donald L · Palmer, AKS/N 17261856 N1217070 Leasing LLC · Englewood, COBuilt 1973 · S/N 17261857 N12176Cardinal Wings Aviation LLC · Buckner, KYBuilt 1973 · S/N 17261860 N12180Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261864 N12181Great Landings Aircraft LLC · Arlington, INS/N 17261865 N12185Textron Aviation Inc · Wichita, KSS/N 172S13632 N12187Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261870

Back to AD 90-06-03 R1