Skip to content

Registered aircraft · 20,486

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N1341PN8075q LLC · Corpus Christi, TXBuilt 2007 · S/N 18281876 N1342SFreeworld Aviation LLC · Dixon, ILBuilt 1976 · S/N 18264905 N13433Seamoose Aviation LLC · Shelton, CTBuilt 2007 · S/N 18281878 N1343SComalander Christopher R · Beaumont, TXBuilt 1976 · S/N 18264906 N1344UGrit Services LLC · Manila, ARBuilt 1962 · S/N 18254544 N1345SGrant Larry · Sebring, FLBuilt 1976 · S/N 18264908 N1347SEskridge Steven Barry · Winona, MSBuilt 1976 · S/N 18264910 N1349SSwiss Edm Wirecut Inc · Prospect Heights, ILBuilt 1976 · S/N 18264912 N134DBBlue Skies27 LLC · Los Angeles, CABuilt 2000 · S/N 18280808 N134DJH2k Farms LLC · Phoenix, AZBuilt 2019 · S/N 18283065 N134RFMaverick Jet Leasing Inc · Wilmington, DES/N U20602719 N13500Caldwell Bob · Columbus, MSBuilt 1980 · S/N 18053168 N1351SEllard James M · Danielsville, GABuilt 1976 · S/N 18264914 N1352SEjw Enterprises LLC · Aguila, AZS/N 18264915 N1353SHerrick Kendall D · Johnson, KSS/N 18264916 N1354ESandra And Mose Rucker III LLC · Perrineville, NJBuilt 1982 · S/N 18268175 N1355SFlight Services Limited LLC · Bennett, COBuilt 1976 · S/N 18264918 N1356MYbarra Xavier · Uvalde, TXS/N 18264294 N1356STc Aviation LLC · Atlanta, GABuilt 1976 · S/N 18264919 N13574Warner Aric D · Rosamond, CAS/N 7108 N1357SSmith & Smith Inc · Hurricane, WVBuilt 1976 · S/N 18264920 N1359BLagos Aero LLC · Houston, TXBuilt 2007 · S/N 18281880 N1359MJtal Holdings LLC · Wilmington, DEBuilt 1975 · S/N 18264296 N135ANegative Ghost Rider LLC · Bangor, MEBuilt 1966 · S/N 185-0986 N135DMHarris Michael G · Spokane, WABuilt 1976 · S/N 18052635 N135FPointon Aviation LLC · Baraboo, WIBuilt 1965 · S/N 18256502 N135TDDunlay Regis Terry · Albuquerque, NMBuilt 2019 · S/N 18283082 N1361VLeduc Richard · Mazama, WABuilt 1974 · S/N U20602584 N1363SAlabama Law Enforcement Agency · Montgomery, ALBuilt 1976 · S/N 18264926 N1365BSholton Birgitte · Wasilla, AKBuilt 1971 · S/N 18052228 N1365MDaftarian Michael M Md · Paradise Valley, AZBuilt 1975 · S/N 18264299 N1368SN1368s LLC · Eau Claire, WIBuilt 1976 · S/N 18264931 N136JRaichl John P · Astoria, ORBuilt 1962 · S/N 205-0136 N136QRice James A · Holden, WVBuilt 1959 · S/N 52163 N136STScull Timber Co Inc · Tenaha, TXBuilt 1978 · S/N 18266476 N136TVReid Brian M · Boise, IDBuilt 1958 · S/N 51388 N1370SGolfbanks Leasing Partnership · Geneva, INBuilt 1976 · S/N 18264933 N1372VBoland Matthew S · Anchorage, AKS/N U20602588 N1374SRenninger Log Homes · Meeker, COS/N 18264936 N1376MBauman Cecil Davis · Nashville, TNBuilt 1975 · S/N 18264303 N1376SClarklind Farms · Tulare, CAS/N 18264938 N1378SEngle William A · Bend, ORBuilt 1976 · S/N 18264940 N1379SMorris William Alan · Newnan, GABuilt 1976 · S/N 18264941 N137PFerguson Frampton Z · Furman, SCS/N 20608304 N1382MRegan Arthur R · Green Valley, AZBuilt 1975 · S/N 18264305 N1384SAdventure Aviation LLC · Fresno, CABuilt 1976 · S/N 18264946 N1385MPecha James C · Binghamton, NYBuilt 1975 · S/N 18264307 N1386EWitsoe Kathleen · Knoxville, TNBuilt 1982 · S/N 18268176 N1386MJohnson Shannon L · Granite Falls, MNBuilt 1971 · S/N 18260826 N1386SLangel Joseph J · Lakeville, MNBuilt 1976 · S/N 18264947

Back to AD 84-10-01 R1