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.

N161RLStovall Francis · Melbourne Beach, FLBuilt 2006 · S/N 80480N161RVMatice Brian W · Riverview, FLBuilt 2022 · S/N 74520N161RWMcdonald Walter S · Park City, UTBuilt 2006 · S/N 53MN161SAAviation Consultants Inc DBA · San Luis Obispo, CABuilt 2002 · S/N 901-2002N161SG3bs Aviation LLC · Wilmington, DEBuilt 2005 · S/N 1000-2005N161SHChurchill Dianne L · Jordan, MNBuilt 1976 · S/N 1921N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508N161SWLober Cameron K · Matthews, NCBuilt 1966 · S/N 28-3752N161TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881549N161WMWagner Scott · Cranberry Township, PABuilt 1988 · S/N 1N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677N1620ABeaver David W Trustee · Wasilla, AKBuilt 1952 · S/N 18-1263N1620GDrexler Charles T · Albuquerque, NMBuilt 1968 · S/N 123N1620PNielsen Mona · Ford, WABuilt 1954 · S/N 22-2434N1621HDavis Vance · Del Valle, TXS/N 177RG0794N1622AKelly Steven L · Saline, MIBuilt 2016 · S/N 5574N1622HSweeney Kay M · Kirkland, WABuilt 1975 · S/N 177RG0795N16244Oakland William S · New Port Richey, FLBuilt 1973 · S/N 28-7305211N1624GBarnett William M · Wasilla, AKBuilt 1968 · S/N 623N162505b Aviation LLC · Duncan, OKBuilt 1973 · S/N 28-7305212N16252Robbins Warren N · Chandler, AZBuilt 1973 · S/N 28-7305213N16257Chauvet Nicolas · North Kingstown, RIBuilt 1973 · S/N 28-7305216N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127N1625JCain Philip K · Escondido, CABuilt 1968 · S/N 28-24818N1625LArtime Jorge Daniel · Miami Beach, FLBuilt 1979 · S/N 13N1625PGauthier Robert Jones · Melba, IDBuilt 1954 · S/N 22-2439N1625RQuebe Jeffrey R · Fort Worth, TXFirst renewal noticeBuilt 1976 · S/N AA1B-0625N1626JLawrence Gavin · Borger, TXBuilt 1967 · S/N 28-24013N1626RRedman Lee · Moore, OKBuilt 1976 · S/N AA1B-0626N1627Johns Trevor M · Seattle, WABuilt 2015 · S/N 0021N16273Taildraggers LLC · Syracuse, KSBuilt 1973 · S/N 28-7305217N16278Cademartori Joel T · Norris, TNBuilt 1973 · S/N 28R-7335121N1627APlettner David C · Sutton, NEBuilt 1951 · S/N 18-1267N1627EWichterman George J Trustee · Fort Myers, FLBuilt 1978 · S/N 17271070N1627HCirrus Services Inc · Fargo, NDBuilt 1977 · S/N 28-7716028N1627PMiller Wesley M · Crookston, MNBuilt 1954 · S/N 22-2441N1627RRoettger Thomas D · Finksburg, MDBuilt 1976 · S/N AA1B-0627N16283Winn Philip P · Salem, OHBuilt 1973 · S/N 28-7325231N16284Rocco Jeffrey M · Carson, CABuilt 1969 · S/N 28-26015N16288Bailey Brent M · Dalzell, SCBuilt 1973 · S/N 28-7325234N16289Williams Kevin L · Buchanan, TNBuilt 1973 · S/N 28-7325235N1628GBistline Quentin J · Pahrump, NVS/N 626N1628HWarrior N1628h LLC · Huntsville, ALBuilt 1977 · S/N 28-7716029N16292Morcom Aviation Services Inc DBA · Everett, WABuilt 1973 · S/N 34-7350125N16293Quale Jeffrey L · Craig, COFirst renewal noticeBuilt 1973 · S/N 28R-7335123N1629EAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 17271072N1629JBuckley Barney P · Colfax, WABuilt 1967 · S/N 28-24016N1629RMavi Aviation Services LLC · Hickory, NCS/N AA1B0629N162ACWatson Tommy R · Thibodaux, LABuilt 1997 · S/N 1235-97N162ASA S Air LLC · Lantana, FLBuilt 1978 · S/N 17271785
Back to AD 90-04-06 R1