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.

N5344STop Flight Aviation Snh LLC · Savannah, TNBuilt 1970 · S/N 28-26812N53456Amelia Reid Aviation LLC · San Jose, CABuilt 1981 · S/N 17274754N5345FArcher Air LLC · Traverse City, MIBuilt 1976 · S/N 28-7790093N5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LABuilt 1980 · S/N 15284549N5345WShisler Bill · Missoula, MTBuilt 1962 · S/N 28-404N53463Fara Nick · San Anselmo, CABuilt 1981 · S/N 17274758N53466Paulson Chris M · Eatonville, WABuilt 1943 · S/N 75-2175N5346DBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17272534N5346EOsprey Holding Company LLC · Foley, ALBuilt 1977 · S/N 17269573N5346FSo Send I You LLC · Cheyenne, WYS/N 28-7790094N5346KUsaeroflight LLC · Greenville, SCS/N 17274075N5346UAverett University · Danville, VABuilt 2003 · S/N 2843542N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510N5347FDeland Aviation LLC · Deland, FLBuilt 1976 · S/N 28R-7635453N5347HMonterey Bay Aviation Inc · Watsonville, CABuilt 1975 · S/N 17265410N5347LKing Michael · Durango, COBuilt 1968 · S/N 28-4650N5348BBowers Curt E · Jennings, LABuilt 1979 · S/N 15283844N5348DSwaz Aviation LLC · Mesa, AZBuilt 1979 · S/N 17272536N5348LPn4 Aviation Holdings LLC · Bishop, CAS/N 28-4651N5348TDavis Samuel T · Malad City, IDS/N 18-8009009N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511N5348ZDavis Robert D · Shongaloo, LABuilt 1961 · S/N 22-9068N53491Crossbrook LLC · Willoughby, OHBuilt 1981 · S/N 17274764N53494Gandarillas Andrew J · Toledo, WABuilt 1981 · S/N 17274765N5349DFisher Randall A · Salem, OHBuilt 1979 · S/N 17272537N5349LHart Brad S · Elephant Butte, NMS/N 28-4652N534APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843754N534CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881278N534DWValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 177RG1004N534EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13165N534FLGray Gary G · Kansas City, MOBuilt 1971 · S/N 28-7125364N534LU.S. Department Of The Interior · Boise, IDBuilt 2015 · S/N CC18-0075N534MPJones David C · Williston, VTBuilt 1991 · S/N 10066N534WCPrenter Christian E · Hermosa Beach, CABuilt 2002 · S/N 60473N53507Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274769N5350KCenterline Aviation LLC · Oklahoma City, OKBuilt 1980 · S/N 17274076N5350LN5350l LLC · Statesville, NCFirst renewal noticeBuilt 1968 · S/N 28-4653N5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1980 · S/N 15284553N5350PChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15284924N5350ZAgalotis Paul E · San Martin, CABuilt 1961 · S/N 22-9071N5351Robinson Herb · Snowflake, AZBuilt 1997 · S/N 073N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411N5351LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284298N5351PPointair Aviation Inc · Port Jeff Sta, NYS/N 15284925N5351QBarrett Dannie P · Halfway, ORS/N 17261778N5351ZGostola Thomas · Fairmount, INBuilt 1961 · S/N 22-9072N5352DN5352d LLC · Costa Mesa, CABuilt 2002 · S/N 2844079N5352KPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 17274077N5352LStinson Jonathan L · Douglas, GABuilt 1968 · S/N 28-4655N5352WRegistration Pending · Newton, ALRegistration pending, pending cancellationBuilt 1962 · S/N 28-413
Back to AD 90-04-06 R1