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.

N62070Wydra Richard J Jr · Mchenry, ILBuilt 1975 · S/N 6092CN620KVRegistration Pending · Anchorage, AKRegistration pendingS/N 10122CN6211MHines Craig Stephen · Boise, IDBuilt 1978 · S/N 7193CN6223MJones Gary M · Chugiak, AKBuilt 1978 · S/N 7205CN6224MJuillerat Alain · Higden, ARBuilt 1978 · S/N 7196CN6225MTurner Christopher H · Eagle River, AKBuilt 1978 · S/N 7200CN6229MBowers Tom W · Terrebonne, ORBuilt 1978 · S/N 7203CN622LHSugarbush Soaring Association Inc · Warren, VTBuilt 2012 · S/N 18109CN6239MCampbell George Trustee · Haines, AKFirst renewal noticeBuilt 1978 · S/N 7204CN6241MNorthern Nomad LLC · Rathdrum, IDBuilt 1978 · S/N 7207CN6248MRoss Michael M Trustee · Anchorage, AKBuilt 1978 · S/N 7201CN6258MBailey Bert T · Big Lake, AKBuilt 1978 · S/N 7212CN6269MSears James W Jr · Kotzebue, AKBuilt 1978 · S/N 7213CN6272MSmith Kevin R · Soldotna, AKBuilt 1978 · S/N 7214CN627GWCotter Robert M · Duluth, MNS/N 23012CN6287PRegistered aircraftN-number assigned, not yet registeredS/N 19018CN629RDWillman Thomas A · Arvada, COS/N 25096CN634DEBobs Rentals Inc · Miller, MOBuilt 1998 · S/N 21043CN640XLanum Corey L · Westford, MAS/N 18041CN642AZHanson Jake Anthony · Loma Rica, CABuilt 1994 · S/N 20021CN6447MSpring Creek Land & Cattle LLC · Lance Creek, WYBuilt 2001 · S/N 25072CN644SLMustang Aerial Services Inc · Reno, OHS/N 7464CN648WBHunt Billy Dean · Rowland, NCS/N 22021CN656CGLarson Paul · Marana, AZBuilt 2008 · S/N 25110CN6589WLangenbach Erik · Yarmouth, MEBuilt 1999 · S/N 25042CN660HBJames Dennis A · Fort Valley, GABuilt 1988 · S/N 10065CN666JAPetair Inc · Wilmington, DEBuilt 1997 · S/N 21023CN669DKBrunner Matthew W · Bellingham, WAS/N 21076CN66EMichaud Michael A · Winslow, MEBuilt 2002 · S/N 25077CN66VJShaffer Scot B · Hilltop Lakes, TXS/N 8077CN672MMitchell John W III · Norman Park, GABuilt 1990 · S/N 7510CN674SRTorres Mark D · Columbia Falls, MTBuilt 1974 · S/N 5008CN674TGStallion Air LLC · Springtown, TXBuilt 1983 · S/N 7426CN678JLHarper Intellectual Properties LLC · Frisco, TXBuilt 1996 · S/N 14041CN696DGFonseca Joseph K · Northlake, TXBuilt 2005 · S/N 18089CN696DYInline Developers LLC · Wilmington, DEBuilt 1997 · S/N 25007CN6JNRinaldi Stephen J · Plymouth, CTBuilt 1970 · S/N 2043CN6VDEllison Jeremy · Dayton, NVBuilt 1981 · S/N A7354CN6YMA-T Rental Properties LLC · Tivoli, TXS/N 25048CN700AWTailwheel LLC · Logan, UTS/N 4032-CN704WFlyboy71 LLC · Kalamazoo, MIS/N 23077CN70LBGrabowski Stephen S · Lower Burrell, PAS/N 10010CN711CXJdbsb LLC · Las Vegas, NVS/N 7342CN711JRBell Kenneth Charles · Wilmington, VTS/N 8064CN7125DWarrior Creek Adventures LLC · Moultrie, GABuilt 1981 · S/N A7360CN714HJNorth Georgia Grading Inc · Jasper, GABuilt 1995 · S/N 18016CN717ERippeto David P · Anchorage, AKBuilt 2001 · S/N 23071CN71MSTaf Aerial Services LLC · Beeville, TXBuilt 1984 · S/N 7452CN7202CKlosterman Aviation LLC · Celina, OHS/N 7202CN722CBM L Dodson Co · Wilmington, DES/N 7171C
Back to AD 98-15-18 R1