OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N15483Tnj First Class Flying Properties LLC DBA · Dallas, TXBuilt 1972 · S/N 28-7305082N15484Thompson Mark L · Kirksville, MOBuilt 1972 · S/N 28-7325076N15489Black Knights Transportation Services LLC · Garden Grove, CABuilt 1972 · S/N 28-7325079N1548HShrader Brian K · Marion, INBuilt 1975 · S/N 177RG0722N1548PUS Aviation Training Solutions · Titusville, FLBuilt 2005 · S/N 0199N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048N15499Lankford Toby C · Canadian, TXBuilt 1972 · S/N 28-7325080N1549ADirk Chantz M · Rapid City, SDS/N 20-752N154ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010049N154AVDaviation Inc · Willoughby, OHBuilt 1985 · S/N 28-8616018N154DMMason David W · Reklaw, TXBuilt 1963 · S/N DM-001N154DSIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.461N154ERN154er LLC · Kissimmee, FLBuilt 1989 · S/N 2841182N154FTMiloud Chadd K · Fort Worth, TXS/N 28-8216194N154GRRussell Gregory · Stevensville, MDBuilt 1976 · S/N AA5A-0213N154JBLevingston Brendan W · Denali Park, AKBuilt 1979 · S/N 15282685N154MDSwenson John E · Belgrade, MTS/N 154MDN154NWoods John · Eagle River, AKBuilt 1955 · S/N CH-333N154PAParagon Airplane Leasing Co · Fort Myers, FLBuilt 2020 · S/N 28020012N154PKPerry Patrick J · Dallas, PABuilt 2001 · S/N 154N154RAFulwiler Air LLC · Green Bay, WIBuilt 2005 · S/N 1391-2005N154SKReign Aviation LLC · Fresno, CABuilt 1978 · S/N 15282110N154TKornchuk Kurt C · Wasilla, AKS/N 18-2268N154WKObx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 451-74N154ZPAirsign Airships America LLC · Williston, FLBuilt 1999 · S/N 104N15504N15504 LLC · Eatontown, NJBuilt 1972 · S/N 28-7325082N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043N1550VJar Investments LLC · Kalispell, MTBuilt 1974 · S/N 17263655N1550XVictors Vectors LLC · Valparaiso, INS/N 28R-7535323N15510Lok Kevin K · Upper Sandusky, OHBuilt 1972 · S/N 28-7305084N15517Little Ralph D · Rockwall, TXBuilt 1972 · S/N 28-7325085N15518Registration Pending · Concord, CARegistration pendingBuilt 1972 · S/N 28-7325086N1551PPhillips Kris D · Cordova, AKBuilt 1954 · S/N 18-3704N1551RRegistration Pending · Plumas Lake, CARegistration pendingBuilt 1976 · S/N AA1B-0601N1551SVoelker Craig C · Mount Pleasant, IABuilt 1972 · S/N 28-7305085N1551VBumpe Logistics LLC · South Jordan, UTBuilt 1974 · S/N 17263656N1552Scholz Francis M · Atchison, KSBuilt 1971 · S/N DVI-001N15523Derryberry Clay · Lewisburg, TNBuilt 1972 · S/N 28R-7335065N15524Brown Gerald · Apple Valley, MNBuilt 1972 · S/N 28R-7335066N15529Pattie Donald D · Zephyrhills, FLBuilt 1972 · S/N 34-7350072N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726N1552JBoles Brian D · Watkinsville, GABuilt 1967 · S/N 28-23956N1552PErickson James M · Wasilla, AKS/N 18-3705N15533Standard Day Aviation LLC · Garland, TXBuilt 1972 · S/N 28-7325091N15534Daly James Kieran · Hopewell, NYBuilt 1972 · S/N 28-7305086N1553HBuckner Robert M · Eufaula, OKBuilt 1975 · S/N 177RG0727N1553JCarr Jason M · Cypress, TXBuilt 1967 · S/N 28-23957N1553MRubbert Jan D · Upham, NDBuilt 1947 · S/N 12-3125N1553RF & S Aviation LLC · Kula, HIBuilt 1976 · S/N AA1B0653N15544Sedberry Jason A · Kokomo, INS/N 28-7325094
Back to AD 90-04-06 R1