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.

N5128DKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272430 N5128RBend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17263345 N51295Right Brother Aviation LLC · Chaffee, NYBuilt 1980 · S/N 17274295 N51297Ingram Dale D · Klamath Falls, ORS/N 17264232 N5129QWaters John E · Renton, WABuilt 1973 · S/N 17261758 N5129XSmall Aviation No 2 LLC · Villa Rica, GABuilt 1969 · S/N 171 N512ACBuck James Kyle III · Oak Ridge, NCBuilt 1999 · S/N 1281-99 N512SBN512sb LLC · Austin, TXBuilt 1981 · S/N P21000762 N512TMSouthern Flight Aviation LLC · Bainbridge, GABuilt 1978 · S/N 17271721 N512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1978 · S/N 21063034 N51300Loftin Gabe · Weatherford, TXBuilt 1977 · S/N 177RG1137 N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280 N5130EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271725 N5130RShamp Jimmy L · Fresno, CABuilt 1974 · S/N 17263347 N5130TInfinity Aviation LLC · Piedmont, SDS/N 76 N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087 N5131EBrunken Barry D · Tower Hill, ILBuilt 1978 · S/N 17271726 N5131RMlt Operations LLC · Traverse City, MIBuilt 1974 · S/N 17263348 N5131T3b'S Land Development LLC · Seattle, WAS/N R18201821 N5131XWilson Brent S Trustee · Dyer, NVBuilt 1969 · S/N 184 N5132HMohnacs Joseph T · Mount Laurel, NJBuilt 1975 · S/N 17265347 N5132QHauptman Ben · Alexandria, VABuilt 1973 · S/N 17261760 N5132ULiberty Exploration Inc · Las Vegas, NVS/N 172RG0250 N5132XLinch Travis R · Belle Fourche, SDS/N 147 N51330Cortez Flying Service Inc · Cortez, COBuilt 1980 · S/N 17274298 N5133GPioneer Aviation LLC · Crossett, ARBuilt 1969 · S/N 17258447 N5133QReed Aero Group LLC · Hendersonville, TNBuilt 1973 · S/N 17261761 N5133TRanspot Richard P · Burlington, TXBuilt 1966 · S/N 76 N5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationBuilt 1969 · S/N 17258448 N5134KSunrise Aviation LLC · Gilbert, AZBuilt 1980 · S/N 17273979 N5134TLawrence David Denton · Roanoke, VABuilt 1966 · S/N 75 N5134WPlane Fun Inc Tr Trustee · Snellville, GAS/N P21000643 N5135ECommercial Safe And Lock Inc · Imperial, MOBuilt 1978 · S/N 17271728 N5135GChinrock Adam · Spanish Fort, ALBuilt 1969 · S/N 17258449 N5135TRayl Benjamin E · Mason City, IAS/N 562 N5136DZieg James E · Goldsboro, NCBuilt 1979 · S/N 17272432 N5136EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271729 N5136GYork Aviators LLC · York, PAS/N 17258450 N5136UNg Raymond Fong · New York, NYBuilt 1980 · S/N 172RG0252 N51379N51379 LLC · Galena, OHBuilt 1974 · S/N 17264235 N5137RSchmeelk Darrin D · Thompson, CTBuilt 1974 · S/N 17263354 N51380Aircraft Leasing Inc · Everett, WABuilt 1980 · S/N 17274305 N51386Russell Joseph M J · Douglas, WYBuilt 1977 · S/N 177RG1138 N5138ESanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17271731 N5138RBell Ornithopters Flying Club Inc · Eastlake, COBuilt 1974 · S/N 17263355 N5138XKoprek Kevin A · Montrose, COBuilt 1969 · S/N 159 N51395Rush David A · El Dorado, KSBuilt 1974 · S/N 17264237 N5139EAero Techniques LLC · Binghamton, NYBuilt 1978 · S/N 17271732 N5139TRatliff John B · Oroville, CABuilt 1966 · S/N 437 N5139XGlatthaar Richard J · Burbank, WABuilt 1969 · S/N 183

Back to AD 80-25-07 R1