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.

N8393CAndersen Robin L · Cloverdale, CABuilt 1976 · S/N 28-7690131N8393LJohns Ryan · Sabillasville, MDBuilt 1968 · S/N 17256593N8393RFisher B Barton · Bowman, NDBuilt 1966 · S/N 28-22270N83947Iziair LLC · Mclean, VAFirst renewal noticeBuilt 1981 · S/N 28-8190247N8394CThree Rivers Aero LLC · Three Rivers, MIBuilt 1976 · S/N 28-7690132N8394DPray Aviation Inc · Augusta, KSBuilt 1981 · S/N 28-8116238N8394WLockhart Flying Club · Lockhart, TXBuilt 1965 · S/N 28-2602N8394YGadamic LLC · Fresno, CABuilt 1981 · S/N 28-8190246N8395APrecision Drilling Services LLC · Honolulu, HIBuilt 1981 · S/N 28-8190248N8395CN8395c LLC · Peachtree City, GABuilt 1976 · S/N 28-7690133N8395HApple X05 LLC · Spring Hill, FLBuilt 1981 · S/N 28-8190249N8395RRegistration Pending · Dover, DERegistration pendingBuilt 1966 · S/N 28-22272N8395VVandeman Jack A · Norco, CABuilt 1966 · S/N 530N83960Paris Air Inc · Vero Beach, FLBuilt 1981 · S/N 28-8116244N8396EFors Warren Hal · Salt Lake City, UTS/N 1616N8396LEmerald Coast Aircraft LLC · Panama City Beach, FLBuilt 1981 · S/N 28-8190288N8396RPatton Graham S · Chattanooga, TNBuilt 1966 · S/N 28-22273N8396WCarpenter Kenneth G · Dripping Springs, TXS/N 28-2606N8396YPerkins Christopher R · Brackettville, TXBuilt 1967 · S/N 30-1492N8396ZSaflite Pilot Training Inc · Hooksett, NHS/N 28-8116243N83974Otoole Airways LLC · Great Neck, NYBuilt 1981 · S/N 28-8190254N8397CParker Edward M Jr DBA · Griffin, GABuilt 1976 · S/N 28R-7635156N8397LWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8190252N8397RMiller Dean R · Edmond, OKBuilt 1966 · S/N 28-22274N8398AKeller William F · Burbank, CABuilt 1983 · S/N 0344N8398LWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 17256598N8398RParker Jeffrey S · Aurora, OHBuilt 1966 · S/N 28-22275N8398WFlaspohler David E Trustee · Lake Lotawana, MOBuilt 1965 · S/N 28-2608N83993Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8216007N8399LSanders George W Jr · Cloverdale, INBuilt 1968 · S/N 17256599N8399YHirschler Andre N · Goshen, INBuilt 1966 · S/N 30-1137N839AConfederate Airforce Corp · Lewes, DEBuilt 1958 · S/N 477-26N839ABMaloy Alec Stephan · Houston, TXBuilt 2020 · S/N 83339N839ALHorizon Dreams LLC · Homer, GABuilt 2000 · S/N 2843412N839HBlair Helicopter Service Inc · Lemoore, CABuilt 1975 · S/N 1090839N839JCGng LLC · New Market, ALBuilt 1973 · S/N 28R-7335193N839KTMiller Aviation Group LLC · Coon Rapids, MNBuilt 1982 · S/N M-2352N839RVHigh Performance Aircraft Products LLC · Bloomer, WIBuilt 2010 · S/N 90839N839SJj Aero LLC · Valley Center, KSBuilt 1995 · S/N 22061N83ABBaggett Billy E · Florence, ALBuilt 2004 · S/N 24954N83AFN83af LLC · Stuart, FLBuilt 2001 · S/N 17281052N83AGGleixner Aaron J · South Glastonbury, CTBuilt 2004 · S/N 80511N83BETecce Andrew J · Cambridge, MDS/N 28-22218N83BWJohnson Nathan D · Pacheco, CABuilt 1965 · S/N 30-888N83BZNagy Brittany · Lady Lake, FLBuilt 2023 · S/N 71614N83DFSchwendeman Mark W · Medina, TXBuilt 1985 · S/N 951N83DHHansen Douglas M · Garden City, SDBuilt 1997 · S/N 786-96N83DPPhilipsen David B · Bloomington, ILBuilt 1999 · S/N DMO 187N83DTAdams David V · Villa Ridge, MOBuilt 1995 · S/N 534N83DVRegistration Pending · Omaha, NERegistration pendingS/N 2134
Back to AD 90-04-06 R1