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.

N400DAFive Saguaro Leasing LLC · Albuquerque, NMBuilt 1984 · S/N FA-11N400EMGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1601N400GWGpw LLC · Laurel Springs, NCBuilt 1997 · S/N BB-1583N400RVMach Point Nine LLC · Phoenix, AZBuilt 1979 · S/N LJ-853N400SCN400sc LLC · Walterboro, SCBuilt 1982 · S/N BB-1040N401NSNs 300 LLC · Atlanta, GABuilt 1985 · S/N FA-28N402RX56 Express LLC · Willmar, MNBuilt 1988 · S/N FA-163N403EMMach Point Nine LLC · Phoenix, AZBuilt 1981 · S/N LJ1000N404JPParish Planes LLC · Tullahoma, TNBuilt 1982 · S/N LJ-1039N4053HCosmos Holdings Group LLC · Newark, DEBuilt 2001 · S/N BB-1774N405DDVineripe Inc · Delano, CAS/N LJ-1748N405PTDodson International Parts Inc · Rantoul, KSS/N BB-930N405WKLasai Aviation LLC · Reston, VABuilt 2004 · S/N FL-405N406RLSkyline Construction Services Inc · Eatonton, GABuilt 1999 · S/N LJ-1574N406SFNew Mexico State University · Las Cruces, NMBuilt 1977 · S/N LW-218N408SRNorth Slope Borough · Barrow, AKBuilt 2011 · S/N FM-51N40BA711bn LLC · Miami, FLBuilt 1969 · S/N LJ-444N40GZAirtrex Aircraft Alpha Inc · Wichita, KSBuilt 2004 · S/N FL-400N40RDAfh Interests LLC · Fort Worth, TXBuilt 2000 · S/N LJ-1615N40SBSan Bernadino County Sheriffs Office · San Bernardino, CABuilt 1976 · S/N BD-09N40XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N LJ-1640N40YDynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BP-30N410CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N FM-85N410LKBeachview Aviation LLC · Wilmington, DEBuilt 2009 · S/N FL-669N410MCBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N LJ-761N410RTStewart Aviation Services LLC · Birmingham, ALBuilt 2007 · S/N BB-1978N411CCSunshine Aviation LLC · Roseburg, ORS/N BB-1520N411FTUS Aviation Corp · Miami, FLBuilt 1969 · S/N LJ-443N411GCWb Air2021 LLC · Cochran, GABuilt 1997 · S/N FL163N411KCPonderosa Aviation LLC · Safford, AZBuilt 1981 · S/N BB-901N411WAGuardian Flight LLC · Lewisville, TXBuilt 1988 · S/N BB-1294N411WCBpi LLC · Maple Lake, MNBuilt 2007 · S/N FL-571N412CBGwvk LLC · Kansas City, KSS/N FL-440N412GDepartment Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-78N413GATurbo Prop Investors LLC · Parker, COS/N LJ1666N414RTPremier Aviation LLC · Philadelphia, MSBuilt 1981 · S/N LA-110N415TMCrouch Aire LLC · Westcliffe, COS/N BB-1762N416BKOptic Air LLC · Maurice, IABuilt 1978 · S/N LJ-816N416DFUsda Forest Service · Mcclellan, CABuilt 1985 · S/N BL-124N416MMTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1991 · S/N BB1416N416MRJosephine Air LLC · Castle Rock, WABuilt 1967 · S/N LJ-267N416NHBruair LLC · Cumming, IABuilt 2008 · S/N FL-602N416PMetro Aviation Inc · Shreveport, LABuilt 1980 · S/N LA-67N4170NBank Of Utah Trustee · Salt Lake City, UTS/N FL-270N417JBCape Fear Aviation Black LLC · Charlotte, NCBuilt 1988 · S/N LJ-1187N418JCsk Aviation Partners LLC · Fort Smith, ARBuilt 2000 · S/N BB-1705N419HFPvm Aviation LLC · Wilmington, DEBuilt 2017 · S/N FL-1121N419KDepartment Of Homeland Security · Washington, DCBuilt 2015 · S/N FM-64N41AKSubstation Air LLC · Midvale, UTBuilt 1982 · S/N LA-188N41BAFly Kronstadt LLC · Evanston, ILBuilt 1980 · S/N LJ-912
Back to AD 98-15-13