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.

N80HLGraff Justin C · Belden, MSBuilt 1961 · S/N D-6625N8105RBuckley Timothy L · Zionsville, INBuilt 1969 · S/N D-9089N8109BBrent Alan Reiner · Dillon, MTBuilt 1966 · S/N D-8224N810RLaurin David A · Prior Lake, MNBuilt 1959 · S/N D-5924N8115RRegistered aircraftBuilt 1969 · S/N D-9003N8119RCarona Robert A Jr Trustee · Oceanside, CABuilt 1974 · S/N D-9655N811AWebb Matthew K · Denton, TXBuilt 1960 · S/N D-6447N812RHeinen Michael J · Mooresville, NCBuilt 1959 · S/N D-5945N8135RKeyt Richard C · Granbury, TXBuilt 1974 · S/N D-9696N8137RWestdale Aviation LLC · Shreveport, LABuilt 1974 · S/N D-9660N813CHBlech Andreas J · Grants Pass, ORBuilt 1973 · S/N D-9536N8158RFullerton Vtail Partners LLC · Mission Viejo, CABuilt 1974 · S/N D-9665N815QSumo Tails Ltd · Wilmington, DEBuilt 1966 · S/N D-8286N815RLCraig Travis J · Lawton, OKS/N D-5958N8166RJmac Aviation Services LLC · Andalusia, ALBuilt 1974 · S/N D-9666N8169RPreister Properties LLC · Norfolk, NEBuilt 1974 · S/N D-9668N816NMidwest Aircraft Inc · Wilmington, DES/N D-8963N816UMcmullen Gerald W Trustee · Spokane, WABuilt 1970 · S/N D-9161N816VBrawler Aviation LLC · Edmond, OKBuilt 1971 · S/N D-9266N8171RYankee Air Pirate LLC · Memphis, TNBuilt 1974 · S/N D-9669N817MWWright Mark A · Willingboro, NJBuilt 1964 · S/N D-7381N8183RFerriolo Donald J · Greer, SCBuilt 1974 · S/N D-9671N8187RFleck Richard N Trustee · Camarillo, CABuilt 1974 · S/N D-9673N818SDGerges Ebraim · Riverside, CAS/N D-7480N8191RM B Duncan Inc · Bakersfield, CABuilt 1974 · S/N D-9675N819BRooney William T · Lakin, KSBuilt 1978 · S/N D-10186N819T3rd Gen Aviation LLC · Lisbon, NDBuilt 1973 · S/N D-9507N81JBWeinstein Berthold W · Livermore, CABuilt 1968 · S/N D-8748N81KTTalhelm Kenneth K · Muncie, INBuilt 1956 · S/N D-4652N81VBNeal Foster Trucking Inc · Merrill, ORBuilt 1980 · S/N D-10315N81VTDouble D Aircraft LLC · Sergeant Bluff, IABuilt 1974 · S/N D-9640N8200DAyers Aviation LLC · Archer City, TXBuilt 1957 · S/N D-5293N8201DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1957 · S/N D-5288N8202DHot Start Aviation LLC · Chapin, SCBuilt 1957 · S/N D-5325N8204DMunck Ernest C · Prosser, WABuilt 1957 · S/N D-5296N8206DParagon Grain Inc · Chester, MTBuilt 1957 · S/N D-5306N8209DZukowski Hawkin · Madison, WIBuilt 1957 · S/N D-5298N820RRettig & Associates LLC · Bessemer, ALBuilt 1959 · S/N D-6046N8211DNortheast Aeronautics LLC · Sussex, NJBuilt 1957 · S/N D-5301N8213DC A P Air Rescue Flyers Inc · Salinas, CABuilt 1957 · S/N D-5303N8214DStaudacher Mark W · Bay City, MIBuilt 1957 · S/N D-5308N8215DCronk Jerry L · Ontario, CABuilt 1957 · S/N D-5302N821RNew Dakota Holdings LLC · Hillsboro, NDS/N D-6058N8220DRice Kenneth A · San Francisco, CAS/N D-5310N8221DDavison Ralph R II · Ava, MOS/N D-5323N8223DN8223d Corp · Lemont, ILS/N D-5309N8224DShoemaker Floyd H III · Oneida, TNBuilt 1957 · S/N D-5316N8229DKnight Ronald L Trustee · Etna, CABuilt 1957 · S/N D-5327N822SRegistered aircraftBuilt 1964 · S/N D-7552N822TMarburger James H · Phoenix, AZBuilt 1973 · S/N D-9513
Back to AD 94-20-04 R2