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.

N412LCLuck Floyd E · Broken Arrow, OKBuilt 2005 · S/N 05-09-12 N424WDDewald Duane S · Mckinney, TXBuilt 2006 · S/N 06-09-11 N427CTKite Hill Dreams LLC · Walnut Creek, CABuilt 2007 · S/N 07-03-10 N44BZKoenig Steven Fillmore · San Diego, CABuilt 2007 · S/N 07-09-26 N456WTLavergne Lowell M · East Wenatchee, WABuilt 2006 · S/N 06-10-11 N459CTSeuffert Chase · Peoria, AZBuilt 2007 · S/N 07-08-12 N460CTPearson Jayson E · Neosho Rapids, KSBuilt 2005 · S/N 05-07-06 N463CTLynch John M Jr · Nottingham, PABuilt 2007 · S/N 07-02-10 N466CTP&K Aircraft Management LLC · Cape Coral, FLBuilt 2007 · S/N 07-02-12 N467CTBennett Benjamin L · Reston, VABuilt 2007 · S/N 07-04-14 N468CTStarfall Aviators LLC · Cameron Park, CABuilt 2007 · S/N 07-04-15 N469CTWard Ronald C · Suffolk, VABuilt 2007 · S/N 07-04-16 N499CTBertram Forest System LLC · Appleton, WIBuilt 2007 · S/N 07-03-09 N504CTResetarits Matthew · West Seneca, NYBuilt 2007 · S/N 07-03-12 N509CTWalker Donald Andrew · Athens, GABuilt 2007 · S/N 07-06-14 N520DWWitham Darrell J · Croswell, MIBuilt 2006 · S/N 06-07-14 N524BWShannon Mark D · Sacramento, CABuilt 2007 · S/N 07-03-11 N525ABBrown Joshua · Greenwood, INBuilt 2006 · S/N 06-10-04 N530CTLeague Christopher M · Madison, ALBuilt 2006 · S/N 06-11-12 N531CTSale Reported · Steele, NDSale reportedBuilt 2006 · S/N 06-12-11 N532CTStill Flying LLC · Fort Collins, COBuilt 2006 · S/N 06-12-12 N533CTJcombs Enterprises LLC · Corinth, TXBuilt 2007 · S/N 07-03-15 N534CTYoung Michael W · Rogers, ARBuilt 2006 · S/N 07-03-17 N536CTRobinson Kent E · Charlotte, NCBuilt 2007 · S/N 07-05-02 N537CTWilliams Gene P · Edinburg, TXS/N 07-05-03 N538CTSebring Aviation Of Highlands County Inc · Sebring, FLBuilt 2007 · S/N 07-05-29 N539CTSycamore Hill Farms Inc · Laurinburg, NCS/N 07-06-01 N541CTDuncan John S · Maple, NCBuilt 2007 · S/N 07-09-22 N542CTFischer Bob P · Dalton, GABuilt 2007 · S/N 07-09-23 N542LLMiller Roland Joseph · Corning, CABuilt 2006 · S/N 06-12-13 N543CTMac Gilvray Roger P · Lake Placid, FLBuilt 2007 · S/N 07-09-24 N543DLDehart Lance M · Lafayette, LAS/N 06-10-13 N547AWFoster William A · Kirksville, MOBuilt 2006 · S/N 06-10-08 N559CTFehr Esther · Garden City, KSBuilt 2007 · S/N 07-05-07 N55LSMoorhead Robert V · Artesia, NMBuilt 2006 · S/N 06-03-10 N569CTMorgan Michael W · Kaplan, LABuilt 2007 · S/N 07-05-08 N579CTHunt Kevin W · Winnie, TXBuilt 2007 · S/N 07-05-09 N5875Kennedy Robert F · Santa Rosa, CAS/N 06-08-05 N591CTFlightdreams LLC · Washington, UTS/N 06-03-11 N603CTBug Smashers LLC · Winfield, KSBuilt 2005 · S/N 05-06-03 N60VTFont Ulrico J · Venice, FLBuilt 2006 · S/N 06-05-15 N621CTTipton Herbert J · Theodore, ALBuilt 2006 · S/N 06-06-07 N646MAKen Graham Phd Inc · Sioux Falls, SDBuilt 2005 · S/N 05-11-07 N650CREagles Wings USA Ltd · Wilmington, DEBuilt 2007 · S/N 07-06-12 N651CBKemmann Frieder · Beaufort, SCBuilt 2005 · S/N 05-04-07 N6543Duerloo Robert J · Salmon, IDBuilt 2005 · S/N 05-07-15 N663CTWienert John · Charlotte, NCBuilt 2006 · S/N 06-06-03 N664CTEchavez Andreas A · St George, UTBuilt 2007 · S/N 07-08-18 N66SHMiller Terry Patrick · Eureka Springs, ARBuilt 2006 · S/N 05-12-07 N674CHEngelbrecht David J · Orlando, FLBuilt 2006 · S/N 06-03-07

Back to Flight Design CTSW