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.

N3110YGoracke Chad · Monroe, ORBuilt 1995 · S/N 20024CN31133Capozzi Robert A · Greenwood, FLBuilt 1994 · S/N 20025CN3113AN Maple LLC · Kalispell, MTBuilt 1994 · S/N 19021CN3113MTompkins Allen C III · Anchorage, AKS/N 23009CN3114CWilkerson Bradley W · Caldwell, IDS/N 20030CN3116QHenderson State University · Arkadelphia, ARS/N 17002CN3117MGoad Jerry A · Oneida, TNS/N 20026CN3117TWalker Sean Michael · Apple Valley, MNBuilt 2006 · S/N 21091CN3118CChristensen Effie S · Wasilla, AKS/N 20034CN3118KNorth Carolina Wildlife Resources Commission · Raleigh, NCS/N 14060CN311ECLinton Andrew M · Black Mountain, NCBuilt 1974 · S/N 5026CN31200N7775mw LLC · Sand Lake, MIBuilt 1995 · S/N 20036CN31228Hauser Dean · Stratford, TXBuilt 1993 · S/N 21002CN3134WDans Flying Service Inc · Crookston, MNS/N 19027CN31370Kolbaba David C · Carpentersville, ILS/N 19033CN31495Such Jason A · Richland, WAS/N 20032CN314XRoss Peter W Trustee · Lufkin, TXBuilt 1975 · S/N 6134CN3155BCountry Development LLC · Lebanon, ORBuilt 1995 · S/N 18026CN3162QClevenger Matthew T · Williamsburg, VABuilt 1995 · S/N 19038CN3171HKh Air LLC · New London, MNBuilt 2018 · S/N 22045CN3176UWilburn Michael R · Wagoner, OKS/N 19039CN3179ULawson John A · Lott, TXBuilt 1995 · S/N 20028CN317XBogner Matthew L · Santa Cruz, CABuilt 1975 · S/N 6127CN3180GEdwards Thomas E · Brighton, COS/N 25002CN31865Hartwig Flying Service LLC · Eagle River, WIBuilt 1995 · S/N 17003CN31868Yarger Dylan C · Anchorage, AKBuilt 1995 · S/N 19040CN31875Glovatsky Milton · Williston, NDBuilt 1995 · S/N 22008CN31876Winn Derek H · Joseph, ORS/N 20045CN3187AWainright James Allen · New Bern, NCS/N 21011CN3187HDike Randall K · Owensville, INBuilt 1995 · S/N 23018CN3187SWinberg Tanner · Dorchester, NES/N 14070CN3187ZRucks Chad W · Okeechobee, FLBuilt 1996 · S/N 18022CN318XTriple F Flying Inc · Benton, PABuilt 1975 · S/N 6145CN319ECRansom Robert W · Moorestown, NJBuilt 1994 · S/N 19032CN319ZBrown Cameron C · Litchfield, CTBuilt 2007 · S/N 18099CN31KMMeine William F · Denver, COBuilt 1983 · S/N 7437CN31PEPhantom Eagle LLC · Hot Springs, VABuilt 1996 · S/N 14086CN321TLBurson Robert L · Gresham, ORBuilt 2000 · S/N 25046CN322ASHenning Kurt D · Auke Bay, AKBuilt 2000 · S/N 18049CN323JPWyatt Equipment Inc · Basin, WYS/N 20015CN323XLedgerwood Chris · Anchorage, AKBuilt 1975 · S/N 6131CN3241XLane Richard · Thomasville, GABuilt 2006 · S/N 18095CN324BAHart John Michael · Olalla, WABuilt 1969 · S/N 2035CN3251ABrews LLC · Homer, AKBuilt 2007 · S/N 23100CN32550Minto Daniel Warren · Wake Forest, NCBuilt 2018 · S/N 14136CN32566Mob Aviation USA LLC · Auburndale, FLS/N 14137CN326ARBowen David R · Brandon, MSBuilt 2006 · S/N 20064CN327PFMo-Col Medical Services Inc · Kirksville, MOBuilt 1998 · S/N 21038CN32CXSkowbo Rock · Jacksonville, FLBuilt 1976 · S/N 7034CN32DLLarson David W · Palmer, AKBuilt 1966 · S/N 1009C
Back to AD 98-15-18 R1