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.

N5908QT&T Aviation LLC · Clarksville, TNBuilt 1965 · S/N 819N5908UEcostudio Real Estate LLC · South Amboy, NJBuilt 1970 · S/N 28-26505N5908WPrindle Ry · Hillsboro, ORBuilt 1965 · S/N 28-2879N5909EOwens Flight Training LLC · Lafayette, LABuilt 1978 · S/N 17271958N5909HDelaney John D · Mineral Point, WIBuilt 1949 · S/N 16-533N5909WCornebise Ricky · Levelland, TXBuilt 1966 · S/N 28-3032N590DCDonald Pohland J · Anchorage, AKBuilt 1958 · S/N 18-6245N590FLDonnelly Matthew J · Romulus, NYS/N 28-7125452N590NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496269N590RUSA Jet And Helicopter Inc · Denver, NCBuilt 1965 · S/N 28-21327N590SProspect Ridge Aviaton Inc · Morganton, NCBuilt 1981 · S/N 172RG0818N590SCGarcia Daniel J · Chino Hills, CABuilt 2019 · S/N 70289N590SPTubreaux Aviation Services LLC · Shreveport, LABuilt 2000 · S/N 172S8520N5910DEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4572N5910HKlann Jason · Yorkville, ILS/N 16-534N5910WMetz Tyler B · Bridgeport, WVBuilt 1966 · S/N 28-3040N5910ZBishop David E · Butlerville, INBuilt 1963 · S/N 22-9777N5911LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496102N5911QFuller Christopher · Ottsville, PABuilt 1965 · S/N 3164N5911UMoore Air Inc · Honolulu, HIBuilt 1970 · S/N 28-26824N5911WBrimmer Harold C · Longview, TXBuilt 1966 · S/N 28-3042N5911ZDavis Jim F · Poteau, OKBuilt 1963 · S/N 22-9778N59121Hickey Aero Services LLC · White Hills, AZS/N 442N5912DRenner David L · Ferndale, CAFirst renewal noticeBuilt 1956 · S/N 22-4574N5912QWilson Paul M · Bonifay, FLS/N 821N5913Skyhaven Airport Inc · Tunkhannock, PAS/N C3-5911N5913DCaldwell Caleb Z · Anchorage, AKBuilt 1956 · S/N 22-4575N5913HMesserla David M · Manhattan, KSBuilt 1949 · S/N 16-527N5913SStoican Steve Gene · Ryegate, MTBuilt 2006 · S/N 21N5913XHay Johnny L · Bethel, OHS/N 49N5914HFambrough Todd W · Ocala, FLBuilt 1949 · S/N 16-538N5914UShawver Aviation LLC · Knoxville, IAS/N 28-26794N5914VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1977 · S/N 28-7716214N5914WSteadfast Avatiion LLC · Mesa, AZBuilt 1966 · S/N 28-3124N5914XTamvakis Dimitri · Orlando, FLS/N 50N5915DMason Jack A · Reidsville, NCBuilt 1956 · S/N 22-4577N5915QHaslem Patrick S · Dimondale, MIBuilt 1965 · S/N 3166N5915UOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1970 · S/N 28-26897N5915WTheobald Daryl · Aberdeen, SDBuilt 1966 · S/N 28-3139N5916HHainline James L · Klamath Falls, ORBuilt 1949 · S/N 16-537N5916JUnited States Air Force - Owner · Eglin Afb, FLBuilt 1980 · S/N 17273845N5916QSeidel Daniel F · Los Altos Hills, CABuilt 1965 · S/N 823N5916UForsman Airways LLC · Glenwood, MNBuilt 1970 · S/N 28-26780N5917LHill Jeffrey A · Boise, IDBuilt 1969 · S/N AA1-0217N5917VHeyano Norman J · Dillingham, AKBuilt 1977 · S/N 28-7790512N5917WHiggins James L · Harrisville, MIBuilt 1966 · S/N 28-3187N5917ZKoch Christopher P · Batavia, NYBuilt 1963 · S/N 22-9785N5918HHarvey Michael V · Port Leyden, NYBuilt 1949 · S/N 16-541N5918JStansfield Carl B · Springdale, UTS/N A1500218N5918LRobello Mel K · San Jose, CAFirst renewal noticeBuilt 1969 · S/N AA1-0218
Back to AD 90-04-06 R1