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.

N3132CBlack Eric · Fort Jones, CABuilt 1978 · S/N R18200238 N3132TUballe Ruben · Axtell, TXBuilt 1967 · S/N 17700432 N3133TGiddy Up Aviation LLC · Ada, OKBuilt 1967 · S/N 17700433 N3135EHerring Christopher E · Granbury, TXBuilt 1978 · S/N 17271447 N3137ERegistered aircraftBuilt 1978 · S/N 17271448 N31381Strobridge Mark D · Bunnell, FLBuilt 1982 · S/N 15285644 N3138CTurbo-Sphere Inc · Longmont, COBuilt 1978 · S/N R18200239 N3138TJones Daniel D · Ekron, KYBuilt 1968 · S/N 17700438 N313BLDaggett Keith W · Rockport, MEBuilt 1976 · S/N 17267097 N313CEAvidash LLC · Cape Coral, FLBuilt 1972 · S/N 886-72 N313KDOdonnell Daniel Gordon · Plymouth, MABuilt 1975 · S/N 17702353 N313MPAlpha Bravo Charlie 1 Corp · Houston, TXBuilt 1980 · S/N P21000573 N313MTNguyen Nhu-An T · Parkville, MDBuilt 1977 · S/N 356-77 N313WFSalisbury Peter R · White Bear Lake, MNBuilt 2001 · S/N 879-2001 N313WTCinotto Robert L · Rhome, TXBuilt 1979 · S/N P21000350 N3140TSuggs Helen T · Jacksonville, FLBuilt 1967 · S/N 17700440 N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449 N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441 N3142RSharp Media Group LLC · Kansas City, MOS/N R18201117 N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442 N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444 N3147NAgaliotis Paul E · San Martin, CAS/N 350 N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447 N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448 N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449 N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557 N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774 N314MAircraft Partner Holdings Inc Trustee · BerlinBuilt 2010 · S/N 524-2010 N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98 N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038 N314TRShalexco LLC · Salt Lake City, UTBuilt 1979 · S/N R18201086 N3151EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271453 N3151JStava Robert D · Brainard, NEBuilt 1980 · S/N T18803609T N3151XJoseph Stern · Sherman, TXS/N 17702399 N3153BSeverson James A Jr · Tualatin, ORBuilt 1983 · S/N P21000834 N3153TRegistered aircraftBuilt 1967 · S/N 17700453 N3155TRobbins Charles R · Trout Creek, MTBuilt 1967 · S/N 17700455 N3156TSpring Mitchell L · Saint Cloud, FLBuilt 1967 · S/N 17700456 N3157THollrah Kenneth R · Enid, OKBuilt 1967 · S/N 17700457 N3159EDinaland Aviation · Vernal, UTS/N 17271455 N3159TLown Alfred L · Elkhorn, NEBuilt 1967 · S/N 17700459 N315ACDuewall Danny · Midland, TXBuilt 2000 · S/N 421-2000 N315LKnobler Michael D · Santa Monica, CABuilt 1993 · S/N 24-3293 N315MTFly Mt Llp · Charlo, MTS/N 17267276 N315SBKusler Bradley D · Lincoln, NES/N 700005 N31617Valiair Limited Co Trustee · Casper, WYBuilt 1965 · S/N 515 N3164TOverflight LLC · Harahan, LABuilt 1967 · S/N 17700464 N3165EJlk Management LLC · Kerrville, TXBuilt 1978 · S/N 17271457 N3169TOwen James D · Fort Lauderdale, FLBuilt 1967 · S/N 17700469 N316ACheng Williams W · North Potomac, MDBuilt 1979 · S/N 17273226

Back to AD 80-25-07 R1