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.

N305ZAZulu Air LLC · Opa Locka, FLBuilt 1996 · S/N LJ-1439N3066WFortis Aircraft Leasing LLC · Reno, NVBuilt 1998 · S/N LJ-1536N307TLHedloc Aviation LLC · Midland, TXBuilt 2019 · S/N FL-1179N3080FGreyhawk Aviation LLC · Ketchum, IDBuilt 1999 · S/N FL-249N308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N LJ-1478N308MDGem City Properties LLC · Laramie, WYBuilt 1990 · S/N LJ1246N308RMN308rm LLC · Boca Raton, FLBuilt 1974 · S/N LJ628N30FEBpnr LLC · Lubbock, TXBuilt 1988 · S/N FA-148N30GTCal Asset Holding LLC · Fresno, CABuilt 1980 · S/N LA-37N30HVCustom Fabricating & Repair Inc · Marshfield, WIBuilt 1989 · S/N FA-173N30KCSkillman Management LLC · Wellington, FLBuilt 1977 · S/N LW-241N30MCMadden Contracting Company LLC · Sibley, LABuilt 2022 · S/N FL-1298N30MHLyle Machinery Co · Richland, MSBuilt 2006 · S/N FL-493N30MYTwin State Aviation LLC · Davenport, IABuilt 2016 · S/N FL1062N30PJHighland Paving Co LLC · Eastover, NCBuilt 1999 · S/N LJ-1579N30SMState Of Mississippi · Pearl, MSS/N FL-99N310TXRiddles Group Inc · Rapid City, SDBuilt 1988 · S/N FA-140N311GCRte Enterprises Inc · Canoga Park, CABuilt 1980 · S/N LA-55N311MJVacuum Industrial Pollution International Inc · Baton Rouge, LABuilt 1991 · S/N FL-51N312DEBest Aircraft Deals LLC · Salt Lake City, UTS/N FA-49N312MBN312mb LLC · Wilmington, DEBuilt 1981 · S/N BE-113N312RLNyati Worldwide LLC · Sinton, TXBuilt 1997 · S/N FL-164N312VFCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-299N313AWUS Government · Washington, DCS/N FL-391N313DWDurair Inc · Key West, FLBuilt 1996 · S/N LJ-1434N313HAValiair Lc Trustee · Casper, WYBuilt 1993 · S/N FL-96N313SAMccarty David M · Baker City, ORBuilt 1984 · S/N FA-5N314AWUS Government · Washington, DCBuilt 2004 · S/N FL-387N314LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N LJ1544N314MRMiller Aviation LLC DBA · Huntington, INBuilt 1976 · S/N LW-184N315AWUS Government · Washington, DCBuilt 1992 · S/N FL-91N315KAGopher Air LLC · New Richmond, WIBuilt 2012 · S/N FL-823N315RPPro Serve Aviation LLC · Englewood, COBuilt 1997 · S/N LJ-1503N315SPSegale Properties LLC · Tukwila, WABuilt 2018 · S/N FL-1160N316MDH&D Bluesky LLC · Kalispell, MTBuilt 1985 · S/N LJ-1104N316PWAl Force 1 LLC · North Salt Lake, UTBuilt 1991 · S/N FM2N316RSTriple Rainbow LLC · Princeton, INBuilt 1987 · S/N FA 139N317FPMarbella Blue LLC · Austin, TXBuilt 2022 · S/N FL-1295N318CBBrown Flight Properties LLC · Midland, TXBuilt 2000 · S/N BB-1730N318ELExpress Leasing LLC · Richmond, VABuilt 2008 · S/N FL582N319EEReveille Aviation LLC · Kurten, TXBuilt 2004 · S/N FL-401N319MBAircraft Holding Solutions LLC Trustee · Newark, DES/N LJ-1126N31FMKing Air Adventure LLC · Wilmington, DEBuilt 1981 · S/N BB-869N31WPSale Reported · Gaylord, MISale reported, pending cancellationBuilt 1974 · S/N LW-99N31XXTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N FL-31N3216KSouth River Services LLC · Myrtle Beach, SCS/N LJ-1392N321DZNardi Greg · Missoula, MTBuilt 1968 · S/N LJ-367N321FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1979 · S/N BC-70N321PDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1980 · S/N GR-10N321TRVertivue LLC · Allentown, PAS/N LA-48
Back to AD 98-15-13