Skip to content

Flight Design CTSW

Registered aircraft · 181

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

N242CTAmple Aviation LLC · Peoria, AZS/N 06-06-01 N243CTSchindeldecker Jennifer L · Bloomington, MNBuilt 2007 · S/N 07-02-01 N245CTMarietta Robert W · Ocala, FLBuilt 2007 · S/N 07-02-07 N248CTMccandless William H · Hillsboro, ORBuilt 2006 · S/N 06-12-15 N249CTSixstones Ventures LLC · San Antonio, TXBuilt 2006 · S/N 06-11-14 N252GTRose Kerry D · Liberal, MOBuilt 2004 · S/N 04-11-08 N253CTSalty Aviation LLC · Sacramento, CABuilt 2007 · S/N 07-02-03 N253VMay Francis A Jr · Eatonton, GABuilt 2006 · S/N 06-07-04 N254CTAahg Flight LLC · Mesa, AZBuilt 2007 · S/N 07-01-05 N255CTBowden Donald C · Sand Springs, OKBuilt 2006 · S/N 06-08-03 N259CTBockelmann Thomas R · Bristol, INBuilt 2007 · S/N 07-03-07 N259SWMcevoy Peter R · Spokane, WABuilt 2006 · S/N 06-07-05 N260CTPoston Monty Jay · Grand Island, FLBuilt 2007 · S/N 07-02-06 N278CTHorn John D · Independence, ORFirst renewal noticeBuilt 2007 · S/N 07-01-11 N291CTChiang Mark · Chandler, AZBuilt 2006 · S/N 06-07-07 N292CTAmple Aviation LLC · Peoria, AZBuilt 2006 · S/N 06-07-08 N293CTMach/10 Air Team LLC · The Villages, FLBuilt 2006 · S/N 06-08-08 N295CTCalafiore Paul · Perry, FLS/N 06-09-08 N296CTMurphey Kenneth A · Powhatan, VABuilt 2006 · S/N 06-09-09 N297CTDmbranco Inc · San Diego, CABuilt 2006 · S/N 06-10-09 N298ABHankins Shannon G · Tulsa, OKBuilt 2005 · S/N 05-09-10 N298CTFoster Robert L Jr · Chandler, OKS/N 06-10-10 N299CTMiller Glenn E · Orlando, FLBuilt 2006 · S/N 06-11-11 N302BBBoucher Brian · Port Orange, FLBuilt 2005 · S/N 05-10-05 N306CTThuren Don · Bend, ORBuilt 2007 · S/N 07-04-13 N309CTKreswell David · Eunice, LABuilt 2007 · S/N 07-01-07 N319CTMeade James N · Tiffin, IABuilt 2007 · S/N 07-01-08 N324CTCotton Gary S · Longview, WABuilt 2006 · S/N 06-11-09 N334CTAngel LLC · Missoula, MTBuilt 2006 · S/N 06-07-17 N357CTHigh Wing LLC · Toquerville, UTS/N 06-11-23 N357JDRosier Randal R · Meridian, IDBuilt 2007 · S/N 07-02-09 N358CTFly Cloudniner LLC · Livermore, CABuilt 2007 · S/N 07-01-06 N359CTKaas Michael R · Leclaire, IABuilt 2007 · S/N 07-03-08 N371CTMcafee Aviation LLC · Springfield, MOBuilt 2006 · S/N 06-05-11 N372CTRhoten Daniel S · Crawfordsville, INBuilt 2005 · S/N 05-10-06 N373CTBragg Kenneth E · Gilson, ILBuilt 2005 · S/N 05-12-01 N374CTYoull David C · Jenks, OKBuilt 2005 · S/N 05-12-02 N375CTAllegheny Air LLC · East Boothbay, MEBuilt 2005 · S/N 05-12-03 N376CTKnettel Todd P · Jordan, MNS/N 06-01-10 N377CTBrame James M · Crofton, KYBuilt 2006 · S/N 06-01-11 N379CTRobertson Jim · Paragould, ARBuilt 2006 · S/N 06-02-11 N380CTJohnson Steven R · Salina, OKBuilt 2006 · S/N 06-06-18 N381CTShaffer Thomas · Georgetown, TXS/N 06-06-19 N382CTSteinmetz Mark · Overland Park, KSBuilt 2006 · S/N 07-01-01 N386JKStewart James D · Grass Valley, CABuilt 2006 · S/N 06-12-23 N389CTTrackey Jasen P · Leesburg, FLS/N 07-06-07 N38BCRegistered aircraftBuilt 2006 · S/N 06-06-08 N402ELCurtis Victor · Mansfield, PABuilt 2004 · S/N 04-12-07 N409WAndrews Gene R · Bonners Ferry, IDBuilt 2006 · S/N 06-07-06 N40HATichenor John E · Kingman, AZBuilt 2006 · S/N 06-09-20

Back to Flight Design CTSW