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.

N12RFMckay Jonathan S · Chesapeake, VAS/N 21057612 N12VMS & R Air Inc · Asheville, NCBuilt 1977 · S/N 21061697 N12WDHamburg Jeffrey · Corsica, SDS/N 57480 N12WRJjc Flyers LLC · Gladwin, MIBuilt 1975 · S/N 18263552 N1301LFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700641 N1302GDarby Patricia Petosky · Midland, TXBuilt 1964 · S/N 18255562 N1302LStelling Scott W · Johns Island, SCBuilt 1975 · S/N 18263615 N1302SSetnar Stephen Roger · Seaford, DES/N 18264868 N1303SClemens Dennis Patrick · Arnold, CABuilt 1976 · S/N 18264869 N1308SCecil Donald C · Willows, CABuilt 1976 · S/N 18264873 N1309MReny Donald Cyril Jr · League City, TXBuilt 2008 · S/N 18282050 N1309SBlackburn Mark R · Saint Paul, KSBuilt 1976 · S/N 18264874 N130MEPetersens Marine Services Corp · Ridge, NYBuilt 2000 · S/N 18280686 N130TCVogt Richard L · Panama City Beach, FLBuilt 1976 · S/N 18264999 N1311SCutlass 661 LLC · Orange Park, FLBuilt 1976 · S/N 18264876 N1312SMid Valley Aviation LLC · Groveland, CAS/N 18264877 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N1315MSpitzer John R · Rockford, ILBuilt 1975 · S/N 18264285 N1317MScallcess LLC · Boynton Beach, FLBuilt 1975 · S/N 18264287 N1317SWarrior Ink · Whittier, CABuilt 1976 · S/N 18264881 N1318PDye Paul C · Mc Neal, AZBuilt 1965 · S/N 185-0871 N1319EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268173 N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N131WCVoigt Aviation Inc · Park Rapids, MNS/N 20608034 N131YBeli Christopher J · Oregon, OHS/N 18052073 N1320SInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 18264884 N1321SKibler Ronald P · Kennesaw, GABuilt 1976 · S/N 18264885 N1322RMccormick Philip G · Pine Grove, CABuilt 1980 · S/N 18504122 N1323EHu Zhehua · Sunnyvale, CAS/N 18268174 N1323MWatson Laura · Gates Mills, OHBuilt 1975 · S/N 18264288 N1325SD Angelo Holdings Inc · Gilbert, AZBuilt 1976 · S/N 18264889 N1327SFields Leif D · Gridley, CABuilt 1976 · S/N 18264891 N13280Chapman John · San Antonio, TXBuilt 1962 · S/N 185-0402 N1328SScott Adrienne Diann · College Station, TXBuilt 1976 · S/N 18264892 N13297Borchers Lee A Trustee · Independence, ORBuilt 1980 · S/N 18053167 N1329UA C W Inc · Gonzales, LABuilt 1982 · S/N 21064687 N132DMWilliams Robin M · Belgrade, MTBuilt 1975 · S/N 18052628 N132HMMichels Agribusiness Inc · Plentywood, MTBuilt 1978 · S/N R18200844 N132MEPena Jairo · Catharpin, VABuilt 2000 · S/N 18280690 N132PSU S Department Of The Interior · Boise, IDS/N 20608278 N1331MRegistered aircraftBuilt 1985 · S/N 21064903 N1331SScenic Adventures LLC · Silverthorne, COBuilt 1976 · S/N 18264895 N1332SCottrell Brian D · West Palm Beach, FLBuilt 1976 · S/N 18264896 N1333TWoodford Michael F · Fabius, NYBuilt 1969 · S/N T210-59108 N1336SJ And D Petroleum Co · Tallahassee, FLBuilt 1976 · S/N 18264899 N1338BSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608331 N133DSHagopian Donald D · Van Nuys, CABuilt 1965 · S/N 18256837 N133TSHunter Stephen Eugene · Grace, MSBuilt 1966 · S/N 18257883 N133VWAlpine Katmai LLC · Alpine, WYBuilt 1975 · S/N 18263927

Back to AD 84-10-01 R1