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.

N9158HParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1975 · S/N 17265982N9158VMellinger David S · Lusby, MDBuilt 1969 · S/N 690040N9158YLockwood Rick I · Garden Grove, CAS/N 18-8911N91596West Michigan Flying Club Inc · Norton Shores, MIBuilt 1973 · S/N 17261505N9159HHess Garrett · Fullerton, CAS/N 17265983N9159KRoss Andrew · Yamhill, ORBuilt 1976 · S/N 28R-7635223N9159VSmith Darryl Edward · Houston, TXS/N 690033N915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeBuilt 1951 · S/N 22-218N915AAHoecher Robert T · Anchorage, AKFirst renewal noticeBuilt 1977 · S/N 15280359N915AZN915az LLC · Miami, FLBuilt 1974 · S/N 34-7450199N915CMVaayu Aviation LLC · Newark, CABuilt 1972 · S/N 17261229N915CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8335N915GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881073N915GWWills Gary W · Channahon, ILBuilt 2012 · S/N 71267N915JBKruger Karl A · Monterey, TNBuilt 2018 · S/N 73660N915JDDowling Jeffrey T · Poplar Grove, ILBuilt 2003 · S/N 20098N915KPhelps Lawrence D · Vinton, IAS/N 001N915KKKramer Kurt J · Volcano, CABuilt 2022 · S/N 25744N915LCardinal Flying Corp · San Jose, CABuilt 1976 · S/N 17267355N915LFLingo Joshua B · Oak Grove, LABuilt 1998 · S/N 390-98N915MBBarras David G · Breaux Bridge, LABuilt 2004 · S/N 1N915NCMiller Nevin D · Naples, IDBuilt 2009 · S/N 91522N915PSmith Jr Franklin R · Rock Hill, SCBuilt 2012 · S/N 90856N915PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843304N915PBLease Lawrence · Royal Oaks, CABuilt 2010 · S/N 91523N915RDDavis Richard L · Kenai, AKBuilt 2007 · S/N 122284N915RSHayward Houston C · Lansdale, PABuilt 1999 · S/N 1260-99N915RVWiegand Jeffrey L · Ocean Isle Beach, NCBuilt 1999 · S/N 22356RV6N915TAAurora Aircraft LLC · Waterford, MIBuilt 2006 · S/N 172S10358N915TTLake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 28-7890158N915WBBordelon Warren P · Breaux Bridge, LABuilt 1972 · S/N 17261221N915WVSmith Aviation LLC · Springer, OKBuilt 1959 · S/N TD-236N9160DMalsby Thomas H · Blairsville, GABuilt 1958 · S/N 22-6212N9160HTodd Media Inc · Tuscaloosa, ALBuilt 1975 · S/N 17265984N9160JMohan Aditya · Rancho Cordova, CAS/N 28-3218N9160VLangis Maximus · Newburyport, MABuilt 1969 · S/N 690029N9161FHuie John E · Burnet, TXBuilt 2002 · S/N 001N9161HAir Athens LLC · Athens, GABuilt 1975 · S/N 17265985N9161JNortheast Nebraska Aviators Inc · Wayne, NEBuilt 1966 · S/N 28-3220N9161SCarr Jack Willson · East Lansing, MIBuilt 1975 · S/N MB-785N9161VKaroki Jonah · Strasburg, COBuilt 1969 · S/N 690034N91622Utterback Karl D · Fort Wayne, INBuilt 2002 · S/N M-II-1820N9162HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17265986N9162JHillelson Lawrence E · Grosse Ile, MIBuilt 1966 · S/N 28-3221N9162NMann Aviation LLC · Wilmington, DEBuilt 1998 · S/N 24-3421N91631Seale Taylor Edward · Madison, WIBuilt 1993 · S/N 2890177N91634Tharp Anthony W · Charleston, WVBuilt 1993 · S/N 2890178N9163DRubbert Jan Dale · Upham, NDBuilt 1958 · S/N 22-6216N9163JCavu Flight Training LLC · Freeport, MEBuilt 1966 · S/N 28-3222N9163QWebb John L · Elgin, TXBuilt 1998 · S/N 24-3422
Back to AD 90-04-06 R1