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.

N2ZWThordarson Gudsteinn Thor · La Porte, INBuilt 1956 · S/N D-4564N3001CHoyt Robert H · Canby, ORBuilt 1958 · S/N D-5664N3002CAviation By Gosh LLC · Burlington, TXBuilt 1958 · S/N D-5665N3005CFodor Vincent A · Doylestown, OHBuilt 1958 · S/N D-5668N3008CTech Aero Avionics LLC · Denton, TXBuilt 1958 · S/N D-5671N300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1966 · S/N D-8056N300CLHustak Michael G · Granbury, TXBuilt 1969 · S/N D-8913N3012CHealy David Paul · Arlington, TXS/N D-5677N3015CSorna Douglas J · Flower Mound, TXBuilt 1958 · S/N D-5680N3016CMoore Todd M · Peoria, ILBuilt 1958 · S/N D-5681N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520N3020CBrosnan Daniel · Mary Esther, FLBuilt 1958 · S/N D-5685N3023WBoughen James R · Camas, WABuilt 1973 · S/N D-9517N3027CPelayo Fernando · La Puente, CABuilt 1958 · S/N D-5692N3029CHeyneman John M · Sheridan, WYS/N D-5694N3032CPrice Michael J · Pulaski, NYS/N D-5687N3032WDebrouwer Isabelle Mc · Alpine, TXBuilt 1973 · S/N D-9525N3033CMetzger James R · Payette, IDBuilt 1958 · S/N D-5688N3036CSimpkins Larry D · Williamson, WVBuilt 1958 · S/N D-5691N3039CDammel Stanley J · Odessa, WABuilt 1958 · S/N D-5698N303BMantei Mark R · Boulder, COBuilt 1956 · S/N D-4707N303LWHoward Dan E · Hurricane, UTBuilt 1966 · S/N D-8336N3041CVangundy Timothy S · Camby, INBuilt 1976 · S/N D9946N3041WEstes Aviation LLC · Rapid City, SDBuilt 1968 · S/N D-8824N3043CSelby Air LLC · Lorida, FLBuilt 1958 · S/N D-5704N3046CStehlik Dennis J · Wheaton, ILBuilt 1958 · S/N D-5610N3047CEver Fast LLC · Kalispell, MTS/N D-5771N3048CThompson Sean R · Trabuco Canyon, CABuilt 1958 · S/N D-5710N304BSmith Dennis L · Thomson, GABuilt 1956 · S/N D-4647N3051AHigby James E Jr · Frederick, COBuilt 1969 · S/N D-9058N3051CMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N D-5707N3056CStorholt Wayne R Jr · Plano, TXBuilt 1958 · S/N D-5721N3057CClb LLC · Lewes, DEFirst renewal noticeS/N D-5713N3057WBaskins Robert H · Huntington Beach, CABuilt 1973 · S/N D-9557N3059CFellows David O · Mc Alpin, FLBuilt 1958 · S/N D-5715N305BWofford Ross · Allen, OKBuilt 1956 · S/N D-4642N3061CTharp Aerospace LLC · Charleston, SCBuilt 1958 · S/N D-5757N3064WDavid And Shirley Houchin LLC · Crescent City, FLBuilt 1973 · S/N D-9553N3066CBarham Micheal · Bluffton, OHBuilt 1958 · S/N D-5719N3067CGoncharov Serge S · Monroe, NCBuilt 1958 · S/N D-5731N306BWoodward Michael W · Mount Erie, ILBuilt 1956 · S/N D-4675N3071CSimpkins Randolph J · Eagan, MNBuilt 1958 · S/N D-5727N3079CTre Aviation Corp · Wilmington, DEBuilt 1958 · S/N D-5759N307ZEsterak David R · Boyce, LABuilt 1960 · S/N D-6458N3083CBear Boss LLC · Missoula, MTBuilt 1958 · S/N D-5754N3084CHeft Joel R · Mcgregor, TXBuilt 1958 · S/N D-5755N3085CRoberts Marc A · Thomasville, PABuilt 1958 · S/N D-5761N3088CMeester Daniel J · Longmont, COBuilt 1958 · S/N D-5773N3089CWeatherly Richard A · Newport, WABuilt 1958 · S/N D-5772N308EShannon Jesse L · Boise City, OKS/N D-5763
Back to AD 94-20-04 R2