AD 98-15-13

Registered aircraft · 2,358

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:98-15-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:98-15-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.

N243PBFargo Jet Center LLC · Fargo, NDS/N FL-1359N244HAHowell Air LLC · Dover, DEBuilt 1996 · S/N LJ-1444N246AAAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB984N246CKMccarty David M · Baker City, ORBuilt 1976 · S/N LJ694N246GTWestern Pilot Service Inc · Phoenix, AZBuilt 2000 · S/N LJ-1591N246PHPhi Health LLC · Tempe, AZBuilt 1990 · S/N BB-1373N247CHShe Jane LLC · Laguna Beach, CABuilt 2016 · S/N FL-1042N247MDLta Group Holdings LLC · Amarillo, TXBuilt 1990 · S/N LJ1244N247SZSheetz Aviation Inc · Altoona, PABuilt 2016 · S/N FL-1056N248EXUnited States Navy · Patuxent River, MDS/N FL-450N248JHExecutive King Air Transportation Inc · Wilmington, DEBuilt 1982 · S/N BE-126N248PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N BB-1618N249CPAngels Envy Aviation LLC · Denison, TXBuilt 1979 · S/N LJ-841N249WM249 Aviation LLC · Richland, MSBuilt 1975 · S/N LW-139N24AWalker John D · Neosho, MOBuilt 1976 · S/N LW-210N24BGVarney Aviation LLC · Bangor, MEBuilt 1982 · S/N BB-1045N24EMAsphalt Aviation LLC · Conway, SCBuilt 1976 · S/N BE-6N24GNGlobal Air Concepts LLC · Anchorage, AKBuilt 1981 · S/N BB-953N24JDVac Sys Holdings LLC · Roseville, CABuilt 1981 · S/N LA-134N250AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N FM-25N250FCKorban Aviation LLC · Mcallen, TXFirst renewal noticeBuilt 1985 · S/N BB1215N250LHAl Air LLC · Knoxville, TNBuilt 2012 · S/N FL-813N250TTLakeside Metal Specialties Inc · Paragould, ARS/N BB1505N250WGChartco LLC · Salisbury, NCBuilt 2001 · S/N BB-1780N251CFN251cf LLC · Dove Canyon, CABuilt 1983 · S/N BB-1147N251JDepartment Of Homeland Security · Washington, DCS/N FM-100N252FLTenax Aerospace LLC · Ridgeland, MSS/N FL-421N252HRJohnson Breeders Inc · Rose Hill, NCBuilt 1999 · S/N FL-251N252RCPrestige Worldwide Flights Two LLC · Imperial, CABuilt 1987 · S/N LJ-1152N254PCAtlantic Wings LLC · New Bern, NCBuilt 1988 · S/N FA-160N255BBWright Aviation LLC · Charleston, TNBuilt 2018 · S/N FL-1161N255TTTrident Aircraft Holdings LLC · Nashville, TNBuilt 2002 · S/N BB-1798N259SCCei Inc · Wilmington, DES/N LW17N25GRBarrosa LLC · Scottsbluff, NEBuilt 1996 · S/N LJ-1440N25WCMau Leasing LLC · Newark, DEBuilt 1998 · S/N BB-1640N260TTTri-State Generation & Transmission Association · Westminster, COBuilt 2020 · S/N FL-1243N261GBSafford Aviation Service Inc · Coolidge, AZBuilt 1985 · S/N LJ-1119N261MAMajestic Aviation LLC · Decatur, ALS/N LA-61N262SPAluminum Eagle LLC · South Jordan, UTBuilt 1984 · S/N FA-33N263BACreative Life LLC · St Pete Beach, FLBuilt 2001 · S/N FL-333N264PARisk Assumption LLC · Horseshoe Bay, TXBuilt 1980 · S/N BE-86N264TSFoxtrot Aviation Services LLC · Canton, OHBuilt 1977 · S/N BE-24N266RDGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1633N267COldham Matthew Stephen · Lewisville, TXFirst renewal noticeBuilt 1980 · S/N LJ-896N268CACaruthers LLC · Moundville, ALBuilt 1978 · S/N LJ-759N268LBLark Builders · Vidalia, GABuilt 2007 · S/N FL-570N26ARDale Aviation · Rapid City, SDBuilt 2004 · S/N LJ-1725N26EDynamic Avlease Inc · Bridgewater, VAS/N LW-62N26PYColibri26 Inc Trustee · Wilmington, DEBuilt 1981 · S/N LA-141N26RERrr Aviation LLC · Gulfport, MSBuilt 1975 · S/N LJ-676
Back to AD 98-15-13