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.

N20300Congressional Flying Club Inc · Gaithersburg, MDBuilt 1977 · S/N 17702656 N20301Fritz Leslie L · Redgranite, WIS/N 17261174 N20305Fundeen Kelly L · Anchorage, AKBuilt 1972 · S/N 17261176 N20310Nine G Aviation LLC · Holdrege, NEBuilt 1972 · S/N 17261180 N20312Cardinal Wings Aviation LLC · Buckner, KYBuilt 1972 · S/N 17261182 N20313Wilde Evan Theodore · Cupertino, CAS/N 17702657 N20314Steinberg Arleen M · Lincoln, MES/N 17261184 N20319Hurlbut Arthur G · Canton, NYBuilt 1972 · S/N 17261188 N2031QLight Sport Aeronautics LLC · Brooklet, GAS/N 177RG0431 N20320Seabreeze Aero Club LLC · Wilmington, DEBuilt 1972 · S/N 17261189 N20323Walla Walla University · College Place, WABuilt 1972 · S/N 17261190 N20327Registration Pending · Myrtle Beach, SCRegistration pendingBuilt 1972 · S/N 17261194 N20332N20332 LLC · Opa Locka, FLBuilt 1972 · S/N 17261197 N20336Pages Raymond J · Dayton, MDBuilt 1972 · S/N 17261201 N20339Grant David M · Bellingham, WABuilt 1977 · S/N 17702659 N20341American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261204 N20344Dunbar Martha C · Milford, MABuilt 1972 · S/N 17261207 N20345Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261208 N20346Hendrych Mark G · Pittsburgh, PABuilt 1972 · S/N 17261209 N20347Salvatori Fred · Atwater, CABuilt 1972 · S/N 17261210 N20348Red Oak Hawks LLC · Red Oak, IABuilt 1972 · S/N 17261211 N2034JMd Aero LLC · Somerton, AZBuilt 1978 · S/N T18803339T N2034NNorthstar Aviation Leasing LLC · Merritt Island, FLBuilt 1978 · S/N 15282073 N20352Airspacedfw LLC · Aurora, TXBuilt 1972 · S/N 17261215 N20353Aspen Aviation LLC · Ashland, OHBuilt 1972 · S/N 17261216 N20355N20355 LLC · Ypsilanti, MIS/N 17261217 N20357Skyway Leasing Inc · Lakeland, FLBuilt 1972 · S/N 17261219 N20358Ricky B'S Bodyshop Inc · Berthoud, COBuilt 1977 · S/N 17702661 N2035QDonn E Mount Realty Inc · Titusville, FLBuilt 1973 · S/N 177RG0435 N20360Jaynair Corp DBA · Middlebury, CTFirst renewal noticeBuilt 1972 · S/N 17261222 N20363Soldan Rafael · Wichita, KSS/N 17261225 N20364Piper Capital Growth Fund LLC · Scottsdale, AZBuilt 1972 · S/N 17261226 N20365Atlas Aero Training LLC · Casper, WYBuilt 1972 · S/N 17261227 N20366Depouli Raymond M · Enumclaw, WABuilt 1972 · S/N 17261228 N20368Beaver Flying Club Inc · Xenia, OHS/N 17261230 N2036QEtling Carl G · Edgar, NEBuilt 1973 · S/N 177RG0436 N20375May Matthew J · Weatherford, TXBuilt 1977 · S/N 17702664 N20376Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261237 N20377Moore James E · Arroyo Grande, CABuilt 1972 · S/N 17261238 N20381Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1972 · S/N 17261241 N20382Bass Philip D · Oviedo, FLS/N 17261242 N20384Rutherford Jeffrey L · Montgomery, ALBuilt 1972 · S/N 17261244 N20387Bybee Mark J · De Soto, ILBuilt 1972 · S/N 17261247 N20389Kcn Aero Club Inc · Overland Park, KSBuilt 1972 · S/N 17261249 N2038EStevens Michael J Jr · Humble, TXBuilt 1978 · S/N 17271127 N20390Mitiguy Aviation LLC · Stow, MABuilt 1972 · S/N 17261250 N20392Registration Pending · Miami, FLRegistration pending, pending cancellationBuilt 1972 · S/N 17261252 N20393Nextgen Flying LLC · Pigeon Forge, TNBuilt 1972 · S/N 17261253 N20394Eller Ralph E · Wasilla, AKS/N 17702668 N20398Laron W Hall · Hurricane, UTBuilt 1972 · S/N 17261258

Back to AD 80-25-07 R1