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.

N200JKRuiz Victor · Roscommon, MIBuilt 1974 · S/N 28R-7435255N200KDQuantum Aero Services LLC · Wilmington, DEBuilt 1958 · S/N TD-176N200KMFabrega Teodoro A · Doral, FLBuilt 2003 · S/N 14109CN200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176N200KVPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1960 · S/N 2258N200LHuskys LLC · Chesterfield, MOBuilt 2012 · S/N 3154N200LTTraver Larry L · Sturgis, SDBuilt 2000 · S/N LT6012000N200MBPurple Plane LLC · Granbury, TXBuilt 1972 · S/N 405-72N200MDArvelu LLC · Utica, NYBuilt 1973 · S/N 28-7305431N200NTRichmond Jeremy · Eufaula, OKS/N 28R-35321N200PFPrimary Flight Control LLC · Fleming Island, FLBuilt 1984 · S/N 17276085N200PJClayton Allen Heidelberg · Great Bend, KSBuilt 1997 · S/N G2001002N200PMLansing Community College · Mason, MIBuilt 1983 · S/N 001N200PWGarris Steven L · Oceanside, CABuilt 1974 · S/N 28-7415182N200RFRushin William J · Greenwood, INBuilt 1973 · S/N M-1457N200RHHansen Roger A · Henderson, NVBuilt 1998 · S/N 21358N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210N200STk Aviation LLC · Willow Street, PAS/N 609N200SMMacinnis Stephen C · Richmond, TXBuilt 2001 · S/N 24557N200SVRxy LLC · Gilbert, AZBuilt 2009 · S/N 3079N200TBS&U Property Investments LLC · Wellington, FLBuilt 2023 · S/N 200TBN200TFDavis Timothy R · Nipomo, CAS/N 67N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363N200WCSigman Paul L · Incline Village, NVBuilt 1993 · S/N 792N200WSSierra Juliet Nm LLC · Santa Teresa, NMBuilt 1974 · S/N 34-7450117N200YRSloan Cooper · Seattle, WAS/N 28-7615279N200ZALawrence James D · Woodbridge, VABuilt 1995 · S/N 20-0003N200ZFPhillips Robert A · Saluda, NCS/N 24604N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014N2010AMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N M-2066N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177N2010LTec Consulting LLC · Farmingdale, MEBuilt 1978 · S/N M-2058N2010QShadow Blade Technologies LLC · Palm Bay, FLBuilt 1973 · S/N 177RG0410N2010TGustafson Keith W · Waleska, GABuilt 1970 · S/N 10N2010ZSanchez Michael G · Hesperia, CABuilt 1967 · S/N 28-22409N20111Westcott Emily E · Sequim, WABuilt 1972 · S/N 17261019N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630N2011CTuorila Leo Eric · Anderson, SCBuilt 1958 · S/N TD-178N2011QManzo Mario A · Sacramento, CAS/N 177RG0411N20120Bennett Robert J Jr · Minneapolis, MNBuilt 1978 · S/N M-2071N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631N20125New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N ME-94N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633N2012ATownsend Brooks P · Hattiesburg, MSBuilt 1978 · S/N MC-599N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117
Back to AD 90-04-06 R1