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.

N59CWN59cw LLC · Sheridan, WYBuilt 1979 · S/N 44-7995317N59CZGlynn Jeffrey L · Pagosa Springs, COBuilt 1991 · S/N 246N59DGGregory Charles B · Valparaiso, INBuilt 1981 · S/N FD-2N59DLChannel Islands Aviation Inc · Camarillo, CABuilt 1979 · S/N ME-143N59DRRanzway Corp · Seattle, WABuilt 1994 · S/N 001N59DTN59dt Inc · Malabar, FLBuilt 1998 · S/N 5360N59EAHorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26173N59FBCox Steven D · Evergreen, COBuilt 2003 · S/N 81047N59FSRegistration Pending · Yazoo City, MSRegistration pendingBuilt 2005 · S/N 2109N59GTMarianas Mission Aviation Inc · Tamuning, GUBuilt 1975 · S/N AA5B-0028N59HAircraft Sales LLC · Caledonia, MIBuilt 1951 · S/N 325N59HYRitter Mark C · Austin, TXBuilt 2001 · S/N 2159N59JAHare Michael R · Nye, MTBuilt 2001 · S/N 80819N59JHFlying Circus Pictures · Los Angeles, CAS/N 70048N59KBBond Kent F · Woods Cross, UTBuilt 2019 · S/N BONDI-1N59KTLancaster Mark S · Ottumwa, IABuilt 2006 · S/N 29N59LAAlphin Lewis Jackson · Mount Olive, NCBuilt 1999 · S/N 430-99N59LGWillig Louis · Penn Valley, PABuilt 2011 · S/N 11406N59LHSpillman Robert L DBA · Port Orange, FLBuilt 2003 · S/N 81202N59LJL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281043N59LPHalkett Blair Ross · Knoxville, TNBuilt 1999 · S/N 001N59LTHall Morgan R · Los Osos, CABuilt 2008 · S/N 2044N59MSSojka Michael J · Bainbridge, INBuilt 1994 · S/N 735-94N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347N59PHSeider Jason · Dallas, TXBuilt 1968 · S/N 680116N59PPJohnson Monte W · La Porte, INBuilt 1960 · S/N 1646N59RBRegistered aircraftBuilt 1994 · S/N B-3N59RVNghiem Daniel · Westminster, CABuilt 1995 · S/N RV21635N59SMChandler Ronald J S · Tucson, AZBuilt 1997 · S/N 21734N59SRRaeder James · Caldwell, IDS/N 001N59TPeters Willie W · Brownfield, TXBuilt 1990 · S/N 20225N59TDDavison Terry W · Melba, IDBuilt 2010 · S/N 72688N59TPRegistered aircraftBuilt 2012 · S/N 82534N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905N59WBWhiskey Bravo LLC · Scottsdale, AZBuilt 1990 · S/N 1571N59WDHorner Michael W · Manakin Sabot, VABuilt 2007 · S/N 1423-2007N59WLHerrmann Mark D · Dillingham, AKS/N 269-70N59WMHudson River Wings LLC · Montclair, NJBuilt 1991 · S/N 10037N59WYHat Trick Aviation LLC · Coeur D Alene, IDBuilt 2020 · S/N 3354N59YLPanariello Gary F · Sausalito, CABuilt 2018 · S/N 82381N59YYBay Richard P · West Jordan, UTBuilt 1960 · S/N 56429N5AASimanski Charles J · Onley, VABuilt 1973 · S/N 28-7325670N5ADCraig Philip A Jr · West Richland, WABuilt 1992 · S/N 20954N5AKHackler Tara Cole · Bend, ORBuilt 1977 · S/N 17268768N5AUCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-7725239N5BHixon Carl J · Clayton, NCBuilt 2003 · S/N 5061N5BJLinrud Michael A · Velva, NDBuilt 1969 · S/N 187N5BMDja Enterprises LLC · Los Angeles, CABuilt 1979 · S/N 28-8090181N5BYWolff Emanuel C Md · Tucson, AZBuilt 1963 · S/N 30-105N5CMBramall Buster I · Waxahachie, TXBuilt 1973 · S/N 17262655
Back to AD 90-04-06 R1