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.

N6122XGranberry Philip G · Anchorage, AKBuilt 1988 · S/N 7486CN6124QLewis Chip M · Eau Claire, WIS/N 10073CN6126MBishop Aeronautics LLC · Helena, MTBuilt 1977 · S/N 7161CN6127MOhman Victor N · Glenrock, WYBuilt 1977 · S/N 7162CN6128PTango Alpha Sierra LLC · Berthoud, COS/N 4057CN61294Mau Andrew R · Kenmare, NDS/N 4083CN6129CSumner Scott B · Catoosa, OKBuilt 1988 · S/N 11057CN6129TTaf Aerial Services LLC · Beeville, TXBuilt 1988 · S/N 4053CN6130XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1989 · S/N 7497CN61330Holman Ricardo Earl · Creswell, ORBuilt 1989 · S/N 11065CN61339Wraith David Benjamin Lee · Wasilla, AKS/N 20013CN6133AReinders Monte M · Port Townsend, WABuilt 1990 · S/N 14001CN61375Lowell William D · Caldwell, IDBuilt 1989 · S/N 7515CN61385Grady Will M · Gallatin, MOBuilt 1992 · S/N 4107CN61399Coody Jefferson · Burkburnett, TXS/N 4082CN6139AN6139a Corp Trustee · Wilmington, DEBuilt 1990 · S/N 10079CN6140BSawtooth Aviation Inc · Wilmington, DES/N 7508CN6144MBargabos Richard O · Peterboro, NYBuilt 1978 · S/N 7169CN6147MSix One North LLC · Anchorage, AKBuilt 1978 · S/N 7185CN6154MPeeler John · Cottonwood Heights, UTBuilt 1978 · S/N 7177CN615SDHolland Andrew K · Sterling, AKS/N 2083CN6160MHaverstock Richard T · Monterey, CABuilt 1978 · S/N 7166CN6166MBradley Aero Services Inc · Southwick, MABuilt 1978 · S/N 7178CN616ESDiamond Larry Michael · Galax, VABuilt 1999 · S/N 21067CN6170MRothe Zachary W · Riverside, CABuilt 1978 · S/N 7179CN6198MPapa Bear Adventures Inc · Bethel, AKBuilt 2024 · S/N 7190CN62002Bieniek Joseph D · Fergus Falls, MNS/N 5040CN62003Valpey R Wesley Jr · Medford, MEBuilt 1974 · S/N 6056CN62007Meche Russell P · Rayne, LABuilt 1974 · S/N 5041CN62013Andersen Steve · Albert Lea, MNBuilt 1974 · S/N 5042CN62015Bender Evan D H · Linville, VABuilt 1974 · S/N 6059CN62017Bond Kelly J · Wasilla, AKS/N 5045CN6201MJordan Stephen · Bend, ORBuilt 1978 · S/N 7198CN62020Chardon Stephen A · Franconia, NHBuilt 1974 · S/N 5047CN62021Biotech Travel LLC · Pima, AZBuilt 1974 · S/N 5050CN62026Opsal Eric J · Williston, NDBuilt 1974 · S/N 5052CN62027Burkart John L · Angwin, CABuilt 1974 · S/N 5053CN62033Mccain Robert E · Wasilla, AKBuilt 1974 · S/N 5048CN62034Williams Robert W · Anchorage, AKBuilt 1974 · S/N 6067CN62037Martin Terence R · Newport, ORBuilt 1975 · S/N 6071CN62039Schuerman William R · Arlington, WABuilt 1975 · S/N 6072CN62040Comm William · Mulino, ORBuilt 1975 · S/N 6073CN62043Hardy John R · Wasilla, AKBuilt 1975 · S/N 6074CN62044Pentz Geoff M · Port Ludlow, WABuilt 1975 · S/N 6081CN62045Lewis John R · Juneau, AKBuilt 1975 · S/N 6078CN62051Anderson John · El Paso, TXBuilt 1975 · S/N 6087CN62062Atlas Air LLC · Salt Lake City, UTBuilt 1975 · S/N 6101CN62063Harrison Kelcey A · Galena, AKS/N 6088CN62066Whitfield Timothy D · Fairfield, NCBuilt 1975 · S/N 6076CN62067Cole Matthew M · San Jose, CAS/N 6089C
Back to AD 98-15-18 R1