Skip to content

Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N12757Altitude Aviation Group LLC · Christmas, FLBuilt 1965 · S/N 28-20776 N1275BWeisgram Ted · Corbett, ORBuilt 1995 · S/N 1287 N1275JEllis Keith W · Springfield, MOBuilt 1975 · S/N 275 N12760Decker Stephen Lee · Como, COBuilt 1973 · S/N 17262235 N12766Civil Air Patrol Flying Assoc Inc · Branford, CTBuilt 1973 · S/N 17262240 N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386 N12768Martin Thomas J · Lynden, WABuilt 1973 · S/N 17262242 N1276TShillieto Mark C · Wilmington, OHBuilt 1972 · S/N 28-7225393 N1276UStelham Co · Olive Branch, MSBuilt 1976 · S/N 17266971 N12772Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1973 · S/N 17262245 N12776Oviedo Juan · Oak Point, TXBuilt 1973 · S/N 17262249 N12777Mana Kai Flying LLC · Makawao, HIBuilt 1973 · S/N 17262250 N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252 N1277AWagner Tyler M · Sitka, AKBuilt 1951 · S/N 18-1072 N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982 N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150 N127826350 LLC · Yorklyn, DES/N 17702387 N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256 N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261 N1278ARegistration Pending · Palmer, AKRegistration pendingBuilt 1951 · S/N 18-1074 N1278JBallester Alexis R · Mayaguez, PRBuilt 1975 · S/N 278 N1278TSmith Sullivan · Cookeville, TNBuilt 1972 · S/N 28-7225447 N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262 N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263 N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264 N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265 N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266 N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267 N1279XRegistered aircraftBuilt 1963 · S/N 152 N127AAnderson Eric H · Teaneck, NJBuilt 1975 · S/N 7-0109 N127AKSwan Logistics LLC · Toledo, OHS/N 2059 N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077 N127BDRegistered aircraftBuilt 2022 · S/N 620-2022 N127EYoung John C · Olathe, KSBuilt 2001 · S/N 2146 N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797 N127EMKrein Chris · Bismarck, NDS/N 121707 N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481 N127FRYoon Paul · Saint David, AZS/N 17275292 N127GSSanoski Gregory G · Talkeetna, AKS/N 12-273 N127JNNewman Jimmie L · Davenport, FLBuilt 2007 · S/N 24735 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N127KJSky Flowers Holding Group LLC · Sunrise, FLS/N 10248 N127LFFisher Nicholis W · Springfield, LAS/N 27 N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503 N127PMinard Robert Myron Jr Trustee · Laveen, AZBuilt 1997 · S/N 24672 N127PSParsa Aviation LLC · Boca Raton, FLS/N 6010 N127RBushby Harvey M Jr · Minonka, ILBuilt 1995 · S/N M-II-1110 N127TBenham Charles · Lorena, TXBuilt 1952 · S/N 18-2241 N127TGEberle Brian J · Newnan, GABuilt 2005 · S/N 21321

Back to AD 90-04-06 R1