Skip to content

Registered aircraft · 30

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('8380310', '8380250')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('8380310', '8380250')
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.

N166CFCarlson Farms Inc · Plentywood, MTBuilt 2018 · S/N H80-215 N3025ZDirrheimer Maximo Hernan · Flora, ILBuilt 2013 · S/N H80-115 N3037RDavidson Richard E · Tchula, MSBuilt 2013 · S/N H80-123 N30454Registered aircraftBuilt 2013 · S/N H80-138 N3045RCentral Ag Air LLC · Marion, KSBuilt 2013 · S/N H80-140 N3062DDewitt Flying LLC · Morven, GABuilt 2012 · S/N H80-114 N318SWSciara Flying Service LLC · Eudora, ARBuilt 2018 · S/N H80-216 N331BKWtpi Services LLC · Blue Mounds, WIBuilt 2015 · S/N H80-177 N476EAMid Continent Aircraft Corp · Hayti, MOBuilt 2016 · S/N H80-190 N509DSJohnson Lynn L · Grafton, NDBuilt 2012 · S/N H80-110 N510HEEd Air Inc · Oaktown, INBuilt 2014 · S/N H80-180DC N510HHJohnson Lynn L · Grafton, NDBuilt 2018 · S/N H80-218 N510KKKingsley Kiman J · Miller, MOBuilt 2015 · S/N H80178DC N511DSDirrheimer Maximo Hernan · Katy, TXBuilt 2015 · S/N H80-176 N5538PAerial Crop Care Co · Hebron, NDBuilt 2017 · S/N H80-197 N609HSCrop Duster Kings LLC · Hutchinson, MNBuilt 2018 · S/N H80-221DC N619LFRcl Farms Leasing LLC · Wilmington, DEBuilt 2019 · S/N H80-230 N6204MDuck Hill Air Service LLC · Grenada, MSBuilt 2014 · S/N H80-145 N6211HLowry Flying Service Inc · Grinnell, IABuilt 2015 · S/N H80-168 N62135Hohl Enterprises LLC · Donnellson, IABuilt 2015 · S/N H80-165 N6214FHaynes Flying Service LLC · Forrest City, ARBuilt 2015 · S/N H80-175DC N6216DHound Dog Enterprises LLC · Terre Haute, INS/N H80-181 N6216KHound Dog Enterprises LLC · Terre Haute, INBuilt 2016 · S/N H80-182 N6216UThrush Aircraft LLC · Albany, GABuilt 2017 · S/N H80-192 N7012QThaggard Aviation LLC · Leesburg, GABuilt 2012 · S/N H80-105 N715GFGeorgia Forestry Commission · Macon, GABuilt 2017 · S/N H80-204DC N716GFGeorgia Forestry Commission · Macon, GABuilt 2017 · S/N H80-211DC N813MCMid Continent Aircraft Corp · Hayti, MOS/N H80-195 N816MTTwo River Airspray LLC · Cavalier, NDBuilt 2017 · S/N H80-188 N85RDDavidson Richard E · Tchula, MSBuilt 2018 · S/N H80-214

Back to Thrush S2R-H80