Skip to content

Registered aircraft · 25,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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N6565VHodges Marshall E · Orange, TXBuilt 1980 · S/N 172RG0776 N65665Tomolonius Nathan · Newington, CTBuilt 1982 · S/N 17275810 N6566PSouthwinds Export Inc · Kissimmee, FLS/N 15285034 N65673Middletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1982 · S/N 17275814 N6567UDonnelly Lewis J · Warwick, NYBuilt 1962 · S/N 2349 N6567YMoeller Gerhard Walter · Goshen, OHBuilt 1981 · S/N 21064442 N6568EMcnerney John P · New Haven, VTBuilt 1978 · S/N 17272038 N6568RJofredo Corp · Zephyrhills, FLBuilt 1979 · S/N 172RG0202 N6568UHowell Larry A · Terrell, TXBuilt 1962 · S/N 2350 N65690690 LLC · Carmel, INBuilt 1982 · S/N 17275820 N65697Kemp Alan R · Niobrara, NEBuilt 1982 · S/N 17275821 N65698Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275822 N6569UXidis Nicholas J · Topeka, KSS/N 2351 N656DGD Gordon Aviation Inc · La Jolla, CABuilt 1977 · S/N R18200042 N656DMKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17270327 N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111 N656MFMelbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275818 N656SFSkyfusion II LLC · Atlanta, GAFirst renewal noticeS/N 17271302 N656TSN656ts LLC · Stuart, FLS/N 17275808 N656WCT3 Aerosports LLC · Vian, OKBuilt 1996 · S/N 781-96 N65704Skywarrior Flight Training Inc · Pensacola, FLBuilt 1982 · S/N 17275824 N65709Maverick Jet Leasing Corp · Wilmington, DEBuilt 1982 · S/N 17275827 N6570HBritten Air LLC · Natchitoches, LABuilt 1975 · S/N 17265492 N65710Beach Cities Aviation Academy LLC · Hawthorne, CABuilt 1982 · S/N 17275828 N65716Rtd Aviation LLC · Hillsborough, NJBuilt 1982 · S/N 17275831 N6571DBlazing Sun Aviation LLC · Encinitas, CABuilt 1979 · S/N 17272871 N6571HHentges Dave · Canby, MNBuilt 1975 · S/N 17265493 N6571UCrabtree Martin L · Sedalia, MOBuilt 1962 · S/N 2353 N65722Red River Aviation Services LLC · Altus, OKBuilt 1982 · S/N 17275835 N65724Registration Pending · Kalispell, MTRegistration pendingS/N 17275836 N6572DWalkowicz Eddie · Garland, TXBuilt 1979 · S/N 17272872 N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444 N65730Chuchuca Espinoza Jorge A · Clifton, NJS/N 17275840 N65735Bredvold Daniel M · Mendota Heights, MNS/N 17275842 N6573DPeabody Jeffery L · Vinemont, ALBuilt 1979 · S/N 17272873 N6573LBreland James · Laurel, MSS/N 15284443 N6573UAlvis Michael E · Lumberton, NCBuilt 1962 · S/N 2355 N65741Flycarolina LLC · Charlotte, NCBuilt 1982 · S/N 17275846 N65742Mustang Sally Aviation LLC · Camden, SCS/N 17275847 N65743University Of Central Missouri · Warrensburg, MOBuilt 1982 · S/N 17275848 N65746Son Cameron D · Groveland, FLFirst renewal noticeBuilt 1982 · S/N 17275851 N6574DFly Carolina LLC · Concord, NCBuilt 1979 · S/N 17272874 N6574GPplforu LLC · Fort Worth, TXBuilt 1979 · S/N 17273608 N65750Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 17275855 N65752Owens Flight Training LLC · Lafayette, LABuilt 1982 · S/N 17275857 N65753Flying Bulldogs LLC · Joplin, MOBuilt 1982 · S/N 17275858 N65758American Patrols Inc · Midland, TXBuilt 1982 · S/N 17275862 N6575QRegistered aircraftBuilt 1981 · S/N 15285274 N65767Chu'S Sky LLC · Brandon, FLBuilt 1982 · S/N 17275871 N65770Thompson Clinton J · Greer, SCBuilt 1982 · S/N 17275874

Back to AD 80-25-07 R1