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.

N5839LHoyer Chase R · Jarrell, TXBuilt 1972 · S/N AA5-0039N5839PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-920N5839QSnodgrass Michelle B · Sierra Vista, AZBuilt 1965 · S/N 785N5839RGiraud Stephen · Box Elder, SDBuilt 1995 · S/N 20042CN5839ZPhillips Michael K · Issaquah, WABuilt 1963 · S/N 22-9692N583CHuber James M · Melba, IDBuilt 1983 · S/N 583N583CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881132N583FLSotomayor Edwin · Lacey, WABuilt 1971 · S/N 28-7125438N583MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.399N583NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496253N584Wyatt James · Conyers, GABuilt 1977 · S/N 0021N5840HFarrell Tammy · Sterling, AKBuilt 1949 · S/N 16-458N5840UTall Timber Flying Service LLC · Kalispell, MTBuilt 1970 · S/N 28-26671N5841DLeopold Gary L · Winterset, IABuilt 1956 · S/N 22-4520N5841QGuziec Philip R · Riverwoods, ILS/N 786N5841WDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2216N5842HUnivair Aircraft Corp · Aurora, COBuilt 1949 · S/N 16-460N5842LBerner Walter T III · Stamford, CTBuilt 1972 · S/N AA5-0042N5842QBradford Michael · San Jose, CABuilt 1965 · S/N 3130N5842WFrakes Enterprises · Happy, TXBuilt 1965 · S/N 28-2221N5843HPerkins Jeffrey · Georgetown, TXBuilt 1949 · S/N 16-461N5843LMaschek Scott · Harker Heights, TXBuilt 1972 · S/N AA5-0043N5843QKeane Christopher · Salem, NHBuilt 1965 · S/N 787N5843UOnyx Aviation LLC · North Fort Myers, FLS/N 28-26674N5843WSkyunityventures LLC · Richmond Hill, NYBuilt 1965 · S/N 28-2247N5843ZIkenberg H L · Butler, PABuilt 1963 · S/N 22-9697N5844HMccoy David L · Bear Creek, WIS/N 16-463N5844LHennell Elizabeth · Orrville, OHBuilt 1972 · S/N AA5-0044N5844WSmith William H · Weimar, TXBuilt 1965 · S/N 28-2237N5844ZJohnk Willi C II · Donalds, SCBuilt 1963 · S/N 22-9698N5845LKunkel Dennis J Co Trustee · Clearwater, MNBuilt 1972 · S/N AA5-0045N5845ZGeldermann Bert E · Friday Harbor, WABuilt 1996 · S/N 230RN5846FDunning Steve L · Hopkinsville, KYBuilt 1976 · S/N 28-7790138N5846HTop Flight Detail LLC · Middlebury, INS/N 16-465N5846QGardner Perry F · East Canaan, CTBuilt 1965 · S/N 3132N5847PMyers Michael A · Indianapolis, INBuilt 1959 · S/N 24-928N5847UFly Vermont LLC · Swanton, VTBuilt 1969 · S/N 28-26678N5847WReed Charles W · Elizabeth City, NCBuilt 1965 · S/N 28-2286N5847XFowler Leo W · Port Alsworth, AKBuilt 1941 · S/N 7896N5848AKnight Farms Inc · Pasco, WAS/N 001JRAN5848HWhite Terry W · Saint Joseph, MIBuilt 1949 · S/N 16-467N5848LN5848l LLC · San Francisco, CABuilt 1972 · S/N AA5-0248N5848QValenti Edgar M · Gig Harbor, WABuilt 1965 · S/N 3133N5848WLedbetter Mark W · Garfield, ARBuilt 1965 · S/N 28-2292N58490Kushner Herbert A · Bridgewater, NJBuilt 1997 · S/N 1094N5849FGng LLC · Arlington, INBuilt 1976 · S/N 28-7790139N5849WHomic Michael J · Edmond, OKBuilt 1965 · S/N 28-2293N584BRRathburn Robert L · Edgewood, TXBuilt 2013 · S/N 82948N584CMBurns Timothy R · Eighty Four, PABuilt 1978 · S/N 24-0544N584FBenesch Benjamin · Sparks, NVBuilt 2000 · S/N 5084
Back to AD 90-04-06 R1