OpenAirDocs.org
AD 80-25-07 R1

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
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.

N35284Flying Redbirds LLC · Wentzville, MOBuilt 1975 · S/N 17702307N35287White James E · Eminence, KYBuilt 1975 · S/N 17702308N3528HBlack Kevin John · Edgewater, FLBuilt 1976 · S/N 20-1223N352964 Point Transportation LLC · Excelsior Springs, MOS/N 17702312N3529XPurpose Flight Inc · Wilmington, DES/N 670066N352GBDavis David N · Broken Arrow, OKBuilt 1976 · S/N 177RG1075N352WAC & M Aviation LLC · Lawrence, KSS/N 15282909N35302William Benjamin LLC · Orono, MNS/N 17256701N35308Kress Gregory A · Sharpsburg, GABuilt 1968 · S/N 17256704N3530XLorenz George W · Downers Grove, ILBuilt 1966 · S/N 670067N35313Lyon W Bruce · Carterville, ILBuilt 1968 · S/N 17256706N35315Hubert Thomas D · Greenville, TXBuilt 1968 · S/N 17256708N35318Wings LLC · Scottsdale, AZBuilt 1968 · S/N 17256709N35322Vincent Zachary T · Saint George, UTBuilt 1968 · S/N 17256710N35323Bourdon Greg · Henniker, NHBuilt 1968 · S/N 17256711N35324Schuster Darin D · New Castle, DEBuilt 1968 · S/N 17256712N35326Harrison Keith D · La Grange, NCBuilt 1968 · S/N 17256714N3532EDubois William C · El Centro, CABuilt 1978 · S/N 17271576N3532NMoorefield Charles N · Houston, TXBuilt 1968 · S/N 680063N3532XShipley James P · Los Alamos, NMBuilt 1966 · S/N 670069N35330Wilkerson Jeffrey D · Morning Sun, IABuilt 1968 · S/N 17256715N35332Katchmar Michael L · Canon City, COBuilt 1968 · S/N 17256717N35337Myer Martin John Trustee · Juneau, AKBuilt 1968 · S/N 17256718N35340Jones Donald E · Hollandale, MNBuilt 1968 · S/N 17256720N35344Sawyer James E · Urbana, OHBuilt 1968 · S/N 17256721N35345Flight One Holdings LLC · Devils Lake, NDBuilt 1968 · S/N 17256722N35348Jet & Rotor Aviation LLC · Sacramento, CABuilt 1968 · S/N 17256724N35349Stammich Thomas R · South Bend, INBuilt 1968 · S/N 17256725N3534HBeatty Don K · Mount Ulla, NCBuilt 1977 · S/N 22-1437N3534NCoffey Joseph · Camarillo, CABuilt 1967 · S/N 680087N35358N44344 LLC · Wasilla, AKBuilt 1968 · S/N 17256732N3535QBoulton Stephen A · Eugene, ORBuilt 1973 · S/N 17261666N3535XZulu Aviation Corp · Fort Worth, TXBuilt 1966 · S/N 670072N35362Hicks James P · Franklin, OHBuilt 1968 · S/N 17256734N3536NWestern Fires Inc · Yoncalla, ORBuilt 1967 · S/N 680088N3536XGreen William Robert Jr · Waller, TXBuilt 1966 · S/N 670073N35371Honrud Joseph C · Cal Nev Ari, NVS/N 17256738N35373Registered aircraftBuilt 1976 · S/N 177RG1049N35377Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17256740N3537NCreaney William Gerald · Franklin, TNS/N 680089N3537XMurphy James Stuart · Rock Hill, SCS/N 670074N35382Steele Aviation Inc · Walnut Cove, NCBuilt 1968 · S/N 17256742N35383Scott Mark · North Andover, MABuilt 1968 · S/N 17256743N35386Ehmann Stephen L · Holland, MIBuilt 1968 · S/N 17256745N3538NBillquist H Lee · Helena, MTBuilt 1967 · S/N 680090N3538XSkye Air LLC · Cypress, TXBuilt 1966 · S/N 670075N35392Meinema Mathew · Fort Wayne, INS/N 17256747N353BWHall Aviation LLC · Ithaca, NYBuilt 1994 · S/N 24-3354N353JLMartinez Jose L · Kansas City, MOBuilt 1968 · S/N 17256727N353SPBerger Amnon Asher · Westwood, MABuilt 1979 · S/N R18201288
Back to AD 80-25-07 R1