Skip to content

AD 2010-17-18 R1

Registered aircraft · 687

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.

N2067EFarm Air Flying Service LLC · Sacramento, CABuilt 2012 · S/N 802A-0440 N20700Meyerkorth Aviation LLC · Rock Port, MOBuilt 2012 · S/N 802A-0486 N20718Cartillar Enterprises Inc · Wynne, ARS/N 802A-0465 N20726A&M Flying Service Inc · Carlisle, ARS/N 802A-0468 N207LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0207 N209LAWest Valley Aviation Inc · Five Points, CABuilt 2011 · S/N 802A-0409 N211CHRegistered aircraftS/N 802A-1278 N212DTThiel Aircare Inc · Chowchilla, CABuilt 2005 · S/N 802A-0212 N212FBAero Spray Inc DBA · Appleton, MNBuilt 2010 · S/N 802A-0368 N214RLLassco LLC · Middletown, DEBuilt 2021 · S/N 802-0896 N224CNRegistered aircraftBuilt 2020 · S/N 802A-0843 N226FBLipan Creek Flying Service LLC · Eola, TXBuilt 2024 · S/N 802A-1157 N22FKFast Ag Air LLC · Watertown, SDBuilt 2022 · S/N 802-0965 N22WHAeronautical Technologies Inc · Clovis, NMBuilt 1997 · S/N 802A0039 N23WTAeronautical Technologies Inc · Clovis, NMBuilt 2014 · S/N 802-0568 N240LATwin Cities Aviation Inc · Yuba City, CABuilt 2010 · S/N 802A-0375 N247SEThiel Air Care Inc · Chowchilla, CABuilt 2012 · S/N 802A-0444 N257CAHorizon Air LLC · Lumpkin, GABuilt 2025 · S/N 802-1185 N265FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 802A-1265 N268FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2026 · S/N 802A-1268 N271LAA+ Aviation Services LLC · Goodland, KSBuilt 2012 · S/N 802A-0471 N272DAAero Spray Inc DBA · Appleton, MNBuilt 2025 · S/N 802-1258 N274BMEvergreen Flying Service Inc · Dover, DEBuilt 2026 · S/N 802A-1274 N276ATBoardman Air Service LLC · Henderson, NEBuilt 2024 · S/N 802A-1110 N278ATBoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802A-0953 N288KWFarm Air Inc · Astoria, ILS/N 802A-1288 N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094 N298LAGregs Crop Care Co Inc · Wilbur, WABuilt 2011 · S/N 802A-0398 N3030LShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2015 · S/N 802A-0602 N3030QFinke Aviation LLC · Charleston, MSBuilt 2013 · S/N 802A-0509 N3033HAkbj LLC · Lewes, DEBuilt 2013 · S/N 802A-0507 N3042SAg Aviation Inc · Muleshoe, TXBuilt 2013 · S/N 802A-0520 N3054WMoes Crop Dusting Service Inc · Marysville, CABuilt 2013 · S/N 802A-0525 N3056QPalmer Flying Service Inc · Manito, ILBuilt 2013 · S/N 802A-0535 N3063GChristmas Flying Service LLC · Shelby, MSBuilt 2013 · S/N 802A-0529 N3063YWeaver Flying Service Inc · Quincy, WABuilt 2013 · S/N 802A-0524 N3066LBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 802A-0549 N30674Jlw Aviation Inc · Carlisle, ARBuilt 2014 · S/N 802A-0557 N30676Michaelis Gary DBA · Goodwin, ARBuilt 2014 · S/N 802A-0573 N3067JHartley Flying Service Inc · Stuttgart, ARBuilt 2014 · S/N 802A-0554 N3069SRoma Air Corp · Belle Glade, FLBuilt 2014 · S/N 802A-0559 N3070EG B Aerial Applications Inc · Slaton, TXBuilt 2014 · S/N 802A-0551 N3070FDakota Air Spray LLC · Huron, SDBuilt 2014 · S/N 802A-0577 N3072YAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0588 N30757Moses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2013 · S/N 802A-0534 N307BRRice Flying LLC · Poplar Bluff, MOBuilt 2017 · S/N 802-0718 N3082PCustom Air Inc · Roe, ARBuilt 2015 · S/N 802A-0600 N3082VMid Missouri Spray Service LLC · Richmond, MOBuilt 2015 · S/N 802A-0620 N3083KBoyds Aviation LLC · Rayville, LABuilt 2015 · S/N 802A-0618 N3083RAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0627

Back to AD 2010-17-18 R1