Skip to content

Aircraft Mfg & Development CH601XL SLSA

Registered aircraft · 22

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

N106WL3jc LLC · Phoenix, AZBuilt 2006 · S/N 601-014S N130AWMitchell Brent U · Shakopee, MNBuilt 2007 · S/N 601-045S N131AWStanger Charles P · Yacolt, WABuilt 2007 · S/N 601-047S N132AWLove Charles V · Ethridge, TNBuilt 2008 · S/N 601-049S N154BTDoser Lawrence · Macomb, MIBuilt 2007 · S/N 601-050S N207WCCapistran Wayne A · Crookston, MNBuilt 2007 · S/N 601-044S N329JGHernandez Jesus · Mchenry, ILBuilt 2006 · S/N 601-025S N343SSShippee William S · Lake City, FLBuilt 2006 · S/N 601-002S N39DNDavis Steven C · Bishop, CABuilt 2007 · S/N 601-031S N406CBRegistered aircraftBuilt 2006 · S/N 601-023S N454BBDurden Patrick G · Neshkoro, WIBuilt 2008 · S/N 601-054S N45FBHopkins Gregory J · Rome, GABuilt 2007 · S/N 601-032S N601ESAquino Wayne L · Lake Havasu City, AZBuilt 2007 · S/N 601-043S N601NMBarlow Steven J · Mansfield, OHBuilt 2006 · S/N 601-006S N602WHShoemaker Gar · Cochranville, PABuilt 2006 · S/N 601-024S N653AMMcguire Timothy L · Tehachapi, CAS/N 601-034S N7812PCowherd And Cowherd LLC · Union Point, GABuilt 2006 · S/N 601-027S N849XLChurch Niley M · Wichita Falls, TXBuilt 2006 · S/N 601-022S N915WDRose Vicki · Beaverdam, VABuilt 2006 · S/N 601-003S N921VCole William H · Garner, NCBuilt 2008 · S/N 601-052S N928WBJones Douglas · Willard, UTS/N 601-038S N9743VBlevins Carl L · Mc Kenzie, TNBuilt 2007 · S/N 601-030S

Back to Aircraft Mfg & Development CH601XL SLSA