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.

N64140C64140 LLC · Bloomington, INBuilt 1975 · S/N 17265043 N64147Summit Aviation Inc · Kingston, NYBuilt 1975 · S/N 17265047 N6414QHolmes Eric Bradley · Campbell, CABuilt 1967 · S/N 670493 N6414UHensley James R · Bertram, TXBuilt 1962 · S/N 2161 N64154Jw Skyhawk LLC · Austin, TXBuilt 1975 · S/N 17265049 N64155Lowcountry Flight LLC · Johns Island, SCBuilt 1975 · S/N 17265050 N64157Christensen Jeffrey S · Wisconsin Rapids, WIBuilt 1975 · S/N 17265052 N64159Flying 14 LLC · Spokane, WABuilt 1975 · S/N 17265053 N6415QWestern Plaines Aviation LLC · Greeley, COBuilt 1967 · S/N 670494 N6415RAlpine Aviation Of Fayetteville Inc · Prairie Grove, ARBuilt 1979 · S/N 172RG0179 N6415UMccall Richard A · Lexington, NCS/N 2162 N6415VPeter Prince Aviation Center LLC · Milton, FLS/N 172RG0677 N64160Glide Slope LLC · East Hampton, NYBuilt 1975 · S/N 17265054 N64161Aom Aircraft LLC · Orlando, FLBuilt 1975 · S/N 17265055 N64162Mccormick Philip D · Mount Pleasant, IABuilt 1975 · S/N 17265056 N64163Good Airplanes LLC · Oshkosh, WIBuilt 1975 · S/N 17265057 N64165Weaver Lynwood J Jr · Raleigh, NCBuilt 1975 · S/N 17265059 N6416USt Marie Jack W · Encinitas, CABuilt 1962 · S/N 2163 N6416WGallien Anthony · Livermore, CABuilt 1981 · S/N P21000773 N64173Training Planes LLC · Tampa, FLBuilt 1975 · S/N 17265065 N64174Sen Air Inc · Mckeesport, PABuilt 1975 · S/N 17265066 N6417JChapman Michael K · North Salt Lake, UTS/N 17273871 N6417NTaylor Michael Norman · Chino Hills, CABuilt 1978 · S/N 21062993 N64180Spanaflight LLC · Puyallup, WABuilt 1975 · S/N 17265069 N64181Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275529 N64184Arlington Flight Services Inc · Arlington, WABuilt 1975 · S/N 17265071 N64186Paraloft LLC · Mims, FLBuilt 1975 · S/N 17265072 N6418DAirways Aviation Inc · Grand Rapids, MNBuilt 1979 · S/N 17272793 N6418ELima-001 LLC · Muscatine, IAS/N 17272019 N6418TRobo Flight Air Support LLC · Inver Grove Height, MNBuilt 1985 · S/N R18202016 N64191Flycarolina LLC · Concord, NCBuilt 1975 · S/N 17265076 N64192Skyhawk Transport LLC · Hazel Green, ALBuilt 1975 · S/N 17265077 N64198Randy Goering Inc · Bend, ORBuilt 1975 · S/N 17265080 N64199Mutschler George Robert Jr · Bayfield, COBuilt 1975 · S/N 17265081 N6419MWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284718 N6419QFranklin Brian K · Lakewood Ranch, FLBuilt 1967 · S/N 670498 N6419VUrbana Aircraft LLC · Urbana, MDBuilt 1980 · S/N 172RG0680 N641CKrause Michael R · Sugar Land, TXBuilt 1980 · S/N 24-0973 N641MAAscent Aviation Inc · Duluth, MNBuilt 2005 · S/N 1400-2005 N641PPhilip Mark A · Leesburg, VABuilt 2004 · S/N 1357-2004 N64201Registration Pending · Lander, WYRegistration pendingBuilt 1975 · S/N 17265083 N64203Vance Nicholas D · Bluffton, OHS/N 17265084 N64209Kay Roland C · Wasilla, AKS/N 17265090 N6420BAlpha International Aircraft Inc · Lewes, DES/N 15283930 N6420MJensen Aviation Inc · Zephyrhills, FLBuilt 1980 · S/N 15284719 N6420QKelley Richard E · Spring Branch, TXBuilt 1967 · S/N 670499 N6420TJetran LLC · Horseshoe Bay, TXS/N R18202017 N6420ULambert Glen C · Las Vegas, NVBuilt 1962 · S/N 2250 N6420VKorson James · Yorkville, ILBuilt 1980 · S/N 172RG0681 N6420YFlying Amigos Aviation LLC · Las Cruces, NMBuilt 1981 · S/N 21064370

Back to AD 80-25-07 R1