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.

N195ALJmds Lift LLC · Helena, MTFirst renewal noticeBuilt 1986 · S/N FA-102N195CAJp Aero LLC · Dayton, OHBuilt 2003 · S/N FL-364N196BDepartment Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-79N196SCChickasaw Transport LLC · Santa Rosa Beach, FLBuilt 1996 · S/N BB-1525N196ZZTj Air Holdings Inc Trustee · Wilmington, DES/N FA-196N197SCCharlie Ninety Alpha LLC · Searcy, ARBuilt 1997 · S/N LJ-1490N198AGAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2015 · S/N FL-1005N198KAThompson Benjamin Kyle · Nevada, TXBuilt 1966 · S/N LJ-162N199BCAirco King LLC · Wichita Falls, TXBuilt 1980 · S/N LA-30N199CGGuardian Flight LLC · Lewisville, TXBuilt 2002 · S/N LJ-1661N199DWAeon62 Holdings LLC · Plano, TXBuilt 1980 · S/N LW-338N199MHGsg Aviation LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB-855N199NDDodson International Parts Inc · Rantoul, KSS/N BP-025N199PLDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-167N199YMicnic King Air LLC · Port Richey, FLBuilt 1991 · S/N FL66N19MCFlying B Holdings LLC · Ozona, TXBuilt 1988 · S/N FA-167N1GFFlowers George D · Panama City, FLBuilt 1982 · S/N LJ1031N1LTWhite River Holdings LLC · Southaven, MSS/N BB-1824N1MARegistered aircraftS/N LA-3N1NPNebraska Public Power District · Columbus, NES/N BB1834N1PTWarner Aviation Properties LLC · Austin, TXBuilt 1987 · S/N FA131N1SCState Of South Carolina · West Columbia, SCBuilt 2018 · S/N FL-1130N1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNBuilt 2001 · S/N BB-1782N1TRTrinity River Authority Of Texas · Arlington, TXBuilt 2013 · S/N FL-876N1UCBas Part Sales LLC · Greeley, COS/N LW-140N1VACommmonwealth Of Virginia · Richmond, VABuilt 2007 · S/N FL-549N1WVState Of West Virginia · Charleston, WVBuilt 2007 · S/N FL-527N2000EBluebird 2000 LLC · Wilmington, DEBuilt 1966 · S/N LJ-172N200ANAirtrex Registration Corp Trustee · Wichita, KSBuilt 1979 · S/N BJ-3N200DAGambill Aviation LLC · Shreveport, LABuilt 1982 · S/N BB-1095N200EARegistered aircraftBuilt 1990 · S/N BB-1368N200FMSapphire Air II LLC · Camp Hill, PABuilt 2002 · S/N BB-1794N200GPWesley Partners II LLC · Mount Vernon, TXBuilt 1994 · S/N BB1496N200GSNavajo Nation · Window Rock, AZFirst renewal noticeS/N BB--1214N200HDCooper Container Corp · Maynardville, TNBuilt 1981 · S/N BB-987N200HKHck Aviation LLC · Jupiter, FLBuilt 2001 · S/N BB-1772N200JREngelman Acres Ltd · Edinburg, TXBuilt 1983 · S/N BB-1123N200NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB-1612N200NWViking Transport LLC · Saint Louis Park, MNBuilt 1999 · S/N BB-1691N200PHPrairie Ventures Aviation LLC · Worthington, MNFirst renewal noticeBuilt 1977 · S/N BB-238N200RELw164 Inc Trustee · Wilmington, DEBuilt 1975 · S/N LW-164N200RMMps Enterprises LLC · North Platte, NEBuilt 1973 · S/N LW-45N200RRTexas Dept Of Criminal Justice · Huntsville, TXBuilt 1987 · S/N BB-1282N200UOhio University · Albany, OHBuilt 1995 · S/N LJ1389N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155N200WBTurbo Air Charter LLC · Boise, IDS/N BB-1754N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393N200XCTvpx Ars Inc Trustee · North Salt Lake, UTS/N BB-1061N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64N202FFBeech Transportation Inc · Eden Prairie, MNBuilt 2001 · S/N BB-1786
Back to AD 98-15-13