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.

N92247World Class Aviation Ltd · Bellefontaine, OHS/N 14022CN9226NGods Country Aircraft LLC · Trapper Creek, AKBuilt 1992 · S/N 4103CN9227WMasterman Robert David · Chugiak, AKS/N 11097CN9228LRegistered aircraftBuilt 1993 · S/N 14024CN9230TProctor Richard P · Statesboro, GAS/N 11095CN9232GHarold H Bruner · Pinehurst, IDBuilt 1992 · S/N 19001CN9232RRogers Ricky R · Saint Francis, KSS/N 19003CN9232TSannella Joseph J · Missoula, MTS/N 19002CN9234ACruz Salvador A · Sumter, SCS/N 21001CN9234ELdg LLC · Kalispell, MTBuilt 1992 · S/N 14033CN9234NNemnook Airplanes LLC · Seattle, WABuilt 1993 · S/N 4119CN9235TMv Aviation LLC · Byron Center, MIS/N 4126CN92362Yeakley Gary G · Ontario, CABuilt 1993 · S/N 19006CN9236EPorch Brock J · Philip, SDBuilt 1977 · S/N 7142CN9236YSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 19008CN9237ZBugden Michael S · Newnan, GABuilt 1969 · S/N 2028CN9238NBloomberg David C · Northampton, MABuilt 1993 · S/N 19012CN9238RBruce Ronald · Momence, ILBuilt 1993 · S/N 15003CN9243ACollins Carvel Key · Uvalde, TXFirst renewal noticeBuilt 1964 · S/N 71N9247ELeigh William L · Minonk, ILBuilt 1977 · S/N 7145CN9249EThomas Howard M · Hernando, MSBuilt 1977 · S/N 7146CN9254EMoore Thomas R · North Bay, NYS/N 7147CN925ZKlimas David Todd · Mesa, AZBuilt 2006 · S/N 23093CN9266ERomero Bernard Loren · Santa Fe, NMBuilt 1977 · S/N 7151CN9269EHagg Jeffrey D · Maysville, KYS/N 7263CN926TMoore Thomas R · North Bay, NYBuilt 1975 · S/N 6095CN9277EThomason Kenneth L · Council, IDBuilt 1977 · S/N 7154CN9281EShannon Randal · Drexel, MOS/N 7155CN9295EColeman Thomas S · West Forks, MEBuilt 1977 · S/N 7163CN9297EGod'S Country Aviation LLC · Trapper Creek, AKBuilt 1977 · S/N 6203CN92WVSilvey Lloyd R · Hale, MOBuilt 1970 · S/N 2040CN93MLHopman Christopher J · Eagle River, AKBuilt 1993 · S/N 4114-CN94AGSimmons Mark A DBA · Pawcatuck, CTBuilt 1998 · S/N 23052CN94GCCook Gregory L · Carl Junction, MOBuilt 1994 · S/N 20020CN94KWHine Garrett Christopher · Panama City Beach, FLBuilt 1994 · S/N 19026CN94LBWhetzel Russell R · Milford, NJBuilt 1994 · S/N 19029CN951SMBurks Aviation Inc · Hattiesburg, MSBuilt 2004 · S/N 21084CN952SMBarnes Kingsley · Springfield, MOBuilt 2002 · S/N 21074CN955SMCustom Concrete & Building LLC · Pleasantville, TNBuilt 2004 · S/N 21087CN959DBSigma Pharmaceuticals LLC · Monticello, IABuilt 1999 · S/N 14095CN959SMSingle Levi · Lance Creek, WYS/N 21090CN969AWPeeler Jason B · Floresville, TXFirst renewal noticeS/N 25093CN969DMFlying Cracker LLC · Wilmington, DEBuilt 2007 · S/N 14122CN969EZCommand Air LLC · White Salmon, WAS/N 25070CN96MERegistration Pending · Redmond, ORRegistration pendingBuilt 1996 · S/N 14071CN96SLSchulz Matthew E · Belmont, CABuilt 1996 · S/N 22013CN96WDGuilliani Anthony · Lakeside, MTS/N 23028CN973ABWejco Inc · Rising Star, TXBuilt 1996 · S/N 14077CN9752NDearman Larry · Stonyford, CABuilt 1978 · S/N 7241CN977MGHenderson State University · Arkadelphia, ARS/N 21026C
Back to AD 98-15-18 R1