Skip to content

Registered aircraft · 25,370

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.

N3916HCopeland Greg · Lake Dallas, TXBuilt 1979 · S/N 240897 N3917H802 Aviation LLC · Colchester, VTBuilt 1979 · S/N 24-0898 N3918QAviation Academy LLC · Wichita, KSBuilt 1971 · S/N 17260018 N3919QMinot Aero Center · Minot, NDBuilt 1971 · S/N 17260019 N391ACAmerican Champion Aircraft Corp · Rochester, WIBuilt 1979 · S/N 400-98 N391AJOreck Tom · Asheville, NCBuilt 2004 · S/N 954-2004 N391DMKirvida James M · Dellwood, MNFirst renewal noticeBuilt 2000 · S/N 1302-2000 N391MAMilton Chuck · Onalaska, WABuilt 2002 · S/N 440-2002 N3921QRawareo LLC · Warsaw, MOS/N 17260021 N3924QGarcia Theodore · Fullerton, CABuilt 1971 · S/N 17260024 N3925HSale Reported · Corona, CASale reported, pending cancellationBuilt 1979 · S/N 24-0903 N3925QFerrin Aviation LLC · Rome, GAFirst renewal noticeBuilt 1971 · S/N 17260025 N3926QLeaseair LLC · Wilmington, DEBuilt 1971 · S/N 17260026 N3927Lani Lea Sky Tours LLC · Honolulu, HIS/N 17276103 N3927QHyatt Eric D · Bainbridge, GABuilt 1971 · S/N 17260027 N3928NVose Richard C · King Of Prussia, PAS/N 680062 N3929Lani Lea Sky Tours LLC · Honolulu, HIS/N 17276061 N3929QMonk Steven M · Lake Tomahawk, WIBuilt 1971 · S/N 17260029 N3932QZimmer Jed Michael · Quincy, WAS/N 17260032 N3933HRoberts William J Jr · Apex, NCBuilt 1980 · S/N 24-0981 N3934QChase William R Jr · Enfield, NHBuilt 1971 · S/N 17260034 N3935QBeaufort Flight Training LLC · Beaufort, SCBuilt 1971 · S/N 17260035 N3938NSundance Aviation Inc · Richland, WABuilt 1968 · S/N 680065 N3938QGreen Carl P · Columbia, MSBuilt 1971 · S/N 17260038 N393MAVandelay America LLC · Newport Beach, CABuilt 2007 · S/N 514-2007 N393TMAvion Acrobatico LLC · Waterloo, ILBuilt 1973 · S/N 82-73 N3940QN3940q LLC · Newnan, GABuilt 1971 · S/N 17260040 N3941HHamilton Todd J · May, TXBuilt 1980 · S/N 24-0988 N3942NFlying Services Inc · Wilmington, DEBuilt 1968 · S/N 680007 N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042 N3943Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1984 · S/N 17276186 N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044 N3948QCitabria Inc · Auburn, CABuilt 1971 · S/N 17260048 N3949QTuschen James E · Rockford, ILBuilt 1971 · S/N 17260049 N394RBJones Luther L · Covington, LABuilt 1999 · S/N 837-99 N394RLLynn Robert C · Cheyenne, WYBuilt 2017 · S/N 588-2017 N3950QDieter Jason W · Midlothian, VAS/N 17260050 N3951QGarcia Larry M · Garden Valley, CABuilt 1971 · S/N 17260051 N3952QLloyds 172 LLC · Moore, OKS/N 17260052 N3957QRwm Aviation LLC · Kalispell, MTBuilt 1971 · S/N 17260057 N3958QFisher Gregory S · Franklin, WIBuilt 1971 · S/N 17260058 N3959POmaha Aircraft LLC · Blair, NES/N P21000075 N395TEast Iowa Air Inc · Bennett, IABuilt 2023 · S/N 633-2023 N395THChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274174 N3960QLastochka LLC · Kalispell, MTBuilt 1971 · S/N 17260060 N3962QKalstrom William M · Ekalaka, MTBuilt 1971 · S/N 17260062 N3963HDiamant Zafrir · Las Vegas, NVBuilt 1980 · S/N 24-0995 N3964NListowski John Paul · Galveston, TXBuilt 1968 · S/N 680008 N3967QPeterson Dennis E · Cambridge, MNBuilt 1971 · S/N 17260067 N3968NJohnson David E · Sunfish Lake, MNBuilt 1968 · S/N 680009

Back to AD 80-25-07 R1