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.

N102CTLy Minh Van · Santa Barbara, CABuilt 2006 · S/N 05-12-05 N102MGJahnke Robin C · Sartell, MNBuilt 2006 · S/N 06-07-03 N104SWJbinl LLC · Intl Falls, MNBuilt 2007 · S/N 07-06-09 N106CTSkyward LLC · Papillion, NES/N 04-12-06 N107WWMile-High Enterprises LLC · Wilmington, DEBuilt 2005 · S/N 05-07-01 N108EMYahnke Wayne Daniel · Livermore, CAS/N 06-08-07 N109CTJones Joseph Jr · Bixby, OKBuilt 2005 · S/N 04-12-05 N121LFGibson James L · Allegan, MIBuilt 2007 · S/N 07-06-22 N122JVBishop Andre · Greenback, TNBuilt 2004 · S/N 04-11-06 N127CTHassler Randy D · Salina, KSBuilt 2006 · S/N 06-09-06 N129PJCounts Thomas D · Marmaduke, ARBuilt 2006 · S/N 06-10-24 N131CTDocko David L · Northwood, NHBuilt 2006 · S/N 06-09-07 N134CTEl Ese LLC · Jacksonville, FLBuilt 2006 · S/N 06-09-10 N135CTTabb William Howard · Eagle, IDBuilt 2006 · S/N 06-02-09 N136CTStall Speed Ranch & Equip LLC · Lampasas, TXS/N 07-08-11 N137CTPatterson David B · Oak Point, TXBuilt 2006 · S/N 06-11-06 N139CTGrandinetti Robert L · Fayetteville, NYBuilt 2006 · S/N 06-07-02 N141BVVrabel Robert A · Sarasota, FLBuilt 2006 · S/N 06-11-24 N142STMacgregor Jeremy · Tracy, CAS/N 05-03-02 N143CTBritt Christopher Marc · Lucedale, MSBuilt 2006 · S/N 06-11-08 N145CTHadden Benjamin D · Incline Village, NVBuilt 2006 · S/N 06-12-08 N146CTTwac LLC · Lakeville, MNBuilt 2006 · S/N 06-12-09 N147CTBoyd Jeffrey A · Whittaker, MIS/N 06-12-10 N148CTResetarits Matthew · West Seneca, NYBuilt 2006 · S/N 06-11-13 N149CTWolin Jason D · Tomball, TXBuilt 2005 · S/N 05-09-11 N153SWWhite Falcon LLC · The Villages, FLBuilt 2007 · S/N 07-06-10 N154CTHileman David J · Carson City, NVBuilt 2007 · S/N 07-01-04 N156CTSullivan John A · Santa Paula, CABuilt 2007 · S/N 07-04-11 N159CTAmple Aviation LLC · Peoria, AZS/N 06-03-06 N15GSThurman James Tremayne · Mansfield, TXBuilt 2006 · S/N 06-07-01 N15ZMWide Open LLC · San Francisco, CABuilt 2004 · S/N 04-12-01 N165CTDutiful Son LLC · Sheridan, WYBuilt 2006 · S/N 06-03-09 N167GMNielsen Hollera T · Uvalda, GABuilt 2007 · S/N 07-03-16 N169CTLemaster Michael · Vancleave, MSBuilt 2006 · S/N 06-10-25 N178SWAmple Aviation LLC · Peoria, AZS/N 07-06-11 N188QRoberson Douglas · Halifax, NCBuilt 2006 · S/N 06-09-19 N199CTAirtime Aviation Inc · Tulsa, OKBuilt 2007 · S/N 07-05-01 N200BLFtb Aviation LLC · Arden, NCBuilt 2007 · S/N 07-06-13 N207WFFerson Wayne E Trustee · Hermosa Beach, CABuilt 2007 · S/N 07-02-08 N208CTKent Investments LLC · Roseburg, ORBuilt 2007 · S/N 07-04-12 N217PWSingleton Stacy · Brookfield, MOBuilt 2006 · S/N 06-03-05 N218DBJohnson George R · Jonesborough, TNBuilt 2006 · S/N 06-07-13 N221CTStamper Jeff · Hanford, CABuilt 2006 · S/N 06-04-13 N223CTLoeven Michael R · Lancaster, PABuilt 2006 · S/N 06-05-01 N224TSMcneill Daniel · Shelton, WABuilt 2005 · S/N 05-11-08 N226CTZeitler Richard W · Inverness, FLBuilt 2006 · S/N 06-01-07 N228CTMckinley James · Spring Hill, KSBuilt 2006 · S/N 06-12-14 N229CTTexas Starwares Inc · Grand Prairie, TXBuilt 2007 · S/N 07-03-06 N233LDSanderson Jeffery P · Centennial, COBuilt 2007 · S/N 07-01-10 N238CTMatthias Romane W · Cresco, IABuilt 2005 · S/N 05-06-01

Back to Flight Design CTSW