Skip to content

AD 2010-17-18 R1

Registered aircraft · 686

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

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:2010-17-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:2010-17-18-R1') ORDER BY n_number

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:2010-17-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:2010-17-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.

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:2010-17-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:2010-17-18-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N41687Over The Top Aviation Inc · Jonesboro, ARBuilt 2008 · S/N 802A-0309 N4170SLowry Flying Service Inc · Grinnell, IAS/N 802A-0278 N417BMMilhon Air Inc · Martinsville, INBuilt 2007 · S/N 802A-0276 N419FFMccreary Flying Service LLC · Clarksdale, MSS/N 802A-0191 N4203WFast Ag Air LLC · Watertown, SDBuilt 2006 · S/N 802A-0253 N4216WTri Air Farms LLC · Mamou, LAS/N 802A-0320 N4219MBombero Aviation LLC · Childress, TXBuilt 2007 · S/N 802A-0264 N4219WEverett Flying Service Inc · Holly Grove, ARS/N 802A-0334 N4219YTri State Aerial LLC · Canton, SDBuilt 2010 · S/N 802A-0352 N4221STri Rotor Spray & Chemical · Ulysses, KSBuilt 2008 · S/N 802A-0305 N422JCChorman Spraying LLC · Milton, DEBuilt 2018 · S/N 802A-0762 N4244FOli Grow LLC · Baskin, LABuilt 2009 · S/N 802A-0316 N4244PPrairie Ag Service LLC · Des Arc, ARS/N 802A-0308 N4247UHiggins Leasing Inc · Woodlands, TXBuilt 2016 · S/N 802-4001 N4265DVisser Ag Inc · Rigby, IDBuilt 2007 · S/N 802A-0259 N426LAC And C Flying Service Inc · Pocahontas, ARBuilt 2012 · S/N 802A-0441 N427NSVisser Ag Inc · Rigby, IDBuilt 2003 · S/N 802A-0153 N428LAFletcher Flying Service Inc · Roe, ARBuilt 2006 · S/N 802A-0228 N445HAAir Tractor Inc · Olney, TXBuilt 2016 · S/N 802-0633 N448LAAir Kraft Spraying Inc · Timber Lake, SDBuilt 2012 · S/N 802A-0448 N455RANorrland Partners LLC · Hillsboro, NDBuilt 2024 · S/N 802-1167 N4567SBoyle Flying Service Inc · Boyle, MSBuilt 2014 · S/N 802A-0571 N457ATAeronautical Technologies Inc · Clovis, NMBuilt 2005 · S/N 802A-0201 N458RANorrland Partners LLC · Hillsboro, NDBuilt 2025 · S/N 802A-1212 N459RASilver Wings Flying Company LLC · Littlerock, WABuilt 2025 · S/N 802A-1243 N469LACounty Line Flying Service Inc · Coy, ARBuilt 2012 · S/N 802A-0469 N471HKSak II LLC · Miller, SDBuilt 2021 · S/N 802A-0883 N473FSShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2012 · S/N 802A-0473 N474HAg Solutions Of West Texas LLC · Roby, TXBuilt 2006 · S/N 802-0252 N474LACat Agri Aviation Inc · Walnut Ridge, ARBuilt 2012 · S/N 802A-0474 N490SFWells Flying Services LLC · Holdrege, NEBuilt 2024 · S/N 802A-1152 N5002WSouther Crop Spraying Inc · Douglas, GABuilt 1997 · S/N 802A-0038 N5008YAir Tractor Inc · Olney, TXS/N 802-4066 N5009PAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802-4058 N50102Air Tractor Inc · Olney, TXS/N 802-4068 N50105Air Tractor Inc · Olney, TXBuilt 2026 · S/N 802-4059 N5011DAir Tractor Inc · Olney, TXS/N 802A-1342 N5011HAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802-4060 N5012GAir Tractor Inc · Olney, TXS/N 802-1349 N5012HEvergreen Flying Service Inc · Dover, DES/N 802A-1291 N5012LAir Tractor Inc · Olney, TXS/N 802-4069 N5012TAir Tractor Inc · Olney, TXS/N 802-4070 N5012XAir Tractor Inc · Olney, TXS/N 802-4061 N5013FAir Tractor Inc · Olney, TXS/N 802-4062 N5013MAir Tractor Inc · Olney, TXS/N 802-4063 N5013VAir Tractor Inc · Olney, TXS/N 802-4064 N5013ZAir Tractor Inc · Olney, TXS/N 802-4065 N5014FAir Tractor Inc · Olney, TXS/N 802-4067 N5014NAir Tractor Inc · Olney, TXS/N 802A-1327 N501JC4l A/C Leasing LLC · Port Saint Lucie, FLBuilt 2013 · S/N 802A-0501

Back to AD 2010-17-18 R1