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.

N694TUEdgar Everton M · Grass Valley, CABuilt 2006 · S/N 06-08-04 N715YGarst Charlee Miles · Rock Port, MOBuilt 2006 · S/N 06-07-10 N722JPDobson Eric M · Northampton, MABuilt 2006 · S/N 06-01-12 N728SDusty Sails LLC · Brookings, SDBuilt 2006 · S/N 06-11-19 N72CTWilliamson Frederick · Shelton, WABuilt 2006 · S/N 06-11-10 N755CTFlemington Wayne M · Winchester, CABuilt 2006 · S/N 06-11-18 N7670Spencer Douglas W · Sioux Falls, SDBuilt 2006 · S/N 06-02-05 N7722DMelton John A · Tulsa, OKBuilt 2006 · S/N 06-10-07 N78SRGerr Fredric E · Iowa City, IABuilt 1996 · S/N 06-04-12 N809CTHyde James French · Granbury, TXBuilt 2007 · S/N 07-07-10 N814PPFuller Russell E · Oxnard, CABuilt 2005 · S/N 05-06-04 N819CTWillshire Darryl L · Craig, COBuilt 2007 · S/N 07-07-11 N829CTBellstam Gustaf · Liberty Lake, WABuilt 2007 · S/N 07-07-12 N858CTHashley Gary L · Gering, NEBuilt 2006 · S/N 05-12-08 N865CTWolfe Jeremy · Prescott, AZBuilt 2007 · S/N 07-03-13 N86FTAvery Jordan · Rittman, OHBuilt 2006 · S/N 06-05-14 N880CTN880ct LLC · Riverton, UTBuilt 2007 · S/N 07-06-08 N889CTMonmouth LLC · Providence Forge, VABuilt 2019 · S/N E-19-02-54 N89WDMssjs LLC · Mriott Sltrvl, UTBuilt 2005 · S/N 05-12-06 N906LWLima Whiskey Aviation LLC · Waupaca, WIBuilt 2006 · S/N 06-07-09 N912CTFoxtrot Aero LLC · Libertyville, ILBuilt 2006 · S/N 06-09-05 N915CTDeis Matthew R · Duluth, MNBuilt 2007 · S/N 07-08-19 N920WZMoliterno Steve · San Antonio, TXBuilt 2006 · S/N 06-01-08 N925CTGeyer Curtis K Trustee · Arnolds Park, IABuilt 2007 · S/N 07-08-13 N966BGWilson Harold B · Granbury, TXBuilt 2006 · S/N 06-08-06 N969CTMoonrise Soaring Inc · Wilmington, DEBuilt 2005 · S/N 04-12-08 N988PBMead Jeromie · Anacortes, WABuilt 2005 · S/N 05-03-03 N98CRWilcox Dustin · Palmyra, INBuilt 2006 · S/N 06-05-13 N9922KDixon Thomas F · Boise, IDBuilt 2005 · S/N 05-07-02 N9922ZHarrison Richard E · Belleville, MIBuilt 2006 · S/N 06-08-02 N99EDGavin John P · Driggs, IDBuilt 2006 · S/N 06-04-11

Back to Flight Design CTSW