Skip to content

Registered aircraft · 20,483

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.

N2467CKsg Capital LLC · Casper, WYBuilt 2000 · S/N 18280789 N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669 N2467GShort David J · Warrensburg, MOBuilt 1959 · S/N 51767 N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567 N2468BRegistered aircraftBuilt 1970 · S/N 18260274 N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768 N2468FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 18280780 N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568 N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669 N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569 N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369 N246ARMaravillas Ng LLC · Cupertino, CABuilt 2023 · S/N 18283215 N246BCKeystone Solutions LLC · Higley, AZS/N 18259539 N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314 N246CGDickerson Realty Corp · Charlotte, NCS/N 18281485 N246ECKnight Air LLC · Wausau, WIS/N 21062435 N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659 N246LSJohnson Mark · Macon, MSS/N 32185 N246NSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608246 N246PAHugie Lucas R · Logan, UTS/N 18257487 N246TRegistered aircraftBuilt 1981 · S/N 18268091 N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822 N2470CMcclymond Tyler L · Grand Junction, COS/N 30770 N2470FMeridian Aviation LLC · Lincolnton, NCBuilt 2000 · S/N 18280890 N2470GBaillargeon Richard W · Springville, IABuilt 1959 · S/N 51770 N2470PFisher Air LLC · Cardington, OHBuilt 2000 · S/N 18280891 N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670 N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771 N2471DWestern Edge Aviation LLC · Dickinson, NDBuilt 2000 · S/N 18280892 N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671 N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571 N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674 N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672 N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572 N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372 N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773 N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573 N2474CArchitectural Industrial Rentals LLC · Wilmington, DEBuilt 2001 · S/N 18280978 N2474NWestbank Fishing LLC · Kiln, MSS/N 18280980 N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674 N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374 N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775 N2475QStumpf Walter · Tulsa, OKBuilt 1966 · S/N 18257675 N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375 N2476CBrown Jack P · Anchorage, AKBuilt 1954 · S/N 30776 N2476RBascom Richard J Trustee · Elkhart, IABuilt 1964 · S/N 18255576 N2477GRamsey Stephen C · Aspen, COBuilt 1958 · S/N 51777 N2477RJohnson Michael W · Kensington, OHBuilt 1964 · S/N 18255577 N2478FSchad Paul E · Gainesville, TXBuilt 1966 · S/N 18051680 N2478GGilliland Sandra K · Julian, NCBuilt 1959 · S/N 51778

Back to AD 84-10-01 R1