Registered aircraft · 25,368

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.

N9053VFeauto Aviation Inc · Saint Cloud, FLBuilt 1968 · S/N 690004 N9054CDunlap Joseph A · Brainerd, MNBuilt 1978 · S/N R18200381 N90558Hagele Aviation LLC · Hillsboro, ORS/N 17274773 N9055CBison Aero LLC · Kalispell, MTBuilt 1978 · S/N R18200382 N9055LJavelin Citrus LLC · Erda, UTS/N 244-70 N9056VBare David · Colorado Springs, COBuilt 1968 · S/N 690004 N9057HAmoroso Ricardo C · Powder Springs, GABuilt 1975 · S/N 17265921 N9057LKing Nathan A · Dunkirk, MDS/N 769-70 N9057VBrossard Pierre · New Albany, MSBuilt 1968 · S/N 690005 N9058LLucius William C · Moosic, PABuilt 1970 · S/N 220-70 N9058VPellikan Jake E · Staten Island, NYBuilt 1968 · S/N 690006 N905AZN905az LLC · Miami, FLBuilt 1986 · S/N 17276651 N905KTmd Enterprises LLC · Amarillo, TXBuilt 2006 · S/N 1020-2006 N905KSZoppe Eduardo · Lakewood Ranch, FLBuilt 1985 · S/N 17276516 N905NRState Of Minnesota · Grand Rapids, MNBuilt 2006 · S/N 479-2006 N905WAMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269967 N9060HJ&S Flying Enterprises LLC · Zanesville, OHBuilt 1975 · S/N 17265922 N9060LShank Paul L · Gaithersburg, MDBuilt 1970 · S/N 275-70 N9061VRegistered aircraftBuilt 1968 · S/N 690007 N9062LR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 221-70 N9062VJacobsen Dennis S · Reno, NVBuilt 1968 · S/N 690009 N9064LHendrickson Don W · Helena, MTBuilt 1970 · S/N 247-70 N9064VMitchell Benjamin · Riverdale, UTBuilt 1968 · S/N 690010 N9065VRussell Robert D · Aurora, COBuilt 1968 · S/N 690009 N9066LPasco Gary R · Brockport, NYBuilt 1970 · S/N 773-70 N9066RForage Jean Pierre Md · Lakeway, TXBuilt 1978 · S/N R18200660 N9067LGabriel Thomas G · Clinton, PABuilt 1970 · S/N 774-70 N9067VAdventist World Aviation · Wilson, NCS/N 690010 N9068HGundlach Mark A · Fruitland, WABuilt 1975 · S/N 17265928 N9068RHrabe Dusten · Chamberlain, SDBuilt 1975 · S/N 18802095T N9068VPyle Brian D · Mooresville, NCBuilt 1968 · S/N 690012 N9069LCitabria Flyers LLC · North Salt Lake, UTBuilt 1970 · S/N 252-70 N9069VErban Bryce · Stillwater, MNBuilt 1968 · S/N 690011 N906AZN906az LLC · Miami, FLBuilt 1978 · S/N 15282474 N906KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272697 N906MDFive Rivers Flight Training LLC · Livermore, CABuilt 1976 · S/N 17268038 N906NCactus Pilots LLC · Tulsa, OKBuilt 2022 · S/N 1203-2022 N906WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17268112 N9070VPinneo Mark · Foley, ALBuilt 1968 · S/N 690013 N9071LWolfley Jody K · Mountain Home, IDS/N 276-70 N9073LRegistration Pending · Munford, TNRegistration pendingBuilt 1970 · S/N 776-70 N9073VOlsen Leif C · Richardson, TXBuilt 1968 · S/N 690013 N9074LTillotson Bradley T · Loveland, OHBuilt 1970 · S/N 777-70 N9074VLounsbury Joseph Jr · Palm Coast, FLBuilt 1968 · S/N 690015 N9075LSibbernsen William · Omaha, NEBuilt 1970 · S/N 778-70 N9075VRankin David W · Bend, ORBuilt 1968 · S/N 690002 N90763Apex Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 17275856 N9076CEvv Pilots Club Inc · Evansville, INBuilt 1978 · S/N R18200387 N9076VRegistration Pending · Morristown, TNRegistration pendingBuilt 1969 · S/N 690016 N9077C389 Fifth Street LLC · Placida, FLBuilt 1978 · S/N R18200388

Back to AD 80-25-07 R1