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.

N1926CLoes Todd A · Waterloo, IABuilt 2017 · S/N WR294S118N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017N1926GJaju Aviation Inc · Abilene, TXBuilt 1974 · S/N 1026-74N1926PHoudek Dennis E · Roseburg, ORBuilt 1955 · S/N 22-2677N1926WSengstock Frank W · Traverse City, MIBuilt 1973 · S/N MB-587N1926YRoss Dustin · Georgetown, TXBuilt 1964 · S/N 221N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566N1927AHigh Wind Aviation Services LLC · Ludlow, VTBuilt 1952 · S/N 18-1762N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017N1927LCarrillo Isaias D · Wasilla, AKBuilt 1976 · S/N MB-796N1927WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1973 · S/N MB-609N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019N1928QWhite David D · Arcata, CABuilt 1973 · S/N 177RG0328N1928YMaddex William E · Battle Ground, WAS/N 235N1929HMott Robert H · Yaphank, NYBuilt 2004 · S/N 699N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416N192ACByrd Ronald D · Farwell, TXBuilt 1994 · S/N 1203-95N192AMN34cc LLC · Liberty, NCBuilt 2021 · S/N 2881507N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016N192BAHarkrader Aviation LLC · Louisa, VABuilt 1974 · S/N 459-74N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020N192FCFleming Michael D · Huntersville, NCBuilt 1968 · S/N 28-24374N192FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1985 · S/N 15285979N192JHHogue James B · Spencer, TNBuilt 1992 · S/N 669-92N192MEKindrick Jan W · Mt Vernon, TXBuilt 2000 · S/N 172S8454N192MHHolland James Michael · Fort Collins, COBuilt 2005 · S/N 90556N192RDisarro Wayne · Ketchikan, AKBuilt 2003 · S/N RK 100 1N192RKWeber Martin Trustee · Marthasville, MOBuilt 1992 · S/N 1854N192TTTerning Thomas N · Sedan, KSBuilt 1995 · S/N 1932PN192VDefenbaugh Matthew J · Biggsville, ILBuilt 1999 · S/N 22107N1930LMaclean Milton A III · Rossmoor, CAS/N M-1828N1930SDart Gregory G · Mayville, NYS/N NS001N1930TWing John · Fort Worth, TXS/N 28-7125442N1930UGazzano Leonard S Trustee · Yerington, NVBuilt 1999 · S/N 1930N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798N1931TFordham Scott · Sag Harbor, NYBuilt 1975 · S/N AA50744N1931VRegistered aircraftBuilt 1974 · S/N 17263799N1931WDelgado Alan J · Auburn, GABuilt 1973 · S/N MB-589N1932QHogan James C DBA · Cameron Park, CABuilt 1973 · S/N 177RG0332N1932VFarmland Aviation LLC · Glenwood, IABuilt 2005 · S/N 84232N1932YDriver L Spence · Bay City, WIBuilt 1964 · S/N 239N1932ZSpencer David E · Woodville, ALBuilt 2015 · S/N 001N1933Weston Jeff A · Port Saint Lucie, FLBuilt 1996 · S/N 367N19338Brewer Stephen F · Hamilton, OHS/N K-206N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023N1933HBlock Andrea · Chandler, AZS/N 28-7725170N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417N1933TLogan Flyers LLC · Logan, OHBuilt 1971 · S/N 28-7105151N1933WHanson Garrick D · Clayton, NCS/N MB-597
Back to AD 90-04-06 R1