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.

N40CRMoyer Gregg A · Haymarket, VABuilt 2015 · S/N 1003N40CSSoloy L Chris · Wasilla, AKBuilt 1993 · S/N 1N40CZBeast Aero Consulting And Training LLC · Rosamond, CAS/N 0763N40DACirrus Design Corp · Duluth, MNBuilt 1965 · S/N 30-904N40DCWright Innovators LLC · Sebastian, FLBuilt 1988 · S/N 561N40DLStyer David B · Pendleton, ORBuilt 1971 · S/N 071N40DMChapman Randy J · Jackson, NHS/N 2102N40DRRoss David R · Wakeman, OHBuilt 1991 · S/N DR-01N40DZSt. Bernard Aerial LLC · Kalispell, MTBuilt 1947 · S/N 12-2675N40EBWegman Jacob L · Rochester, MNBuilt 1985 · S/N 984N40EMYour Moms Upset LLC · Saint Paul, MNS/N 696-92N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40ESP.C. Air LLC · Lockport, NYBuilt 2008 · S/N 71432N40EZMaui Aero LLC · Yelm, WAS/N 69N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114N40GECuckler Dale E · Tulsa, OKBuilt 1998 · S/N 1545N40GRPetao LLC · Trinity, FLBuilt 2003 · S/N 21980N40HDDrollinger David H · Kennewick, WABuilt 1987 · S/N 040N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40HUMoore Charles B · Miles City, MTBuilt 1996 · S/N 1315N40HYHendrickson Dale W · Denton, TXBuilt 2002 · S/N 2205N40JTav8rs LLC · Tea, SDS/N 001N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036N40JGSimms Charles Jr · Lexington, KYBuilt 1968 · S/N 28R-30953N40JKMann Nathan · Poulsbo, WABuilt 2022 · S/N 11480N40JMAll Breeds Combined LLC · Kalispell, MTS/N 540-2011N40JVWhiting Andrew W · Mentor, OHBuilt 1977 · S/N 80N40KEValiair Lc Trustee · Casper, WYBuilt 2018 · S/N 70311N40KKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N KK-1N40KLConstantine Lucas L · Inglewood, CAS/N 40.316N40LLWalker Christopher J · Mason City, NEBuilt 2021 · S/N 3358N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MBAndersen Thomas · Yoder, COS/N 708N40MGFly Arkansas LLC · Harrison, ARBuilt 1959 · S/N TD-293N40MRWennberg Timothy J · Mariposa, CABuilt 1979 · S/N 001N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40PXHealey David A · Hammondsport, NYBuilt 2003 · S/N 14110CN40QWeiland Keith E · Chandler, AZBuilt 1946 · S/N 4611N40RBKmg Aviation Holdings LLC · Hartville, OHBuilt 1976 · S/N 177RG1071N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40SFSterling Flight Training LLC · Jacksonville, FLBuilt 2020 · S/N 2881377N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40STAvera Stewart · Pensacola, FLBuilt 1997 · S/N T106AN40TDobel Robert F II Trustee · San Carlos, CABuilt 1974 · S/N 1702N40TDWinick Evan K · Allentown, PABuilt 2006 · S/N 1N40TLAugust Aero LLC · Kalispell, MTBuilt 2002 · S/N D-2N40TMN40tm LLC · Wilmington, DEBuilt 1966 · S/N 1063N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N40TUParrot Cay LLC · Missoula, MTBuilt 1978 · S/N 18-7809143N40VVFaulkner Winthrop S · Anchorage, AKS/N 005
Back to AD 90-04-06 R1