Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N9685HBoys Will Fly LLC · Mapleton, UTS/N 17266313 N9685VBlue Skies Aviation Of Wisconsin Inc · Pulaski, WIBuilt 1974 · S/N 17264464 N96867Skywarrior Flight Training Inc · Pensacola, FLBuilt 1984 · S/N 17276124 N9686HHope Lapsley G · Blountville, TNBuilt 1975 · S/N 17266314 N9686QPetter John W · Wallis, TXBuilt 1975 · S/N 17265770 N96879Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1984 · S/N 17276127 N9687QBron Chris R · Springfield, ILS/N 17265771 N9687VCothron Walter A · Angleton, TXBuilt 1974 · S/N 17264466 N9688QF And W Flyers Inc · Newman, ILBuilt 1975 · S/N 17265772 N9689QOptic Air LLC · Sioux Center, IABuilt 1975 · S/N 17265773 N968AAWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 17274332 N968HCMarsh Flying Services LLC · El Dorado, KSBuilt 1971 · S/N 17259752 N968LLewis University · Romeoville, ILBuilt 2006 · S/N 172S10148 N968LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12038 N968RCAmelia Reid Aviation LLC · San Jose, CABuilt 1984 · S/N 17276126 N968SPMindy Limited LLC · Muscatine, IABuilt 1999 · S/N 172S8170 N9690HConner Mark H · Wauna, WABuilt 1975 · S/N 17266317 N9690QRobinson Neil A · Madison, WIBuilt 1975 · S/N 17265774 N9690VAlbrecht William J Jr · Greenville, NCBuilt 1974 · S/N 17264469 N96911Luciano Edmund R · Anchorage, AKBuilt 1984 · S/N 17276132 N9691VNewman Philip · Georgetown, TXBuilt 1974 · S/N 17264470 N9692BAberdeen Flying Service · Aberdeen, SDBuilt 1981 · S/N 172RG0971 N96932Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 17276136 N9693HClear Creek Aviation LLC · Buffalo, WYBuilt 1975 · S/N 17266318 N9693QHughes Ronnie D · Cedar Park, TXBuilt 1975 · S/N 17265777 N9693VRabideau William J III · Stafford Springs, CTBuilt 1974 · S/N 17264472 N9694HFitch William R · Dubuque, IABuilt 1975 · S/N 17266319 N9694LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276598 N9694QBexbach North America LLC · Reno, NVBuilt 1975 · S/N 17265778 N9694VHaller Patrick C · York, SCBuilt 1974 · S/N 17264473 N9695HGoddard Robert J · Haverhill, MABuilt 1975 · S/N 17266320 N9696HMirror Image Inc · Belgrade, MTBuilt 1975 · S/N 17266321 N9696LAny Border LLC · Yankton, SDBuilt 1986 · S/N 17276599 N9697VWestern Edge Aviation LLC · Dickinson, NDBuilt 1974 · S/N 17264476 N9698HEagle Simulator LLC · Lake Oswego, ORBuilt 1975 · S/N 17266322 N9698VVermont Flight Academy Inc · South Burlington, VTBuilt 1974 · S/N 17264477 N9699VPiercy Danille Marie · North Bay Village, FLBuilt 1974 · S/N 17264478 N969FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10373 N969JHJls Aviation LLC DBA · Fredericksburg, VABuilt 1979 · S/N 17273547 N969LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12039 N969RRDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275850 N969SPB R S Leasing Inc · Wilmington, DEBuilt 1999 · S/N 172S8171 N969TTSmoketown Flight Center LLC · Smoketown, PABuilt 1973 · S/N 17261635 N96FASilver Express Co · Miami, FLBuilt 2005 · S/N 172S10002 N96FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13205 N96FRWoodward-Davis LLC · Nacogdoches, TXBuilt 1980 · S/N 17274184 N96RRDocter David Alan · New Braunfels, TXBuilt 1959 · S/N 47025 N9700HBrutko Barry J · Lebanon, PABuilt 1975 · S/N 17266323 N9700VStencel Lawrence E · Palm Coast, FLBuilt 1974 · S/N 17264479 N97019Mccreery Aviation Co Inc · Mcallen, TXBuilt 1984 · S/N 17276146

Back to AD 90-06-03 R1