OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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.

N7807ERegistered aircraftAssigned, pending cancellationS/N 17607N7807FFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeBuilt 1966 · S/N 15063907N7807XFarwell Joseph W · Holmen, WIBuilt 1961 · S/N 17248307N7807ZSmokovitz Joseph M · Tecumseh, MIBuilt 1963 · S/N 15059907N78082Andersen Allen E · Sandy Valley, NVBuilt 1946 · S/N 2082N78088Neville Aviation Inc · Marianna, FLBuilt 1946 · S/N 2088N7808ESauls Billy J · Hollow Rock, TNBuilt 1959 · S/N 17608N7808TMckay H Samuel · Barnwell, SCBuilt 1960 · S/N 47408N78097Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1946 · S/N 2097N78099Daniel Gordon · Dillsburg, PABuilt 1946 · S/N 2099N7809EHavelka Justin R · Mcgregor, TXBuilt 1959 · S/N 17609N7809UHigh Planes Aviation LLC · Waseca, MNFirst renewal noticeBuilt 1964 · S/N 17251809N78103Johanson Karl S · San Diego, CABuilt 1946 · S/N 2103N78104Stanley George W · Richland, WABuilt 1946 · S/N 2104N7810URasch Hellmut G · Tomball, TXS/N 17251810N7810XCoats Benjamin F II · Ducktown, TNBuilt 1960 · S/N 17248310N78116Sweeney Sean M · Reunion, FLBuilt 1946 · S/N 2116N78118Cubswift LLC · San Antonio, TXS/N 2118N7811EWinkler William R III · Boone, NCBuilt 1959 · S/N 17611N7811THoke Cylus G · Culver, ORBuilt 1960 · S/N 47411N7811XMach 3 LLC · Enid, OKBuilt 1961 · S/N 17248311N7811ZTeske Robert E · Kalamazoo, MIBuilt 1963 · S/N 15059911N78120Stinson Jeremy L · Douglas, GABuilt 1946 · S/N 2120N78121Texas Airtime LLC · Fort Worth, TXBuilt 1946 · S/N 2121N78127Brown Asa V Jr · Royston, GABuilt 1946 · S/N 2127N7812PCowherd And Cowherd LLC · Union Point, GABuilt 2006 · S/N 601-027SN7812TCurzon John R · Brookings, ORS/N 47412N7812UPs Aviation Inc · Granada, MNS/N 17251812N7812ZAbbe Thomas E · Wasilla, AKBuilt 1963 · S/N 15059912N78134Vetter Virgil R · Plattsburg, MOBuilt 1946 · S/N 2134N78136Steinbock Richard J · Klamath Falls, ORBuilt 1946 · S/N 2136N78137Carpenter David M · Berea, KYBuilt 1946 · S/N 2137N7813FUp And Away Aviation LLC · Poughkeepsie, NYBuilt 1966 · S/N 15063913N7813ZMainus Virginia L · Westfield, PABuilt 1963 · S/N 15059913N78140Shields Edwin G · York, SCBuilt 1946 · S/N 2140N7814GClayton Steve · San Anotonio, TXBuilt 1973 · S/N 15074730N7814XOsterhouse Timothy D · Kalamazoo, MIBuilt 1961 · S/N 17248314N7814ZVaughn Rex · Spur, TXBuilt 1963 · S/N 15059914N78153Parnell-Davis Paula A · La Center, WAS/N 2153N7815XHearn Brian Franklin Trustee · Carrabelle, FLBuilt 1961 · S/N 17248315N78165Hostler James A · Eastsound, WABuilt 1946 · S/N 2165N78168Green Miles Wilder · Elm Grove, WIBuilt 1946 · S/N 2168N78170Schuster Doug B · Upland, CABuilt 1946 · S/N 2170N78171Losasso Adam · Scottsdale, AZBuilt 1946 · S/N 2171N78176Fawcett Walter L · Wolfeboro, NHBuilt 1946 · S/N 2176N78181Brookway Aviation LLC · Brookhaven, MSBuilt 1946 · S/N 2181N7818BRitenour John C · Knoxville, TNS/N 15617N7818EHurlin Nicholas E · Newburyport, MABuilt 1959 · S/N 17618N78191Hamilton Kirk G · Fargo, NDBuilt 1946 · S/N 2191N78194Kolstad Anna · Hartland, WIBuilt 1946 · S/N 2194
Back to AD 94-05-05 R1