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.

N36988Bank Of Utah Trustee · Salt Lake City, UTS/N FL488N369MKKcha LLC · Chattanooga, TNS/N FL-369N369MWTextron Aviation Inc · Wichita, KSS/N FL-1369N369RSEarly Bird Air LLC · Lawrence, MIBuilt 1999 · S/N LJ-1571N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291N36TGRv Holding LLC · Winchester, MABuilt 1996 · S/N LJ-971N3700MBoeing Co · Berkeley, MOBuilt 1980 · S/N LW-340N37084Bank Of Utah Trustee · Salt Lake City, UTS/N FL482N370CSReach Air Medical Services LLC · Santa Rosa, CABuilt 1996 · S/N BB-1550N370UBoard Of Regents Of The University Of Oklahoma · Norman, OKS/N LJ-1428N37172Driscolls Inc · Watsonville, CAS/N FL-472N372MCPmc Capair LLC · Philadelphia, PABuilt 2022 · S/N FL-1299N373SUTextron Aviation Inc · Wichita, KSS/N FL-1373N3742B22835 Holdings LLC · Wilmington, DEBuilt 2018 · S/N FL-1145N374BHResource Solutions & Logistical Support LLC · Mooresville, NCS/N FL-442N375BCYellowstone Leasing LLC · Pray, MTBuilt 1991 · S/N FL-56N375CPEjs Aviation LLC · Dallas, TXS/N FL-433N375JPAir T-Jam LLC · Uniontown, PABuilt 2003 · S/N BB1833N377JEAcr Advertising LLC · Jasper, INS/N BB-1843N377PUig Transport LLC · Raleigh, NCBuilt 1984 · S/N LJ-1087N377SUTextron Aviation Inc · Wichita, KSS/N FL-1377N378ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-14N378BGDiscovery One LLC · Windsor, COS/N FL-453N379ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-15N379EKAvtrust LLC Trustee · Wilmington, DEBuilt 2001 · S/N BB-1769N379VMShores Kenneth E · Robstown, TXBuilt 1972 · S/N LW-27N37SUTextron Aviation Inc · Wichita, KSS/N FM-137N37TDTwin Disc Inc · Racine, WIBuilt 1990 · S/N FL-25N3805EHollow Creek Investments LLC · Germantown, TNBuilt 1981 · S/N LJ-943N3809CRepublic Refrigeration Inc · Monroe, NCBuilt 1981 · S/N LA-112N380ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-26N380JPPaalmc Llv · Shreveport, LAS/N BB-1889N380KMTfg Holdings LLC · Greenville, SCBuilt 2001 · S/N FL321N3818C18 Charlie LLC · Southern Pines, NCBuilt 1976 · S/N LW-196N381ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-35N381HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1952N381SUTextron Aviation Inc · Wichita, KSS/N FL-1380N38280Aerotrust Services Corp Trustee · Wilmington, DES/N LJ-953N382ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-36N383AAAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-13N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747N383ATAirtrex Aircraft Juliet Inc · Wichita, KSS/N FE-10N384ATAirtrex Aircraft Kilo Inc · Wichita, KSS/N FE-23N385ATAirtrex Aircraft Lima Inc · Wichita, KSBuilt 1989 · S/N FE-22N385EMEmerald Aviation Inc · Manassas, VABuilt 1980 · S/N LJ923N385HCs Aviation LLC · Lewes, DEBuilt 2008 · S/N FL610N386ATAirtrex Aircraft Mike Inc · Wichita, KSS/N FL-416N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775N386MNTextron Aviation Inc · Wichita, KSS/N FL-1386N387ASMurfin Inc · Wichita, KSS/N LJ-1417
Back to AD 98-15-13