OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N2359QBean Glen A · Damascus, ORS/N M-428N2359TChopco Ltd · Columbus, OHS/N 2359N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159N235ACLetourneau University · Longview, TXBuilt 2005 · S/N 1394-2005N235AUNorcross Ashley S · Anchorage, AKS/N 22-9772N235AXBeebe Richard W · Cortland, NYBuilt 2011 · S/N CCK-001N235BDDondi Beda C · Fort Lauderdale, FLBuilt 2011 · S/N 1686NN235CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881504N235CLAtomic 235 LLC · Irvine, CABuilt 1991 · S/N 70N235ECMoore Dylan D · Lakeville, MABuilt 2011 · S/N 1001N235FBFlorida Power And Light · West Palm Beach, FLBuilt 2021 · S/N TRC0001N235FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2841285N235GHHunter Gary A · Lake Jackson, TXBuilt 1984 · S/N 1855N235JWMax Power Aircraft LLC · Kenosha, WIBuilt 2008 · S/N 059N235KMckinney Steve R · Hamersville, OHBuilt 2005 · S/N 2N235LHMaupin Dean C · Davenport, IABuilt 2001 · S/N 80844N235LKCluff Dustin · Saint Helens, ORS/N 128N235MKWright Curtis B · Roy, UTBuilt 2003 · S/N 9904-0183N235NSirius Insurance Services LLC · Stuart, FLBuilt 2012 · S/N 071N235NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274911N235PAGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 28-7816678N235RCNewberry Guy · Port Byron, ILBuilt 1990 · S/N LA 215N235RHWillliams John C · Coldspring, TXBuilt 1995 · S/N 001N235RMScroggs Ross A · Locust Grove, GABuilt 2023 · S/N 3911N235RVFatenko Alex Charles · Sea Girt, NJBuilt 1998 · S/N 10333N235SAJkt LLC · Douglas, WYBuilt 2008 · S/N 1445-2008N235SRDraco Flight School DBA · Chino, CABuilt 2003 · S/N 2842182N235TBossert Brett · Tucson, AZBuilt 1953 · S/N 18-2349N235TJDickerson Timothy J · Woodlake, CABuilt 2013 · S/N S95010090N235TPSvl Aviation LLC · Delray Beach, FLBuilt 1985 · S/N 28-8516036N235ZKing Diane M · Grove City, OHBuilt 2000 · S/N 002N23601Whitaker Cecil D · Pryor, OKBuilt 1939 · S/N 1325N23602Gerber D M Jr · Collinsville, OKBuilt 1939 · S/N 1326N23603Dudley David A · Tavares, FLBuilt 1939 · S/N 1327N23604Schmidt Wade H · Moses Lake, WABuilt 1939 · S/N 1328N2360RLamarra Anthony A · Clarkston, MIBuilt 1969 · S/N 28-5496N23619Miller Darrell Y · Madras, ORS/N 1344N2361AGeorge Raymond C · Wasilla, AKS/N 18-1906N2361BCaudell Michael A · Cleveland, GABuilt 1948 · S/N 3661N2361LUnderwood Richard R · Armuchee, GABuilt 1963 · S/N M-190N2361MSutter Tim C · Glennallen, AKBuilt 1946 · S/N 12-1615N2361NBrewer Philip T · Bartlett, TNBuilt 1979 · S/N 38-79A0807N2361QLong Lawrence R · South Whitley, INS/N 28-7716100N2361RVenture West LLC · Mesa, AZBuilt 1969 · S/N 28-5497N2361ZBoyles Michael K · Waynesboro, MSBuilt 1962 · S/N M-73N2362HCarpenter Forrest A · Longmont, COBuilt 1979 · S/N 18-7909177N2362LWatkins William V · Porter, OKBuilt 1963 · S/N M-176N2362MCanfield James R · South Gibson, PABuilt 1946 · S/N 12-1616N2362QStiers Randell E · Bunker Hill, INBuilt 1963 · S/N M-435N2362ZFlowers Jesse S · Moscow, IDBuilt 1962 · S/N M-76
Back to AD 90-04-06 R1