Skip to content

Registered aircraft · 18

Aircraft with this engine 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 engine_model_code IN ('34201')
  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 engine_model_code IN ('34201')
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.

N101TTGowdy Green LLC · Bunnell, FLBuilt 1985 · S/N 4132016 N108SHChang Worx LLC · Cantonment, FLBuilt 1983 · S/N 3932011 N111RJJet & Rotor Aviation LLC · Sacramento, CABuilt 1991 · S/N 5132023 N202MEGraves Robert E · Nashville, INS/N 5232002 N2183XMuhle Bradford Kurt · Columbus, NEBuilt 1973 · S/N 2951230 N3210GHill Megan · Spring Hill, KSBuilt 1975 · S/N 3151207 N325CWMontez Santiago S · Mesa, AZBuilt 1972 · S/N 2751269 N393GLSollinger John E · Springfield, OHBuilt 1982 · S/N 3832022 N443LMRegistered aircraftBuilt 1979 · S/N 3151214 N5111Garoutte Kirk E · Anchorage, AKBuilt 1974 · S/N 74200 N60972Gramlick Carl S · Cameron Park, CABuilt 1973 · S/N 2951278 N61CJBerry Patrick L · Fernandina Beach, FLBuilt 1964 · S/N 1032019 N622CDRegistered aircraftBuilt 1977 · S/N 2032030 N793KHHoogestraat Kyle D · Saylorsburg, PABuilt 1990 · S/N 4932001 N806FYFlying Elite Inc · Wilmington, DEBuilt 1966 · S/N 153202 N87CJWayman Ian A · Peyton, COBuilt 1987 · S/N 4432016 N988CJVandusen Thomas W · Clark Fork, IDBuilt 1988 · S/N 4532017 N98SHBell Joshua Samuel · Monument, COBuilt 1982 · S/N 3832018

Back to Housai HS6A