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.

N26RFVuc Inc · Allentown, PABuilt 2010 · S/N FL-722N2702SMdm Air LLC · Belpre, OHBuilt 2013 · S/N FL-831N270MNardi Greg P · Missoula, MTBuilt 1967 · S/N LJ-288N274KARgv Sky LLC · Harlingen, TXBuilt 1978 · S/N LW-274N275LARts Ventures LLC · San Antonio, TXBuilt 1992 · S/N LJ1275N275LLN275ll LLC · Wilmington, DEBuilt 2007 · S/N FL-566N276EBMountain Air Aviation LLC · Jonesville, VABuilt 2001 · S/N FL-335N276JBChris Allen Aviation LLC · Naples, FLBuilt 1998 · S/N FL-219N277FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N FL-1148N277GERltwf LLC · Fiddletown, CABuilt 1990 · S/N BB-1389N277GLDiamondback Equipment Leasing LLC · Avondale, AZBuilt 1991 · S/N BB-1406N277JEAir LLC · Jasper, INBuilt 2015 · S/N FL-986N277JJHjjv LLC · Walterboro, SCBuilt 1982 · S/N BB-1043N277SPAll Systems Satellite Distributors Of Delaware LLC · Newark, DEBuilt 1980 · S/N LA-77N278KWAir Rgv LLC · Mcallen, TXBuilt 2022 · S/N FL-1307N278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N LJ-1011N27BNTravelaire Service Inc · Wilmington, DES/N BB-1268N27RCCoastal Holding LLC · Holland, MIBuilt 1983 · S/N BB-1134N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740N280WDWak Aviations LLC · Green Bay, WIBuilt 2017 · S/N FL-1104N282AMRfp Enterprises Inc · Bridge City, TXBuilt 1997 · S/N BB-1571N282DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N LW-209N283JDDurham Aircraft LLC · Port Aransas, TXBuilt 1991 · S/N FL-69N284MRDale Aviation Inc · Rapid City, SDBuilt 2005 · S/N LJ-1729N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734N285RRio Bank · Mcallen, TXBuilt 2016 · S/N FL-1059N285RBButler National Inc · New Century, KSBuilt 1999 · S/N FL-264N287ATN399bw LLC · California, MDBuilt 2006 · S/N FL-430N288ATN38ry LLC · California, MDBuilt 1987 · S/N FA134N288KMGarmin International Inc · Olathe, KSBuilt 1995 · S/N BB-1508N289ATN999mg LLC · California, MDBuilt 1991 · S/N FL-65N28BDSouthern Illinois Helicopters LLC · Marion, ILBuilt 1997 · S/N FL-175N28ELDodson International Parts Inc · Rantoul, KSS/N FA-144N28KAJames John · Bennett, COBuilt 2003 · S/N FL-377N28KMN28km LLC · Wilmington, NCBuilt 1983 · S/N BB-1159N28KPState Of Montana · Helena, MTBuilt 1979 · S/N LJ-845N28VRPajaro 195 LLC · Fort Worth, TXBuilt 1996 · S/N BB-1540N28WCMoorad Sports Partners LLC · Newport Beach, CABuilt 2017 · S/N FL-1097N290CCMonument Aviation LLC · North Chesterfield, VABuilt 1966 · S/N LJ132N290KAir Ems Inc · Tulsa, OKBuilt 1980 · S/N LW-337N290KAN290ka LLC · Clare, MIBuilt 1974 · S/N LW59N290NCMr Boo Properties LLC · Indianapolis, INBuilt 1987 · S/N LJ1158N290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N LJ-519N291ASLasai Aviation LLC · Reston, VABuilt 2001 · S/N FL-332N291CCMobile Ehr Inc · Argyle, TXBuilt 1977 · S/N LJ-728N291DFRmb Leasing Inc · Dover, DEBuilt 1998 · S/N LJ-1534N292APlacebo Air LLC · Ridgecrest, CABuilt 1966 · S/N LJ-99N292TGCrown Aviation LLC · Lawrence, KSBuilt 2011 · S/N FL-743N294TTUncommon Solutions LLC · Hollis, NHBuilt 1984 · S/N LJ1098N295DCHibiscus26 Inc Trustee · Wilmington, DEBuilt 2000 · S/N BB-1709
Back to AD 98-15-13