AD 96-03-13

Registered aircraft · 1,042

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

N838PSNocom Aviation LLC · Stratford, TXBuilt 1983 · S/N BB-1084N83FTR E E Inc · Beaumont, TXBuilt 1998 · S/N BB-1621N83KACcs Enterprises LLC · Maryville, TNBuilt 1983 · S/N BB-1111N83PWMotion Skies LLC · Rocky Mount, NCBuilt 1987 · S/N BB-1283N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841N843BCA To Z Aviation LLC · Paradise Valley, AZS/N BB-1011N847BABeech Transportation Inc · Eden Prairie, MNBuilt 1981 · S/N BB847N847DBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N BE-91N84CANeojet N84ca LLC · Reno, NVBuilt 1976 · S/N BB-166N84JLChieftain Equipment LLC · Longview, TXBuilt 1980 · S/N LA-18N84PCAviation Enterprises LLC · Longwood, FLBuilt 1981 · S/N BB-860N84XPF B T Services LLC · Portland, ORBuilt 1979 · S/N BB481N850BKRpm Consulting LLC · Middletown, DEBuilt 1981 · S/N BB-896N852JPDavis Aviation Inc DBA · Brandon, MSBuilt 1979 · S/N BB-516N858GFCal-Ore Life Flight LLC · Brookings, ORS/N BB-1858N859GAIsr Platforms LLC · Mclean, VABuilt 1980 · S/N BT-12N85HWHigh Notes LLC · Nashville, TNBuilt 1994 · S/N BB-1498N85UTFly Mwm LLC · Kemah, TXBuilt 1980 · S/N BB-678N85XPB&J Aircraft LLC · Alice, TXS/N BB1202N860GCHiggins David L · Chevy Chase, MDBuilt 1986 · S/N BB-1245N8611RGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-482N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493N862HTSublett Holdings LLC · Wilmington, DEBuilt 1981 · S/N BB-800N867SLSafeco Leasing LLC · Port Alsworth, AKS/N BB-867N86NBClairmont Holdings Vi LLC · St Thomas, VIS/N B166N873AFDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1984 · S/N BB-1200N874SPSamaritans Purse · Boone, NCBuilt 1981 · S/N BB-874N875DMKilo Alfa 200 LLC · Bakersfield, CABuilt 1990 · S/N BB-1354N875SPPacific Mission Aviation · Hagatna, GUBuilt 1975 · S/N BB-86N87699Pjh Consulting LLC · Reno, NVBuilt 1981 · S/N BB-887N876ATTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N BB-931N877PAPax Dei LLC · Hot Springs, ARS/N BB-1844N877RCPlg Aviation LLC · Tucson, AZBuilt 1981 · S/N BB-978N879TYKimmel Aviation LLC · Madison, MSBuilt 1978 · S/N BB-498N87CFFeltus Aviation LLC · Little Rock, ARBuilt 1983 · S/N BB-1122N87FPMillman Transportation LLC · Saint Louis, MOBuilt 1997 · S/N BB-1565N87NWAlbatross Air Inc · Beaver, WVBuilt 1978 · S/N BE-42N87SALiberty Air LLC · Christiansted, VIFirst renewal noticeBuilt 1982 · S/N BB-1089N880MBWabash Wings LLC · Fishers, INBuilt 1981 · S/N BB-928N881MCFoothills Aviation Partners LLC · Winston Salem, NCS/N BB-1930N882JPJpb Air LLC · Rancho Santa Fe, CABuilt 1981 · S/N BB-882N888ETBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N BB-258N888HJAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB444N888MPProbasco Mitch · Floydada, TXBuilt 1990 · S/N BB-1358N888ZXEm Air LLC · Richland, WABuilt 1983 · S/N BB-1140N88FARegistration Pending · Helena, MTRegistration pendingBuilt 1979 · S/N BE-74N88JHTeton Aviation Limited Liability Company · Wilson, WYBuilt 1989 · S/N BB-1331N88MTFlight Company LLC · Rome, GABuilt 1981 · S/N BB-830N88MYBullrock Corp · South Burlington, VTBuilt 1983 · S/N BB-1142N88VNAt Aero LLC · Wilmington, DEBuilt 1986 · S/N BB-1250
Back to AD 96-03-13