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.

N333BAMartin Nolan T · Anchorage, AKBuilt 1978 · S/N 7182CN333CSFlanders Leasing LLC · Kouts, INBuilt 2009 · S/N 18108CN336XCowan Lance E · Watonga, OKS/N 6153CN339XPenland Howard W · Amarillo, TXBuilt 1975 · S/N 6151CN343GAN343ga Leasing LLC · Anchorage, AKBuilt 1976 · S/N 7009CN3448QSand Hill Ranch Ltd · Decatur, TXBuilt 2011 · S/N 22030CN344CBKinkle Douglas Charles Trustee · Colusa, CAS/N 10017CN345GWVertical Kinetics LLC · Superior, MTBuilt 2017 · S/N 25117CN345PPHolman Ricardo E · Pleasant Hill, ORBuilt 1991 · S/N 14010CN346Mclendon Kennon A · Fortson, GABuilt 1987 · S/N 10056CN346XSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 6156CN348BPEks LLC · Lenoir City, TNBuilt 2001 · S/N 18077CN348XJones Chris W · Portland, ORS/N 6162CN349XCoplin Christopher S · Anchorage, AKBuilt 1976 · S/N 6161CN351XSpeer Thomas Edward · Farmington, UTS/N 6169CN352XRuach Ministry · Dover, DEBuilt 1976 · S/N 6158CN353LSDavidson Erick M · Piedmont, CABuilt 1999 · S/N 21081CN3550LBatte Bennie Wayne · Forest, MSBuilt 1996 · S/N 23034CN355CBM S T S LLC · Moses Lake, WABuilt 1991 · S/N 4091CN355XTressler Kevin L · Bethel, AKBuilt 1976 · S/N 6179CN358XTubbs Randall E · Newfield, NYBuilt 1976 · S/N 6163CN359FSJohnson Air LLC · Anselmo, NEBuilt 1990 · S/N 4100CN359XDoran James V · Saint John, KSBuilt 1976 · S/N 7002CN35TXBauries Brian W · Abilene, TXBuilt 1994 · S/N 19020CN361FSBlue Yonder Aviation Inc · Rochester, NYBuilt 1997 · S/N 23039CN362CBVictor LLC · Carefree, AZBuilt 1994 · S/N 23001CN362FSFlorida Seaplanes LLC · Altamonte Springs, FLBuilt 1989 · S/N 4071CN363FSMarlu Enterprises Inc · Foristell, MOBuilt 1999 · S/N 23049CN364FSN927nw LLC · Watchung, NJBuilt 2000 · S/N 23065CN365XArmstrong Stefanie M · Anchorage, AKBuilt 1976 · S/N 6173CN366XRomano Stephen Henry Daniel · Seattle, WABuilt 1976 · S/N 7005CN367FSSparks Brian E · Monmouth, ORS/N 23089CN367XBreuer Chad R · Lometa, TXBuilt 1976 · S/N 6165CN369DGHunninghake Brent L · Baileyville, KSS/N 7288CN369KGRegistered aircraftBuilt 1995 · S/N 23008CN371XWalker George R · Mableton, GABuilt 1976 · S/N 6167CN373XAmberger Mark E · Wasilla, AKBuilt 1976 · S/N 6176CN379XCjr Air Service LLC · Saint Louis, MOBuilt 1976 · S/N 7011CN37FBCoffin John Magie · Blue Mounds, WIS/N 10014CN380QThomas George E · Rice, WABuilt 1972 · S/N 2159CN381XMead Lane · Minocqua, WIBuilt 1976 · S/N 7019CN382XAnderson David C · Dilley, TXBuilt 1976 · S/N 7021CN383XSolberg Jon S · Bismarck, NDBuilt 1974 · S/N 6068CN384X1 Zero Sierra Whisky LLC · Helena, MTBuilt 1976 · S/N 7025CN385XJohns Justin C · Dillingham, AKBuilt 1976 · S/N 7016CN386XO'Connor Robert W · San Bernardino, CABuilt 1976 · S/N 7029CN387XDowns Rodney A · Anchor Point, AKBuilt 1976 · S/N 7024CN388XWarner Walt M · Willow, AKBuilt 1976 · S/N 7018CN38BMRiley Christopher C · Chester, CTBuilt 1997 · S/N 18039CN390XNovak Matt E · Port Orchard, WABuilt 1976 · S/N 7028C
Back to AD 98-15-18 R1