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.

N4249DThorpe Foster B · Saint Augustine, FLBuilt 1999 · S/N 21073CN424SVLow Randall Brett · Antlers, OKBuilt 1999 · S/N 18048CN4251HInfrared And Information Services Lc · Stuart, FLS/N 18035CN4251PBennett Richard S · Pearland, TXBuilt 2000 · S/N 25059CN4252SIves David B · Sisters, ORBuilt 2000 · S/N 21078CN4253AWhitaker Eric · Detroit, TXBuilt 2003 · S/N 23074CN4257ARemlap Holdings LLC · Johnson City, TNS/N 25083CN42597Peters Joey L · Alpine, ALS/N 25060CN4259ZFalvey Bryan M Trustee · El Granada, CAS/N 14112CN4268MSimpson John Soren Judson · Chugiak, AKS/N 21069CN4269BNortheast Aviation LLC · Bynum, TXBuilt 2000 · S/N 25047CN42710N42710 LLC · Itta Bena, MSBuilt 2005 · S/N 21088CN4272PHurn Jordan D · Olney, ILBuilt 2000 · S/N 14098CN4274YStapleton Jeff T · Huntington Beach, CABuilt 2000 · S/N 25049CN4278MOwen Mark · Clyde, TXS/N 21077CN4278ZDevoe Ryder Keegan · Encinitas, CABuilt 1999 · S/N 21072CN431XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 6186CN4336SBluebird Aero LLC · Wilmington, DEBuilt 1996 · S/N 14085CN433XSwanson G C · Valentine, NES/N 7046CN435XBorders Nowell · Edinburg, TXBuilt 1976 · S/N 7055CN436AKThompson James A · Ketchikan, AKBuilt 1976 · S/N 7053CN437XCoray Oliver J · Soldotna, AKBuilt 1976 · S/N 7056CN43HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 21051CN444SFMerriman Larry L Jr · Anchorage, AKBuilt 2001 · S/N 25055CN444YTHelseth Craig S · Fort Pierce, FLBuilt 2002 · S/N 25073CN448HWCentral Oregon Aviation Services LLC · Bend, ORBuilt 1997 · S/N 21020CN44KGSpanogle Michael M · Chugiak, AKBuilt 1989 · S/N 4074CN44UGNomadic Aviation LLC · Sheridan, WYBuilt 1991 · S/N 10088CN4550RCarpenter Kevin C · Dallas, TXS/N 2017CN4564BSale Reported · Trapper Creek, AKSale reportedS/N 7436CN4602TPyles Nathan C · Ypsilanti, MIBuilt 1964 · S/N 84N4604TWeitemier Stanley G · Wadena, MNBuilt 1965 · S/N 1017N4607TPbk Aviation LLC · Jefferson, GABuilt 1965 · S/N 1020N4609TLamoureux Nicholas J · Moab, UTBuilt 1965 · S/N 1024N460PHRicter Edward T · Fairbanks, AKBuilt 1988 · S/N 7493CN4612TWeaver Matthew B · Kasilof, AKS/N 1001CN4613TSullivan William R II · Sierra Vista, AZBuilt 1965 · S/N 1028N4614TOdonnell Daniel V · Dover, DEBuilt 1965 · S/N 1022N4617THuttunen Leslie M · Wasilla, AKS/N 1031N4618TWoolston Evan K · Belle Fourche, SDBuilt 1965 · S/N 1029N4619THurlbert Michael L · Wasilla, AKBuilt 1965 · S/N 87N4621TIrby Donald K · Cushing, TXBuilt 1965 · S/N 1033N4623TCorey Glenn M · Wilsonville, ORS/N 91N4624TEisel Adam A · Copenhagen, NYBuilt 1965 · S/N 1026N468Downs Daniel D · Phoenix, AZBuilt 1982 · S/N 7417CN4700TGoulet Jason · Angle Inlet, MNBuilt 1963 · S/N 43N4701TOsborne Richard N · Roscoe, TXBuilt 1963 · S/N 44N4703TByrnes Patrick R · Nampa, IDBuilt 1963 · S/N 46N4706TMaule Susan · Media, PABuilt 1963 · S/N 48N4711TDelaney Spencer R · Fairfield, CABuilt 1963 · S/N 54
Back to AD 98-15-18 R1