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.

N387ATAirtrex Aircraft November Inc · Wichita, KSS/N FL-449N387SCHeritage Aviation Management Ltd · Conroe, TXBuilt 1999 · S/N FM-10N388KFKiernan Companies LLC · Englewood, COBuilt 1981 · S/N LW-346N389DDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N FL389N389RAAirtrex Aircraft Xray Inc · Wichita, KSBuilt 1986 · S/N BL-56N38APClear Canyon I LLC · Amarillo, TXBuilt 1988 · S/N LJ-1184N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313N390PSMcm Holdings Inc · Lincoln, NES/N LW-279N390SPState Of Arkansas · Little Rock, ARS/N BB-1970N390SRBenchmark 350 LLC · Plano, TXBuilt 2007 · S/N FL-560N391GFEverbank Na · Chicago, ILBuilt 2013 · S/N FL-884N391HCFly-Area LLC · Charleston, SCBuilt 1988 · S/N FA165N392CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 398N392GFEverbank Na · Chicago, ILBuilt 2013 · S/N FL-889N393GFEverbank Na · Chicago, ILBuilt 2014 · S/N FL-913N394ALTeebird Enterprises LLC · Brighton, COFirst renewal noticeBuilt 1968 · S/N LJ394N394GFEverbank Na · Chicago, ILBuilt 2015 · S/N FL-995N395AAAdvanced Air LLC · Hawthorne, CABuilt 1991 · S/N FL39N395ABFr Air LLC · Palm Harbor, FLBuilt 1999 · S/N LJ-1575N395AMHollan Air LLC · Amarillo, TXS/N BB-1101N395AVAdvanced Air LLC · Hawthorne, CAS/N FL-375N395CFCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N FL-395N395GFEverbank Na · Chicago, ILBuilt 2014 · S/N FL-933N395MBAdvanced Air LLC · Hawthorne, CABuilt 2002 · S/N FL-347N395RCHealdsburg Red Car Partners LLC · Pacific Palisades, CABuilt 2007 · S/N FL-559N395TGWhite Crow Air LLC · San Luis Obispo, CABuilt 2014 · S/N FL-910N396FSAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N LJ-1648N396GFEverbank Na · Chicago, ILBuilt 2014 · S/N FL-967N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421N397GFEverbank Na · Chicago, ILBuilt 2015 · S/N FL-989N398GFEverbank Na · Chicago, ILBuilt 2015 · S/N FL-1019N399ALBallard Aviation Inc · Newton, KSS/N BB-1623N399TWArx Air LLC · Windermere, FLBuilt 1983 · S/N LA-203N399WSGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1547N39FBButler National Inc · New Century, KSS/N LJ-1165N39MZTiger Takeoff LLC · Columbia, MOBuilt 2000 · S/N FL-277N3AHEat Veggies 3 LLC · Savannah, GABuilt 1987 · S/N FA-130N3AWArrowhead Burbank Inc · Burbank, OKS/N FL-491N3BAConstruction Enterprises Inc · Franklin, TNBuilt 1997 · S/N FL-181N3DFTaurman Keith L · Virginia Beach, VABuilt 1965 · S/N LJ-36N3GCTexas Air & Space Museum · Amarillo, TXBuilt 1973 · S/N LJ-576N3LSConcept Management Company LLC · Spartanburg, SCBuilt 1977 · S/N LW-245N3MEAero F90 LLC · Oxnard, CABuilt 1980 · S/N LA-101N3MFJ & K Aviation Inc · Conway, ARBuilt 1983 · S/N LA209N3MHN3mh LLC · Kalispell, MTBuilt 1985 · S/N BB-1228N3NCNorth Carolina Dept Transportation · Raleigh, NCBuilt 2007 · S/N BB-1976N3PXAirtime LLC · Mont Belvieu, TXBuilt 1984 · S/N BB-1173N3XBMonument Aviation LLC · North Chesterfield, VABuilt 1967 · S/N LJ-234N400AYVann Air Investments LLC · Williams, CAS/N FL-428
Back to AD 98-15-13