Skip to content

Aerotek PITTS S-2A

Registered aircraft · 78

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 ('0110201')
  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 ('0110201')
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.

N104DFHayton Thomas M · Arcadia, OKBuilt 1975 · S/N 2098 N111XRRose Carl William Jr · North Fort Myers, FLBuilt 1979 · S/N 2204 N119JMEverything Pitts LLC · Queen Creek, AZBuilt 1981 · S/N 2251 N11JCWahlin Donald D · Stoughton, WIBuilt 1978 · S/N 2185 N11KACloudbase Inc · Seattle, WABuilt 1974 · S/N 2084 N121GRSimmons Scott J · Palm Springs, CABuilt 1978 · S/N 2159 N13LPVanderhoof Jon A · Omaha, NEBuilt 1974 · S/N 2077 N14CBEverything Pitts LLC · Queen Creek, AZS/N 2001 N161DSHeffron Neuhold Nicholas A · Honolulu, HIBuilt 1977 · S/N 2136 N16JMAlexander Co · Colleyville, TXS/N 2016 N1GESonburst Aviation LLC · Mission Viejo, CABuilt 1972 · S/N 2033 N21CMTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1975 · S/N 2104 N23DGGebhart Daniel T · Hanover, PAS/N 2061 N24JLKisela Andrew J · Tecumseh, MIBuilt 1971 · S/N 2011 N24MCEvans William H · Gardendale, TXBuilt 1974 · S/N 2065 N25CFKeoki Gray DBA · Fernandina Beach, FLBuilt 1978 · S/N 2162 N26MTToman Michael · Painesville, OHBuilt 1974 · S/N 2090 N28BTBi-Plane Training LLC · Saint Louis, MOBuilt 1977 · S/N 2153 N31445Kuther Kenneth J · Nezperce, IDS/N 2176 N31449Peterman Keith A · Taylorsville, KYBuilt 1978 · S/N 2178 N31453Kuhlig Clemens C · Hobe Sound, FLBuilt 1979 · S/N 2189 N31456Flying Time LLC · Jenks, OKBuilt 1979 · S/N 2190 N31465Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1979 · S/N 2198 N31474Nemeroff Jason R · Scappoose, ORBuilt 1979 · S/N 2205 N31475Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 2207 N31482First Flight Aero LLC · Reno, NVBuilt 1980 · S/N 2218 N31519Aerobatics Unlimited · Utica, ILBuilt 1981 · S/N 2250 N31MLFlying Sportsmen Inc · Sussex, NJBuilt 1974 · S/N 2087 N32ZWhite Vernon C · Owasso, OKS/N 2080 N404JBBates John W · Westerly, RIS/N 2074 N414MBPlane Fun Inc Tr Trustee · Snellville, GAS/N 2236 N444MTBill Mcgowan Inc · Covington, LABuilt 1974 · S/N 2079 N44LHWhite Jeffrey W · Macon, GABuilt 1978 · S/N 2168 N45CBBruckman Monty D · Edgewood, NMS/N 2155 N46GPPaulson Gary L · Alexandria, MNBuilt 1974 · S/N 2076 N473SSDevuyst Richard C · Pampa, TXBuilt 1977 · S/N 2150 N47844Koral Arthur · Winchester, CAS/N 2239 N48KAPlane Fun Inc Tr Trustee · Snellville, GAS/N 2242 N49HADoyle Christopher · Waterbury, VTS/N 2193 N505MRVance Thomas E · Riverhead, NYS/N 2021 N511PReigle Aviation South LLC · Orlando, FLBuilt 1973 · S/N 2041 N526DPAllaire Ernest · Groton, CTBuilt 1979 · S/N 2206 N5300VWalters Todd J · Darwin, MNS/N 2262 N53078Proodian Kevin J · Wellington, FLBuilt 1982 · S/N 2270 N57TVPitts Holdings LLC · Jacksonville, FLBuilt 1982 · S/N 2263 N5FVRegistered aircraftBuilt 1981 · S/N 2254 N60LGEgmond Aircraft LLC · Lewes, DEBuilt 1978 · S/N 2169 N669UShartle Austin W · Fredericksburg, PABuilt 1982 · S/N 2265 N6969BBrown Dennis K · Reno, NVBuilt 1978 · S/N 2172 N6EMHall Don L · Lakeland, FLBuilt 1973 · S/N 2055

Back to Aerotek PITTS S-2A