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.

N7677KDailing Todd A · Fort Atkinson, WIBuilt 1950 · S/N 20-498N7677PHenderson William C · Grafton, WVBuilt 1961 · S/N 24-2888N7677RAlpha Bravo Charlie 1 Corp · Houston, TXS/N M-1288N7677VDoxtator Christopher P · Covington, INBuilt 1982 · S/N 24-1328N7677WNikolic Peter Jr · Momence, ILBuilt 1964 · S/N 28-1663N76786Engeman Nathon G · Bend, ORBuilt 1946 · S/N 11218N7678DEldridge William D · Anchorage, AKBuilt 1957 · S/N 18-5900N7678GTanner Michael J · Hooksett, NHS/N 17259378N7678HGoth Tedd Lloyd · Hereford, AZBuilt 1946 · S/N 12-567N7678PMunday Jeff R · Waverly, GAS/N 24-2889N7678WDsr-Cherokee 180 LLC · Dallas, TXBuilt 1964 · S/N 28-1665N7679FScott Field Flying Club LLC · Elgin, IABuilt 1976 · S/N 28-7790215N7679GShipp-Hove Kylan · Mesa, AZBuilt 1970 · S/N 17259379N7679HSummerskyz Inc · Urbana, ILBuilt 2004 · S/N 3540N7679RSmith Melissa R · Atlanta, ILS/N MA-359N767ABKoelsch Anthony W · Anchorage, AKBuilt 2007 · S/N AB-1N767ACWooldridge Kent L · Albany, ORBuilt 2000 · S/N 410-2000N767AWTooth & Go Flyers LLC · Farmington Hills, MIBuilt 1964 · S/N 413N767BRRv8r Aviation LLC · Wilmington, DEBuilt 2017 · S/N 82410N767CDTyler Flyers Inc · Tyler, TXBuilt 1979 · S/N 17273607N767DCMariah Aviation Corp · Miami, FLBuilt 2000 · S/N 60034N767DNRegistration Pending · Manchester, MIRegistration pendingBuilt 1943 · S/N 75-5533N767DPBeardsley William A · Tracy, CABuilt 1963 · S/N 188N767ERJet Stream Jockey LLC · Venice, CABuilt 2005 · S/N 3956N767EWShaffer Jon Michael · Colorado City, COBuilt 2008 · S/N 72138N767FTRenner Brian E · North Port, FLBuilt 1978 · S/N AA5A0646N767GCKiernan Eric J · Bozeman, MTBuilt 2002 · S/N 23683N767GLShemo George T · Newnan, GABuilt 2006 · S/N 71543N767GPGoodwinds Aero LLC · Roseburg, ORBuilt 2000 · S/N 25578N767GSGriffith William A · Gainesville, GABuilt 2002 · S/N 81074N767HWMercer Kenneth D · What Cheer, IABuilt 1988 · S/N 111226-01N767JJLiberty Aero Executives LLC · Carmel, INBuilt 1999 · S/N 13N767JMMc Kiernan John E · Navarre, FLBuilt 2008 · S/N 72646N767JSStarr Jeffrey J · Naperville, ILBuilt 1982 · S/N STARR-0001N767JWRoads End Aero LLC · Erwinna, PABuilt 1971 · S/N 7777N767KLLowrance Kathleen C · Port Orange, FLBuilt 1978 · S/N 18-7809079N767KPPhill-Air Inc · Dover, DEBuilt 1966 · S/N 30-1193N767LAN767la LLC · Philadelphia, PABuilt 2025 · S/N 28020219N767LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1905N767LWMiller Wayne L · Santa Monica, CABuilt 2016 · S/N SC009N767NTognoli Steve F · Union, ORBuilt 1955 · S/N 18-4484N767NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881035N767PAviation Investments Inc · Virginia Beach, VAS/N 262-73N767PAPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 4496114N767PEDaytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350042N767PMMccord Paul F · Indianapolis, INFirst renewal noticeBuilt 1995 · S/N 2464N767RCTalarik Air LLC · Memphis, TNBuilt 2003 · S/N 21975N767SECoyote Aviation LLC · Carefree, AZBuilt 2004 · S/N 1374-2004N767TVMurphy Craig D · Boise, IDBuilt 2008 · S/N 81690N767WMMcmaster Wayne R · Jeffersonville, INBuilt 2010 · S/N 71293
Back to AD 90-04-06 R1