OpenAirDocs.org
AD 91-23-02

Registered aircraft · 238

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:91-23-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-23-02')
  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.

N10035R H Lindsay & Assoc Inc · Canby, ORS/N 970N100HUSimpson Jared S · Malad City, IDBuilt 1996 · S/N 1319N103TBSugasa David · Imlay, NVBuilt 1989 · S/N 1078N104CAMeggers Roger D · Baker, MTBuilt 1996 · S/N 1338N107AMYoung Mark · Vancouver, WABuilt 1997 · S/N 1385N111TQEngbring Paul · Telluride, COBuilt 1993 · S/N 1243N116QCigarroa Jorge J · Laredo, TXBuilt 1997 · S/N 1360N117RJFine Frank E · Oakdale, CAS/N 1314N11KZHigh Tale LLC · Saint Anthony, IDBuilt 1998 · S/N 1393N121HHTimm Robert S · Minneapolis, MNBuilt 1992 · S/N 1209N1275BWeisgram Ted · Corbett, ORBuilt 1995 · S/N 1287N12HUVintage Flyers LLC · The Villages, FLBuilt 1997 · S/N 1345N12TQWyoming Aeroflight LLC · Laramie, WYBuilt 1994 · S/N 1270N12WPSpradlin Flying Service Inc · Petersburg, TXS/N 1013N13HUSzalay Dennis R · Mooresville, INS/N 1323N141PAMosley John E · Jackson, MSBuilt 1990 · S/N 1115N14KKBeachrock Logistics LLC · Lafayette, LABuilt 1994 · S/N 1272N14VVHusky Air Corp · Scipio Center, NYBuilt 1988 · S/N 1057N151SLChambers Scott K · Aurora, ORBuilt 1993 · S/N 1255N157TBPerrin James F · Bancroft, WIBuilt 1997 · S/N 1389N15HUBratton Gary · Poteau, OKBuilt 1996 · S/N 1318N17SLTastad Joel M · Hager City, WIBuilt 1997 · S/N 1368N180HJSummit Peak Holdings LLC · Missoula, MTS/N 1305N180HUScarberry Dennis Lee · Goddard, KSBuilt 1996 · S/N 1333N188WBNelson Pete L · Challis, IDBuilt 1994 · S/N 1263N193JTMaroon Aviation LLC · Ferriday, LAS/N 1233N194RLDorris Richmond Sloan · Anchorage, AKS/N 1266N196PFCloudbase Imaging LLC · Erie, COBuilt 1995 · S/N 1301N200HGBallou-Crawford Terry F · Enid, OKS/N 1200N200HUVanderhoof Chad T · Elk, WABuilt 1992 · S/N 1203N20495Pitts Dan O · Soldotna, AKBuilt 1988 · S/N 1045N206YBowe Walter C Trustee · Sonoma, CAS/N 981N21AWMershon James W · Newcomerstown, OHBuilt 1998 · S/N 1399N21HUSkyline Aviation LLC · Lewistown, MTBuilt 1995 · S/N 1291N225YWhite Wings LLC · Anchorage, AKBuilt 1990 · S/N 1133N22HUGove Gary Alan · Marion, MTS/N 1355N234HUStevens Matthew S · Penn Yan, NYBuilt 1996 · S/N 1336N236CDLoven Richard · Waukon, IABuilt 1992 · S/N 1219N23HGWilkinson Dan · Morgan, UTBuilt 1994 · S/N 1269N241PArnston Ranch Inc · Circle, MTBuilt 1992 · S/N 1214N258AKThompson Nick · Eagle, AKBuilt 1994 · S/N 1258N27HUOlson Dorian J · Lake Park, MNBuilt 1997 · S/N 1359N2864WSpearhead Ranch LLC · Douglas, WYBuilt 1987 · S/N 1001N2866BBulger Edward P · Newburyport, MAS/N 1002N2868DMayer Larry A · Billings, MTBuilt 1987 · S/N 1004N2868MEngler Eric M DBA · Cass City, MIBuilt 1987 · S/N 1005N28706Kalus Joseph G · Afton, WYBuilt 1987 · S/N 1007N2870DBardsley Lucas A · Sutton, AKBuilt 1987 · S/N 1006N2878XKing Jennifer M · Eagle River, AKBuilt 1987 · S/N 1008N2879TWark John Charles · Pueblo, COBuilt 1987 · S/N 1009
Back to AD 91-23-02