OpenAirDocs.org
AD 96-18-13

Registered aircraft · 1,110

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-18-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-18-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.

N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332N282TRed Star Aero Holdings LLC · Lewes, DEBuilt 1974 · S/N 42N285CTCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1983 · S/N 085N285DHRoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 026N288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 148N28DCMbogo Energy LLC · Boerne, TXBuilt 1994 · S/N 139N28PHYoung Family Aviation LLC · Sugar Grove, ILS/N 194N28TXMidwest Flying Service Dos LLC · Sheldon, IABuilt 1992 · S/N 650-7007N28USN28us LLC · Miami, FLBuilt 1993 · S/N 242N28ZFCore Projects Inc · Fresno, CAS/N NA0458N290CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 090N290GSBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 2038N290MXJbs Aviation LLC · Great Neck, NYS/N 199N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317N292PCLightfoot Holdings LLC · Dover, DEBuilt 1982 · S/N 99N292WALifetime Chimney Supply LLC · Plainview, NYS/N 207N293PWatkins Air LLC · Mountain Brk, ALBuilt 1990 · S/N 049N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343N29LNLucky29 Liquors LLC · Loveland, COS/N 389N2FQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 167N2SMMagnus Caro LLC · Alpine, WYBuilt 1991 · S/N 040N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487N300TCOrlando Financial Corp · Bear, DEFirst renewal noticeBuilt 1978 · S/N 241N300XL1911 Partners LLC · Rockledge, FLBuilt 1979 · S/N 276N303PCJc Pace Holding Co · Fort Worth, TXBuilt 1999 · S/N 650-7098N303PM303pm LLC · Lakewood, COBuilt 1982 · S/N 103N303XX303 Aviation LLC · North Plains, ORS/N 196N304PCFlorida Avm LLC · Venice, FLBuilt 1986 · S/N 650-0110N305BBBsc Landing LLC · Saint Louis, MOBuilt 1999 · S/N 105N306PAAerotrust Services Corp Trustee · Wilmington, DES/N 650-0053N307DLNova Jets USA Corp · Orlando, FLS/N 2002N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665N308MRStonegate Holdings LLC · San Antonio, TXBuilt 1988 · S/N 650-0153N30AXN27ax LLC · Tulsa, OKBuilt 2001 · S/N 141N30LJWorldwide Aircraft Services Inc · Tampa, FLBuilt 1988 · S/N 002N30MRBergen Food Enterprises Inc · Norman, OKBuilt 1978 · S/N 225N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152N30TKGravitas Aero LLC · Dallas, TXBuilt 1982 · S/N 374N310LJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 031N310ZAZair Force One LLC · Mendenhall, MSBuilt 1987 · S/N 009N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314N311FLAlliance Aviation Group LLC · Wilmington, DEBuilt 1997 · S/N 258338N311KBJet Plaid LLC · Nashville, TNBuilt 2004 · S/N 135N311RSKen Sale Resources Inc · Southlake, TXBuilt 1977 · S/N 5222N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N312LGJet Masters LLC · Englewood, COBuilt 1982 · S/N 489N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436N314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 133N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400
Back to AD 96-18-13