OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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-20-04-R2')
    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-20-04-R2')
  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.

N222SMMacknight James G · Morgan Hill, CABuilt 1976 · S/N D-9958N222TTLaukkanen Eric M · Sisters, ORBuilt 1956 · S/N D-4446N222ZBonanza Parts Inc · Davis, CABuilt 1951 · S/N D-2732N223DWSeibel Keith L · Paris, TNBuilt 1963 · S/N D-7113N223MVallington Alexander M · Enterprise, ALBuilt 1960 · S/N D-6524N224HPNguyen Cody · Richmond, CABuilt 1965 · S/N D-7806N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152N2255NMalard Darren L · Bismarck, NDBuilt 1974 · S/N D-9580N225SPGross Flying Service Inc · Larned, KSBuilt 1964 · S/N D-7488N225XGomez Miguel W · Livermore, CABuilt 1957 · S/N D-5032N2265LNeilsen Lorenzo I · Wilmington, NCS/N D-9939N2267AWilson Ronald W · Bluffton, SCBuilt 1969 · S/N D-9027N2272LBaum Jeffrey · Sheridan, WYBuilt 1976 · S/N D-9944N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945N227BChase 13 LLC · Wilmington, DEBuilt 1956 · S/N D-4467N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682N227QHanke Peter W · Chimacum, WABuilt 1964 · S/N D-7523N2283LMoser Jerald L · Tucson, AZS/N D-9948N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949N228BClark David A · San Jacinto, CABuilt 1956 · S/N D-4588N228QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N D-8135N2292LGenzoli Steven · Hughson, CABuilt 1976 · S/N D-9947N2295ASemper Primus LLC · Las Vegas, NVBuilt 1969 · S/N D-9039N2296DBonanza Flyers L3c · Murray, UTBuilt 1977 · S/N D-9997N229QMike Lima Partners LLC · Wilmington, DEBuilt 1966 · S/N D-8169N22AGMavridoglou Theo A · Brandon, MSBuilt 1973 · S/N D-9499N22BYDelton LLC · Pembroke Pines, FLBuilt 1964 · S/N D-7609N22EDGrant Douglas R · Foster City, CABuilt 1954 · S/N D-3820N22HRSpletzer Carl W · Selma, ORBuilt 1954 · S/N D-3746N22NPPayne David · Maryville, TNS/N D-7354N22PKRegistered aircraftS/N D-8647N22QWCaiati Ulysses H · Fresno, CABuilt 1964 · S/N D-7487N22RRHolmes Amy N · Madison Heights, VABuilt 1958 · S/N D-5445N22THYoung Howard L · La Jolla, CABuilt 1961 · S/N D-6784N22TNNewman William L · Breckenridge, TXBuilt 1965 · S/N D-8032N22VHSchiltz David A · Ankeny, IABuilt 1973 · S/N D-9458N22XFishburn James R III · Wooster, OHBuilt 1966 · S/N D-8064N22XGPixton Thomas J · Incline Village, NVBuilt 1966 · S/N D-8369N231BBlue River Holdings LLC · Hugo, OKBuilt 1956 · S/N D-4651N231SVinegaroon Aviation LLC · Franklin, TNBuilt 1966 · S/N D-8058N2323AOutdoorsmans Dream LLC · Kalispell, MTBuilt 1969 · S/N D-9032N233DKitley David Matthew · Dolores, COBuilt 1961 · S/N D-6753N233GKGoodwin Joseph N · Grass Valley, CABuilt 1968 · S/N D-8777N233RPlane Jane Aviation LLC · Sylvania, GABuilt 1975 · S/N D9811N233SCMattoso Ricardo Q · Spicewood, TXBuilt 1974 · S/N D-9599N2340BHenefeld Mark J · Milton, GABuilt 1964 · S/N D-7451N234ALDale James H · La Vernia, TXS/N D-4457N234DHCarrell Evan Paul · Queen City, TXBuilt 1969 · S/N D-8966N234EBArbuckle James H · Bellevue, NEBuilt 1966 · S/N D-8157N234USLong Camille D · Atlanta, GABuilt 1953 · S/N D-3678
Back to AD 94-20-04 R2