OpenAirDocs.org
AD 98-15-18 R1

Registered aircraft · 1,210

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-18-R1')
    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-18-R1')
  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.

N2065UKohler Richard L · Moriarty, NMBuilt 1970 · S/N 2056CN2066UFletcher John G · Diamondhead, MSBuilt 1970 · S/N 2057CN2069UBaucom Thomas A · Midland, NCBuilt 1971 · S/N 2059CN2074UObannon Jack Jr · Houston, TXBuilt 1971 · S/N 2065CN2077UUnertl Ronald W · Waupaca, WIBuilt 1971 · S/N 2070CN207KMWayt Kevin D · Ladera Ranch, CABuilt 1971 · S/N 2062CN210BLGraham Mark Allan · Anchorage, AKBuilt 1975 · S/N 6138CN21VWSeelye Eric D · Petoskey, MIBuilt 1984 · S/N 7460CN220PMFarmer Daniel L · Colorado Springs, COBuilt 1973 · S/N 2175CN221XNapflin Erich P · Wasilla, AKBuilt 1977 · S/N 7139CN222ARBrowne Michael · Big Lake, TXS/N 7010CN2245ZFoder Troy E · Sunnyside, WABuilt 1976 · S/N 6172CN226MCMclendon Mike H · Sulphur Springs, TXBuilt 2002 · S/N 25080CN226TFNormandy Flyers Limited Inc · Middletown, DEBuilt 2000 · S/N 14104CN226TPNormandy Flyers Limited Inc · Middletown, DEBuilt 2006 · S/N 25103CN227YZTurtle Partners II LLC · Providence, RIBuilt 2002 · S/N 25078CN230BRMaule Air Inc · Moultrie, GABuilt 2025 · S/N 23108CN232TKambam LLC · Bangor, MEBuilt 1985 · S/N 10021CN234DGSnyder Patrick M · Cortland, NYBuilt 2000 · S/N 25039CN234PPRichardson Mark B · Bandera, TXS/N 14005CN235Sanitary Environmental Recyclers Corp · Vero Beach, FLBuilt 2000 · S/N 18058CN235AKJain Arun J · Palmer, AKBuilt 1983 · S/N 7448CN235ALStinair LLC · Millville, CABuilt 2000 · S/N 23067CN235BGMcdonald Russell · Rock Island, WAS/N 18002CN235CWGreen Michael L · Midlothian, VAS/N 18009CN235DMDouble W Air LLC · Salt Lake City, UTBuilt 1978 · S/N 7247CN235ESQualitair LLC Trustee · MichelstadtBuilt 2000 · S/N 18046CN235FSOehmke Adam A · Camarillo, CABuilt 1988 · S/N 4052CN235GCMcdonough Joseph · Livingston, MTBuilt 2026 · S/N 24003CN235MPBushhawk LLC · Queen Creek, AZBuilt 1995 · S/N 23017CN235MYPerrin Bear · Glendale, ORS/N 15005CN235PLTree Top Flyers LLC · Cookeville, TNS/N 10039CN235PMMrakovcic Petar Mario · Grosse Pointe Park, MIBuilt 2004 · S/N 25097CN235PRHart Aviation LLC · Emory, TXS/N 25066CN235PWTaylor Bradley P · Paradise, TXBuilt 2002 · S/N 18059CN235RFFinch Robert C · Anchorage, AKBuilt 1984 · S/N 4016CN235RSFlyboy71 LLC · Kalamazoo, MIBuilt 1998 · S/N 23044CN235RTHughes Todd R · Rocky Ford, COBuilt 1999 · S/N 25030CN235TTWild Country Aircraft LLC · Montrose, COBuilt 1996 · S/N 23031CN235XAll Crop 2 Inc · Cornelius, ORBuilt 1987 · S/N 10054CN245LGKnight Air LLC · Anchorage, AKBuilt 1991 · S/N 4096CN246SVN246sv Corp Trustee · Wilmington, DEBuilt 2001 · S/N 25068CN248ABaur York · Leavenworth, WAS/N 21089CN248HRidge Line Aviation LLC · Denver, COBuilt 1975 · S/N 6080CN249MLFlaspohler Edwin L · Ballwin, MOBuilt 1992 · S/N 14049CN249RDJohnson Mark A · Argyle, WIBuilt 2001 · S/N 25069CN24QUKepes Bruce R · South Charleston, OHS/N 8052CN24WHOption Engineering LLC · Anchorage, AKBuilt 1984 · S/N 8031CN251TTTyson David · Lusk, WYBuilt 1997 · S/N 25013CN25ABDalton Jack W · Qulin, MOBuilt 1999 · S/N 21066C
Back to AD 98-15-18 R1