Skip to content

Registered aircraft · 28

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

N110LSSwenson Leroy D · Le Sueur, MNS/N 1105 N14961Calar David E · Casper, WYBuilt 1975 · S/N P101SE N16470Mid Atlantic Air Museum · Reading, PABuilt 1980 · S/N 001 N164SMMineart Stephen M · Oskaloosa, IABuilt 2007 · S/N 6-5109 N187CDJohnson Charles D · Benson, AZBuilt 2011 · S/N 057 N20FNNeff Floyd F · Monroe, IABuilt 1984 · S/N 1422 N239FCalhoun Wesley R · Gordo, ALBuilt 2011 · S/N 75-7418 N304MDDenton Mike W · Clarksville, VABuilt 2010 · S/N 421 N308MBBoothe Gary A · Hamilton, MTS/N 001 N319WFWilliams Dale P · Moncks Corner, SCBuilt 2012 · S/N 1319 N37979Brown Thomas L · Hartford, WIBuilt 1982 · S/N 61921 N4093ZFord William J · Clearlake, CABuilt 1992 · S/N A1995P N414MVGroah Michael L · Tulare, CABuilt 2012 · S/N 001 N465KTKowalke Todd · Davenport, IABuilt 2010 · S/N 902 N515XPSport Performance Aviation LLC · Green Cove Springs, FLBuilt 2013 · S/N P001 N522DPMarsh Robert · Blairsville, GABuilt 2012 · S/N 6-5522 N557KKomishock Robert · Milnesville, PABuilt 1975 · S/N 557 N601ASims Steven W · Navarre, FLBuilt 2013 · S/N 6-3116 N601LTHoward Richard C · Marysville, MIBuilt 2012 · S/N 6178 N6097Sheehan Michael F · Riverside, CABuilt 1973 · S/N HMR1 N63PZHoyt Patrick W · Cresson, TXBuilt 2012 · S/N 001 N701JNAndrews Paul D · Page, NEBuilt 2011 · S/N 7-7461 N750ZVCochran Jeff D · Ohatchee, ALBuilt 2012 · S/N 75-7811 N7593ZFinkle Thomas M · Lakeland, FLBuilt 2013 · S/N 75-7593 N86EKCompass Builder Services Nf Inc · Green Cove Springs, FLBuilt 2012 · S/N 6061 N880RTBogosh Theodore III · Tamaqua, PABuilt 1979 · S/N 37 N899RKKallenbach Ryan K · Ridgeland, WIBuilt 2013 · S/N 523752011 N93BBallew James W · Collinsville, OKBuilt 1987 · S/N 42

Back to Corvair GO-140