OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123N3891MHall David B · Newburg, NDBuilt 1947 · S/N 12-2793N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991N3891TJones Rodney D · Corcoran, CABuilt 1967 · S/N 28R-30220N3891ZLaudon Sydney L · Anchorage, AKS/N 18-7707N3892August Aero LLC · Kalispell, MTBuilt 1978 · S/N 365N38922Iler Elden · Van Nuys, CABuilt 1941 · S/N A-845N3892KRowley Rodney N · Duchesne, UTS/N 28-23763N3892NNeed For Speed Inc · Dover, DEBuilt 1968 · S/N 680145N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992N3892ZWinston Christopher C · Vancouver, WABuilt 1961 · S/N 18-7708N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993N3894FNorth Shore Aero Club · Beverly, MABuilt 1976 · S/N 28-7690459N3894MMiller Mark R · Hagerman, IDBuilt 1947 · S/N 12-2794N3894TBsa Leasing LLC · Pocatello, IDBuilt 1967 · S/N 28R-30223N38952Ponto Phillip R · Vista, CABuilt 1977 · S/N 28-7716297N38954Faulkner Wade DBA · Sterrett, ALBuilt 1977 · S/N 28-7716299N38957Zeiner Ty R · Marion, KSBuilt 1941 · S/N 75-2528N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002N3895TPaetzold Carson · Jacksonville, FLBuilt 1967 · S/N 28R-30224N38968Vagabond Flying Association · Winfield, ILBuilt 1977 · S/N 28-7716300N38969Vandervelden Harmen J · Ware, MABuilt 1977 · S/N 28-7716301N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376N3896MBehm Jerome William · Burlington, NDBuilt 1947 · S/N 12-2796N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996N3896ZDriggs Daniel H · Anchorage, AKBuilt 1961 · S/N 18-7674N38970Triple R Aviation LLC · Cleburne, TXBuilt 1977 · S/N 28-7716302N38971Rothrock Cara J · Streator, ILS/N 75-4343N38972August Aero LLC · Kalispell, MTS/N 28-7716304N38974International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7716305N38979Reese William A Jr · Waynesboro, TNBuilt 1943 · S/N 75-4339N3897XRegistration Pending · Greenwood, INRegistration pendingBuilt 1967 · S/N 134N3897ZWard Joseph Delon · Wasilla, AKS/N 18-7788N38986Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716306N38987Ocean City Flying Club LLC · Middletown, RIBuilt 1977 · S/N 28-7716308N38988Bms Aircraft LLC · Tinley Park, ILBuilt 1977 · S/N 28-7716309N38989M5 LLC · Kit Carson, COBuilt 1977 · S/N 28-7716310N3898MCosta Air Service LLC · Painted Post, NYS/N 12-2798N3898QJaynes Grayson V Sr · Burnet, TXBuilt 1971 · S/N 17259998N3898XWood Noah S · New Manchester, WVBuilt 1967 · S/N 138N3898ZTtyf LLC · Hood River, ORBuilt 1960 · S/N 18-7343N38990Augusta Aviation Inc · Hilton Head Island, SCBuilt 1977 · S/N 28-7890002N3899JEz Bird LLC · Danbury, CTBuilt 1975 · S/N AA5B-0124N3899PJaffa Bruce E · Moose Pass, AKBuilt 1956 · S/N 18-4732N3899QFlight Inc · Gastonia, NCBuilt 1971 · S/N 17259999N3899TKaragiannis Nikitas · Fort Worth, TXBuilt 1967 · S/N 28R-30230N389CCAerial Timber Applicators Inc · Cooperstown, NDBuilt 2002 · S/N 9943CCN389CLCanaan Land Church Inc · Autaugaville, ALBuilt 1972 · S/N 17260700N389DCJehn Frank · Jackson, NJS/N 24-0639N389GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881174
Back to AD 90-04-06 R1