Skip to content

Flight Design CTLS

Registered aircraft · 142

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

N776CTDeshmukh Rahul A · Brooklyn, NYBuilt 2011 · S/N F-11-02-04 N77GPButterfield George L · Spring Valley, CABuilt 2008 · S/N 08-04-14 N785KBurks Charles III · Jena, LABuilt 2007 · S/N 07-11-16 N787LSBeyer Steven W · Tarrytown, NYS/N 08-01-15 N790CTPowell Ronald T · Bolivar, PABuilt 2014 · S/N F-14-07-13 N792CTSpencer Douglas W · Sioux Falls, SDBuilt 2009 · S/N F-09-01-09 N813LBMerritt Randell L · Wetumpka, ALBuilt 2008 · S/N 08-03-09 N816BDKrodast LLC · Sheridan, WYBuilt 2015 · S/N F-14-06-09 N816WWade Phillip L · Belleville, MIBuilt 2008 · S/N F-08-07-08 N8204BGlazer John Edward · Sierra Vista, AZBuilt 2012 · S/N F-11-10-07 N822AHRt Aviation LLC · Georgetown, SCBuilt 2008 · S/N F-08-07-11 N822SSBresler Andrew · Saint Louis, MOBuilt 2013 · S/N F-12-04-01 N840KNNolde Kevin · Saint Amant, LAS/N 08-04-09 N866RSAirscrew Aviation LLC · Youngstown, OHBuilt 2010 · S/N F-10-06-02 N86LSMorfesy Jim · Tucson, AZS/N 08-03-10 N888MMTroubleshooter Network Inc · Centennial, COBuilt 2011 · S/N F-11-03-05 N890YBN890yb LLC · Kennesaw, GABuilt 2011 · S/N F-11-08-04 N8910YTegels Brent J · Cedar Rapids, IABuilt 2008 · S/N 08-02-03 N909KMPas Theodore M Trustee · West Brookfield, MABuilt 2010 · S/N F-10-10-10 N911QAXavier Ron · South Dartmouth, MAS/N F-13-06-02 N911SHNick The Fly Guy LLC · Burleson, TXBuilt 2016 · S/N F-16-01-50 N919CTTreat Richard · Saint Charles, MOBuilt 2010 · S/N F-08-11-20 N919GURosenaur Hayden · White City, ORBuilt 2010 · S/N F-08-11-21 N920CTAlarcon Rene · Valrico, FLBuilt 2010 · S/N F-10-08-11 N920SSEximious Flying Club Inc · Ferndale, MIS/N F-10-02-05 N921KAdventure Air LLC · Norman, OKBuilt 2010 · S/N F-10-01-01 N924RDLajara-Nanson Walter · Great Falls, MTBuilt 2016 · S/N F-16-01-51 N929CTJohnson Adam Reed · Gilroy, CABuilt 2009 · S/N F-08-07-10 N929WSAdventure Air LLC · Oklahoma City, OKBuilt 2012 · S/N F-12-02-09 N938CTAdventure Air LLC · Norman, OKBuilt 2009 · S/N F-09-08-15 N939CTStockie John R · Max Meadows, VAS/N F-09-08-16 N93VMOswin LLC · Shawnee, OKBuilt 2008 · S/N F-08-06-12 N959CTAdventure Air LLC · Norman, OKBuilt 2009 · S/N F-09-10-14 N960CTMcriley Mark · Broken Arrow, OKBuilt 2010 · S/N F-10-02-07 N962LSGrant Douglas G · Fargo, NDBuilt 2010 · S/N F-10-02-06 N969CDCeddia David M · Burlington, MABuilt 2008 · S/N F-08-05-11 N969CRSea Air And Land LLC · Carson City, NVBuilt 2007 · S/N 080116 N970CTGee Garrett R · Boyle, MSBuilt 2010 · S/N F-10-02-08 N982SAMulcahy Wayne S · Florence, ORBuilt 2008 · S/N 08-02-07 N9929TWalrod Landon Anthony · Norman, OKBuilt 2007 · S/N 07-11-13 N992SAHart Edward T · Makawao, HIS/N 08-02-06 N999CTSnead William B · Round Rock, TXBuilt 2017 · S/N F-16-05-53

Back to Flight Design CTLS