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.

N54844Dynasty Adventure Inc · Mentone, CABuilt 1981 · S/N 17275065 N54849Colorado Northwestern Community College · Rangely, COBuilt 1981 · S/N 17275066 N5484DAerobiz LLC · Lewes, DEBuilt 1979 · S/N 17272583 N54855Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275068 N5485HGiron Lawrence · Anchorage, AKBuilt 1975 · S/N 17265461 N5485KBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N 17274151 N5486ABas Part Sales LLC · Greeley, COS/N 21063464 N5486DFord Bernard DBA · Sidney, NYBuilt 1979 · S/N 17272585 N5486NTorgerson Roald L · Lewistown, MTBuilt 1980 · S/N 18267754 N5486SPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N R18201585 N5487BPotcake Aviation LLC · Missoula, MTBuilt 1979 · S/N 15283882 N5487KRingen Marvin O · Beaverton, ORS/N 17274153 N5488DCardoso Roberto Y · Montclair, CAS/N 17272586 N5488MPerson Michael · West Chester, PABuilt 1980 · S/N 15284596 N5488SJanssen Paul · New Castle, INBuilt 1980 · S/N R18201586 N548DGorowsky Craig · Tucson, AZBuilt 1979 · S/N 513-79 N548ECRaney James R · Tucson, AZBuilt 1976 · S/N 17702505 N548FDScattertown Holdings LLC · Montross, VABuilt 1977 · S/N 177RG1218 N548MAKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2006 · S/N 507-2006 N548MMLittle Atlas Air LLC · Montgomery, ILBuilt 1978 · S/N 177RG1326 N54905905 Cess LLC · Wilmington, DEBuilt 1981 · S/N 17275076 N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467 N5490BMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 15283884 N5490HSuperior Flying Services LLC · Superior, WIS/N 17265462 N54910Somboonsap Patanapong · Oakland Park, FLBuilt 1981 · S/N 17275077 N5491HSky Hogs LLC · Orange Park, FLBuilt 1975 · S/N 17265463 N5491KSale Reported · Rowland, NCSale reportedBuilt 1980 · S/N 17274156 N5491LWinter Sarah A · Hurst, TXBuilt 1980 · S/N 15284321 N5491PKs Aviation Inc · Atwater, CABuilt 1981 · S/N 15284958 N5492HAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1975 · S/N 17265464 N5493AValley Dairy Farms Inc · Roy, WAS/N 21063469 N5493RFreedom Flight Center Inc · Hardy, NEBuilt 1979 · S/N 172RG0064 N54946Goosfraba LLC · Huddleston, VABuilt 1981 · S/N 17275084 N54947Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275085 N5494PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15284959 N5494TCampbell Barry E · Prescott, AZBuilt 1982 · S/N R18201879 N54951Skylens LLC · Hammond, LABuilt 1981 · S/N 17275087 N54955Space 5 LLC · Fayetteville, GABuilt 1982 · S/N 17275089 N54956Fluke Dennis M · Sunset, TXBuilt 1981 · S/N 17275090 N5495ARzs Enterprises Inc · Finley, NDBuilt 1979 · S/N 21063470 N5495DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272587 N5495KI Fly High LLC · Mesa, AZBuilt 1980 · S/N 17274160 N5495QNovember Sierra Aviation LLC · Oneill, NES/N 15285113 N54960First Eclipse Ltd · Richmond, VAS/N 17275092 N5496HWilson Charles L · Seattle, WABuilt 1975 · S/N 17265466 N5497SVerbovskiy Vitaliy Viktorovich · Clovis, NMBuilt 1980 · S/N R18201589 N54983Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275098 N5498HGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 17265468 N5499QCronce Charles Scott · Pacifica, CABuilt 1981 · S/N 15285114 N549ACWhitaker James C · Washington, NCBuilt 2001 · S/N 449-2000

Back to AD 80-25-07 R1