AD 94-05-05 R1

Registered aircraft · 26,230

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.

N90043Peters Nicholas J · Eagle River, AKBuilt 1946 · S/N 9101N90044Crosby Kenneth R · Trapper Creek, AKBuilt 1956 · S/N 9102N9004AStuckert Robert D · Scottdale, PABuilt 1949 · S/N 18759N90051Eiland Justin C · Stephenville, TXS/N 9109N90053Frost Chelsea L · Anacortes, WABuilt 1946 · S/N 9111N90054Two Ten Aero LLC · Safford, AZBuilt 1946 · S/N 9112N90055Hance Everett P · Hubbardsville, NYBuilt 1946 · S/N 9113N90056Mcginn Robert W · Marion, NCBuilt 1946 · S/N 9114N9005AFerraro Donald M · Bangor, PABuilt 1949 · S/N 18894N9005BSchorsch Cary J · Franksville, WIBuilt 1957 · S/N 7EC-630N9005UPea Patch Flying Club Inc · Girard, OHBuilt 1976 · S/N 15078051N90060Schweiser John T · Sterling, KSBuilt 1946 · S/N 9121N90061Theobald Daryl Lee · Aberdeen, SDBuilt 1946 · S/N 9122N90066Beech O Sphere LLC · Casper, WYS/N 9127N90067Right Rudder Flight Training LLC · La Verne, CABuilt 1946 · S/N 9128N90068Clifton George F · Seattle, WABuilt 1946 · S/N 9129N90072Epple Jason E · Canby, MNS/N 9133N90075Whitney Kenton C Trustee · Tempe, AZBuilt 1946 · S/N 9136N90076Tilts Brandon J · Flagstaff, AZBuilt 1972 · S/N 414-72N9007AWeiszmann Erik · Bedford, NHBuilt 1949 · S/N 18762N90083Wittnebel Karl D · Los Angeles, CABuilt 1946 · S/N 9144N90085Registration Pending · Senoia, GARegistration pendingBuilt 1946 · S/N 9146N90089Pietila John R · Lakeville, MNBuilt 1946 · S/N 9150N90091Yates Thomas D · Greeley, COBuilt 2007 · S/N 6-6298N90092Durand Gregory M · Marquette, MIBuilt 1946 · S/N 9153N9009BSmith Jeffrey · Helena, ALBuilt 1957 · S/N 7FC-102N900CSSkains Dona D · Huntsville, TXBuilt 2010 · S/N 75-7809N900DPFlying Dudes LLC · Mount Pleasant, WIBuilt 2011 · S/N 16200044N900FGCordle Christopher T · Howard, OHBuilt 1946 · S/N 2459N900RYRitzman Todd F · Pewaukee, WIBuilt 1959 · S/N S-10N900SCCordle Christopher T · Howard, OHBuilt 1964 · S/N 17251349N90106Jj Aero LLC · Chuckey, TNS/N 9167N90110Joao James T · West Melbourne, FLBuilt 1946 · S/N 9171N90111Dill Tharold J Jr · Boron, CABuilt 1946 · S/N 9172N90112Pieszala John W · Larksville, PABuilt 1946 · S/N 9173N90113Seibert Caleb · Seguin, TXBuilt 1946 · S/N 9174N90116Gaylord Michael L · San Francisco, CABuilt 1946 · S/N 9177N90117Knighton William W · Wausau, WIBuilt 1946 · S/N 9178N9011AWilmsen Paul R · Millington, ILBuilt 1949 · S/N 18766N90120Lawson Kenneth H · Logandale, NVS/N 9181N90122White Darrell J · Radford, VABuilt 1946 · S/N 9183N90125Reeve Howard E · Minot, NDBuilt 1946 · S/N 9186N90127Spradling Robin P · Henderson, NVBuilt 1946 · S/N 9188N90130Duncan John H · Franklin, NCBuilt 1946 · S/N 9191N90133Lubben Justin Kane · Dayton, VAS/N 9194N90137Mills Jamie E · Brookshire, TXBuilt 1946 · S/N 9198N90138Baker Air Service · Baker, MTBuilt 1946 · S/N 9199N90139Groff Russell D · Winchester, TNBuilt 1946 · S/N 9200N90148Lsrw Aviation LLC · Zebulon, NCS/N 9209N90152Mcdonald Timothy · Daytona Beach, FLBuilt 1946 · S/N 9217
Back to AD 94-05-05 R1