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.

N51403Remigy Mathias E · Peterborough, NHBuilt 1980 · S/N 17274308 N5140BSesnic Aidan · Mukilteo, WABuilt 1979 · S/N 15283772 N5140ESadosky Paul · Glendale, WIS/N 17271733 N5140QMccoy David J · Perryton, TXBuilt 1973 · S/N 17261762 N5140RAshby Artie Dale Jr · Madison, ALBuilt 1979 · S/N 172RG0041 N5141KGilbertsville Flying Service LLC · Gilbertsville, PABuilt 1980 · S/N 17273983 N5141RServant Air Ministries Inc · Merritt Island, FLBuilt 1974 · S/N 17263358 N5141SChamberlin George W · Greenville, TXBuilt 1980 · S/N R18201509 N5143JSkywarrior Flight Training Inc · Pensacola, FLS/N 17273713 N5143XHardin John W · Fort Myers, FLS/N 669 N51448Haley Robert · Livermore, CABuilt 1980 · S/N 17274313 N5144BCloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283774 N5144LEmpire Aviation · Oxford, NCBuilt 1980 · S/N 15284270 N5144RBuffalo Flying Club Inc · Ayr, NDBuilt 1974 · S/N 17263361 N5144TAir Trac Inc · Pasco, WABuilt 1966 · S/N 484 N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851 N5145ESierra Pacific Aviation · Willits, CAS/N 17271735 N5145KZulu Jets LLC · Boerne, TXBuilt 1980 · S/N 17273986 N5145XAnderson Aviation LLC · Hillsboro, NDBuilt 1969 · S/N 671 N5146SBowden Mark R · Kansas City, MOBuilt 1980 · S/N R18201511 N5146TMattson Randall · Richvale, CAS/N 118 N5146VFischer John W · Waukesha, WIBuilt 1980 · S/N 172RG0455 N5146WN5146w LLC · Willow Spring, NCS/N P21000645 N5146XChart-Airs LLC · West Terre Haute, INBuilt 1969 · S/N 672 N51470Merryman Stephen R · Beach City, TXBuilt 1975 · S/N 17265816 N5147EDirty Side Down LLC · Noblesville, INBuilt 1978 · S/N 17271737 N5147HBeyond Willpower Inc · Shreveport, LABuilt 1975 · S/N 17265349 N5147KCline Aircraft LLC · Mena, ARBuilt 1975 · S/N 17264522 N5147NMace Robert C Jr · Gold Canyon, AZS/N 17261417 N5147RKirkland Kerry G · Spring, TXBuilt 1974 · S/N 17263364 N5147UCox Coleman Haynie · Honea Path, SCBuilt 1980 · S/N 172RG0259 N5147XBrown Russell J · Mahtomedi, MNBuilt 1969 · S/N 673 N5148HMalad Aviation LLC · Bliss, IDBuilt 1975 · S/N 17265350 N5148JTc Cavu Club LLC · Traverse City, MIS/N 17273715 N5148KHetteen David D · Camano Island, WABuilt 1980 · S/N 17273988 N5148TKloss Matthew Joseph · Rew, PABuilt 1967 · S/N 567 N5149EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271738 N5149R5149r LLC · Manhattan, MTBuilt 1974 · S/N 17263366 N5149XAmboni Sinesio Jr · Wasilla, AKBuilt 1969 · S/N 103 N514FVenohr Robert E · Aurora, COBuilt 2009 · S/N 514-2009 N514LLLenahan Lawrence M · Scottsdale, AZBuilt 1968 · S/N 680152 N514MDPerez Pedro J · Mayaguez, PRBuilt 1975 · S/N 17266476 N514MLPikes Private Planes LLC · Danville, KYBuilt 1968 · S/N 680178 N514RBOsprey Holding Company LLC · Foley, ALS/N 17265552 N514TCChildress Anthony H · Frisco, TXBuilt 1973 · S/N 17701995 N5150DTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272435 N5150UMolina Monreal Angel Humberto · Sahuarita, AZS/N 172RG0261 N51515Wolfe Douglas S · Yucaipa, CABuilt 1980 · S/N 17274316 N5151BTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 15283778 N5151LTownsend Richard · Barrington, NHBuilt 1980 · S/N 15284273

Back to AD 80-25-07 R1