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.

N50542Benoit Aerial Spraying Inc · Aroma Park, ILBuilt 1979 · S/N 1315-79 N5054BMichaud Martin Robert · Monte Vista, CABuilt 1979 · S/N 1313-79 N5054CAero Box Four LLC · Hammond, LABuilt 1979 · S/N 1148-79 N5054GRobbins Warren N · Chandler, AZBuilt 1979 · S/N 533-79 N5054HHutchins Charles L · Bayou Vista, TXBuilt 1975 · S/N 17265320 N5054KObe Aviation LLC · Doylestown, PABuilt 1979 · S/N 534-79 N5054LMarsh John E · Washington, DCBuilt 1979 · S/N 535-79 N5054NMorlock Joseph L · Slatington, PABuilt 1979 · S/N 1314-79 N5054PDoug Harris Aviation LLC · Pryor, OKBuilt 1979 · S/N 1149-79 N5054UBierlein Bruce M · Reese, MIS/N 321-79 N5054V5054v LLC · Knoxville, TNS/N 536-79 N5055GAgg Resources Inc · Doral, FLBuilt 1979 · S/N 1135-79 N5055HShaka Skies LLC · Kihei, HIBuilt 1975 · S/N 17265321 N5055NCleveland Soaring Society Inc · Hartville, OHBuilt 1979 · S/N 315-79 N5055PElectronic Research Co · San Diego, CABuilt 1979 · S/N 541-79 N5055RGreat Lakes Air Ventures LLC · Mason, MIBuilt 1974 · S/N 17263295 N50564Saratoga Seaplanes Inc · Saratoga Springs, NYBuilt 1979 · S/N 1157-79 N50568Curley Keith A · Alamosa, COBuilt 1979 · S/N 1191-80 N5056CBruton Derek · Bluff Dale, TXS/N 322-79 N5056GLambert Danny L · Plainview, TXS/N 590-80 N5056KWest Coast Aerosport Inc · Wilmington, DEBuilt 1980 · S/N 608-80 N5056NStraub Fronzie J · Circle City, AKBuilt 1979 · S/N 1155-79 N5056TGator Flight LLC · Saint Cloud, FLBuilt 1979 · S/N 1319-79 N5056VSpitfire Aviation Inc · Wilmington, DEBuilt 1979 · S/N 1156-79 N50571Cape Cod Aviators · E Falmouth, MABuilt 1979 · S/N 548-79 N50572Ready Aim Flyer LLC · New Castle, DEBuilt 1979 · S/N 549-79 N5057CG & M Aviation LLC · Kokomo, INNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 544-79 N5057HAjf Enterprises LLC · Des Moines, IABuilt 1975 · S/N 17265322 N5057KCanyon West LLC · Amarillo, TXBuilt 1980 · S/N 343-80 N5057LBillmeyer Jim · White Salmon, WAS/N 547-79 N5057PGolden John Daniel · Jay, FLBuilt 1979 · S/N 385-79 N5057RHeise Roger H · Clayton, NYBuilt 1974 · S/N 17263296 N5058BHintzman Steven J · New York Mills, MNS/N 1158-79 N5058CPierce Richard C · Kernersville, NCBuilt 1979 · S/N 1159-79 N5058KWinemiller Stevie D · Swifton, ARBuilt 1979 · S/N 1320-79 N5058LN69px LLC · Delaware, OHBuilt 1979 · S/N 558-79 N5058NCarbone Cabana Boys LLC · Mercer Island, WABuilt 1979 · S/N 1321-79 N50590Usaeroflight LLC · Greenville, SCBuilt 1974 · S/N 17264212 N50594Gott Michael C · Fairbanks, AKBuilt 1979 · S/N 328-79 N50598Fig Aviation LLC · Boulder, COBuilt 1979 · S/N 1164-79 N5059GLumland Properties LLC · Winchester, VABuilt 1980 · S/N 1343-80 N5059KLucia Keith G · Pleasant Hill, CABuilt 1979 · S/N 387-79 N5059NSchultze Joseph Dale · Mound, MNBuilt 1979 · S/N 1322-79 N5059PVertical Edge Enterprises LLC · Chandler, AZBuilt 1979 · S/N 554-79 N505CEMoore Travis S · Montrose, COBuilt 1968 · S/N 680092 N505LShores Robert C · Rocklin, CABuilt 1965 · S/N 3171 N505SHHitchens Steven L · Newark, OHBuilt 1972 · S/N 882-72 N505ZRoddy Bonnie J · Holly Lake Ranch, TXBuilt 1965 · S/N 799 N5060GSpragues Aerial Spraying Inc · Courtenay, NDS/N 1173-79 N5060JEeds Lucky L · Claude, TXBuilt 1979 · S/N 556-79

Back to AD 80-25-07 R1