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.

N888CKRadel James C · Sunbury, PABuilt 1989 · S/N 888PMN888CMKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 17267424N888DLCsc Enterprises Inc · Atlanta, GABuilt 1999 · S/N 2980N888EJInternational Air Services Inc Trustee · Carson City, NVS/N 2816082N888ERFrost Aviation Alliance LLC · Tampa, FLBuilt 1974 · S/N 28-7505087N888EXTuinstra Aaron C · Marinette, WIBuilt 2013 · S/N 83233N888EZRabideau Jacob N · Tehachapi, CABuilt 1983 · S/N 564N888FWLimbacher Richard A · Stone Creek, OHBuilt 1960 · S/N 115N888GCBachmann Aviation LLC · Marshall, VABuilt 2005 · S/N 3857N888GHCardinal Gregory Joseph · Minneapolis, MNBuilt 1992 · S/N 52N888GMStevens Ryan · Presque Isle, MEBuilt 1977 · S/N 28-7716264N888HUPeoples Michael L Jr · Rockwall, TXBuilt 1998 · S/N 1397N888JDThille Nicholas M · San Luis Obispo, CABuilt 1968 · S/N TD-720N888KCGrimes Joshua R · Lock Haven, PABuilt 1978 · S/N 38-78A0115N888KHFranklin Vernon L · Aguila, AZBuilt 2005 · S/N 25478N888LAFrank John F · Baden, PABuilt 1987 · S/N 001N888LCDay Michael J · Fort Wayne, INBuilt 1964 · S/N 30-272N888LEStockton Raymond L · Pearl City, HIS/N 15279620N888LHReece Connor I · Green Cove Springs, FLBuilt 1997 · S/N 21045N888QCShipley Ryan Paul · Keller, TXBuilt 1977 · S/N 28-7716175N888SKKelly Erin C · Bend, ORBuilt 1978 · S/N 7-0407N888TACurrier Winston F · Monroe, NHBuilt 1975 · S/N 17266196N888TBBlock Scott · Chandler, AZFirst renewal noticeBuilt 1969 · S/N 17257895N888TSSeher Jacob Scott · Reno, NVBuilt 2000 · S/N 80556N888VMDaniels Michael R · Mc Donald, PABuilt 1973 · S/N 17702021N888VRChambers Donald R II · Medford, ORBuilt 1999 · S/N 80356N888VTPam Aire LLC · Cedar Hill, TXBuilt 1968 · S/N 28R-30842N888WKennedy Craig D · Santee, CABuilt 1956 · S/N 029N888WNPropeller Nomad LLC · Mendota Heights, MNBuilt 2015 · S/N 83229N888WTBoatman John Jr · Smyrna, TNS/N K-1N888ZGNess Aviation LLC · Moriarty, NMBuilt 1974 · S/N 28-7525109N888ZMHester Daniel R · Round Rock, TXBuilt 2005 · S/N 81688N8890JBlease Ronald B II · Moultrie, GABuilt 1965 · S/N 28-2865N8890KFgds Aviation LLC · North Fort Myers, FLBuilt 1967 · S/N 28-23761N8890VBig Q Aviation · Helena, MTBuilt 1974 · S/N 17264248N88914Wasik Marvin B · Hernando, FLBuilt 1975 · S/N 30N8891CSchroeder Thomas M · Georgetown, TXBuilt 1953 · S/N 22-1478N8891JAdamson Steven C · Stockbridge, GABuilt 1965 · S/N 28-2866N8891LSchendel-Adolf · Elk Grove, CABuilt 1974 · S/N AA5-0695N8891NAlred Steven J · Centre, ALBuilt 1969 · S/N 28-25755N8891VPropel Air LLC · Pottstown, PABuilt 1974 · S/N 17264249N8891YGreat Plains Aero Inc · Iowa City, IABuilt 1970 · S/N 39-49N8892JA&R Aviation LLC · Houston, TXBuilt 1965 · S/N 28-2867N8892VBillingsley Carl R · Henderson, TXBuilt 1974 · S/N 17264250N8893CAirquest Aviation Lp · Butler, PABuilt 1976 · S/N 28-7615132N8893JWare Wilson · Rockwall, TXS/N 28-2868N8893VEast Tennessee Pilots Club · Knoxville, TNBuilt 1974 · S/N 17264251N8894Buth Elizabeth · Wasilla, AKBuilt 1973 · S/N 478-73N8894CBrent Thomas P · Walnut, MSBuilt 1953 · S/N 22-1475N8894DPyle Jarod H · Wasilla, AKBuilt 1958 · S/N 18-6368
Back to AD 90-04-06 R1