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.

N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239N123EDFrench Fly LLC · San Jose, CAS/N 258366N123RCBwa Westwind 2 LLC · Orlando, FLS/N 349N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046N125TKSupreme Sky LLC · Farmers Branch, TXBuilt 1994 · S/N 247N125TNTriad Aviation LLC · Tyler, TXBuilt 1993 · S/N 650-7025N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096N127PTN325nw LLC · Lodi, OHBuilt 1981 · S/N 337N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212N129GBCapital Cost Corp · Wilmington, DEFirst renewal noticeBuilt 1983 · S/N 650-0006N12GXEast 2 West Aero · Palm Beach Gardens, FLBuilt 1980 · S/N 031625N12RPRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 278N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590N131PGAga Aviation LLC · Lewes, DEBuilt 1986 · S/N 650-0126N132CESouthern Energy Transport LLC · Shelbyville, TNBuilt 1995 · S/N 650-7061N133EJHale William Trustee · Loveland, COBuilt 1977 · S/N 133N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697N135SHMed Air LLC · Wilmington, DEBuilt 1981 · S/N 335N136JPCasmos LLC · Wilmington, DES/N 35A-359N137SHDream Global Parts LLC · Lawrence, KSS/N 137N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139N13ADN13ad LLC · Dover, DES/N 030N140HMHarbert Aviation 40 LLC · Birmingham, ALBuilt 2008 · S/N 2103N140WHVarney Aviation LLC · Bangor, MEBuilt 1991 · S/N 650-0195N141AELake Superior College · Duluth, MNBuilt 1981 · S/N NA0306N141JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 2010N143LJBchjet3 LLC · Greer, SCS/N 143N145LRCalchem Transportation LLC · Stockton, CABuilt 2000 · S/N 119N146EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 146N147GXAltair Aviation LLC · Missoula, MTBuilt 1987 · S/N 214N14NAAnschutz Corp · Englewood, COBuilt 1992 · S/N 124N14PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 258317N150EXDodson International Parts Inc · Rantoul, KSS/N 262N150JGHardaway Capital Group One LLC · Stateline, NVBuilt 1992 · S/N 233N150SBRegistration Pending · Anchorage, AKRegistration pendingBuilt 1991 · S/N 258197N152FJVictory Outreach International · San Dimas, CABuilt 1984 · S/N 152N154LAAnschutz Corp · Englewood, COBuilt 1982 · S/N 127N154RRN154rr LLC · Wilmington, DEBuilt 1998 · S/N 258375N155ERAir Medical Services LLC · Denver, NCBuilt 1984 · S/N 55-098N156AWAlice Town Air Assets LLC · Fort Lauderdale, FLBuilt 1987 · S/N 184N156NSNunya LLC · Costa Mesa, CABuilt 2004 · S/N 258668N156REOnward & Upward Aviation LLC · Lake Mary, FLBuilt 1985 · S/N 156N158ECHhh Aviation LLC · Des Moines, IABuilt 2001 · S/N 186N159RABar Aircraft Leasing LLC · Waterford, MIBuilt 1975 · S/N 024N15BADodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 020N15RKPlane Part Solutions LLC · Lake Park, FLBuilt 1996 · S/N 258297N15VXTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 158
Back to AD 96-18-13