AD 2000-05-23

Registered aircraft · 144

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:2000-05-23')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-05-23')
  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.

N32984Flying Rhino Aviation Ltd · Alliance, NEBuilt 1995 · S/N G10-116N3298NAir Dakota Flite Inc · Hettinger, NDBuilt 1995 · S/N G1-101N3298YNeidert Melvin E · Ulysses, KSBuilt 1995 · S/N G10-118N32995Frenchman Valley Farmers Cooperative Inc · Imperial, NEBuilt 1996 · S/N T45-013DCN3299KJones Aviation Inc · Biggs, CABuilt 1996 · S/N T45-012N3300LAdcock Flying Service LLC · Dustin, OKS/N G1-102N3300UVanderpool Gary · Alamo, TXS/N G6-139N330JWBruces Flying Service Inc · Arlington, GABuilt 1996 · S/N G10-125N331BFMcguire Rob · Saint John, WABuilt 1992 · S/N G6-102N332BFAdcock Flying Service LLC · Wetumka, OKBuilt 1994 · S/N G6-117N339LGKingsley Kiman · Miller, MOBuilt 2011 · S/N T34-347DCN38HAHeritage Ag LLC · Lakeview, MIBuilt 2011 · S/N G10-170N4002UWest Central Ag-Air Inc · Fergus Falls, MNBuilt 1999 · S/N G6-151DCN4025PBob Ruhe Ag Service LLC · Leipsic, OHBuilt 1981 · S/N R1820-018DCN40261Jones Aviation Inc · Biggs, CABuilt 1999 · S/N G10-158N40310Sugair LLC · Corpus Christi, TXBuilt 2004 · S/N T65HG-012N40358Tri-Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N T34-273N40428H And M Flying Service LLC · Osceola, ARBuilt 2005 · S/N T34-274N40475Ed-Air Inc · Oaktown, INBuilt 2005 · S/N T65HG-014N40481Andrews Bruce · Arlington, GABuilt 2005 · S/N T65HG-015GN40699Plane LLC · Grove, OKBuilt 2005 · S/N T65HG-016N4089QBruces Flying Service Inc · Arlington, GABuilt 1999 · S/N G10-163N4090WMauck Flying Service LLC · Hoxie, KSBuilt 2000 · S/N G1-115N41024Headwaters Flying Service LLC · Three Forks, MTBuilt 2006 · S/N T65HG-020GN4109VArnt Aerial Spraying Inc · Worthington, MNBuilt 2000 · S/N G6-154N4182GNeidert Melvin Ed · Ulysses, KSBuilt 2000 · S/N G6-155N4206PHeritage Ag LLC · Lakeview, MIBuilt 2001 · S/N G10-166N4208SOmega Air Service LLC · Fredericksburg, OHBuilt 2001 · S/N G10-167N4217XEarls Spray Service Inc · Breckenridge, MIBuilt 2001 · S/N G10-168N440ATT & M Aircraft LLC · Monticello, ILS/N G10-104N447ATJones Aviation Inc · Biggs, CABuilt 1992 · S/N G6-103N449ATRau Brian C · Medina, NDBuilt 1992 · S/N G6-105N4592TAurora Cooperative Elevator Co · Aurora, NEBuilt 1992 · S/N T45-003DCN5101CThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-502N5102AThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-503N510DKAugustin Don M · Crystal, NDBuilt 1981 · S/N R1820007DCN510GRJohnson Lynn L · Grafton, NDBuilt 1997 · S/N G10-140N510JAWilde Air Service-Huron LLC · Huron, SDS/N G6-125N510LJJohnson Lynn L · Grafton, NDBuilt 1996 · S/N G6-137N510TFederal Aerial Applicators LLC · Wilmington, DES/N T34-311N524SVAaa Aviation LLC · Donalsonville, GABuilt 2015 · S/N T34-438N5297FTri Rotor Spray & Chemical · Ulysses, KSBuilt 2009 · S/N T34-307N5298FBarnett Air LLC · Nezperce, IDBuilt 2009 · S/N T34-313N5298HCrop Dusters LLC · Maurice, IABuilt 2009 · S/N T34-312N529KCAerial Crop Care Co · Hebron, NDBuilt 2012 · S/N G10-173N53016Earles Spray Service Inc · Breckenridge, MIFirst renewal noticeBuilt 2010 · S/N G10-169N5301WTurrell Flying Service Inc · Turrell, ARBuilt 2009 · S/N T34-308N5303VCaprock Spraying Inc · Vega, TXBuilt 2010 · S/N T65HG-026N5306BWorsham Farms Flying Service Inc · Camilla, GABuilt 2010 · S/N T34-332N5308SCrop Dusters LLC · Maurice, IABuilt 2010 · S/N T34-326DC
Back to AD 2000-05-23