Skip to content

Continental 0-200-A

Registered aircraft · 96

Aircraft with this engine 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 engine_model_code IN ('17191')
  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 engine_model_code IN ('17191')
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.

N101AHOlah Michael J · Mazomanie, WIBuilt 1984 · S/N 216 N1049KGonzalez Ramiro · Lancaster, OHBuilt 1971 · S/N LH-3 N104SKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 15071907 N106WL3jc LLC · Phoenix, AZBuilt 2006 · S/N 601-014S N117JMMiddleton Jon T Trustee · Dayton, NVBuilt 2017 · S/N BHLSA 08-016/017-100 N118DGLeason Dianna · Simi Valley, CABuilt 2008 · S/N 001 N120CADodson Patrick W · Creswell, ORBuilt 2007 · S/N 1012-2007 N122DQOliver Taylor R · Topeka, KSBuilt 1981 · S/N 589-12 N137ECWessel Henry J · Lexington, SCBuilt 2007 · S/N 1016-2007 N13JXHanselman Ronald L Jr · Cresson, TXBuilt 2005 · S/N AL-1008 N148CKOtto David · Saint Thomas, MOBuilt 2010 · S/N 75-7497 N14HBMike Rinker Aircraft LLC · Union City, TNBuilt 2009 · S/N 004PM N14KVKaitis Keye V · Joliet, ILBuilt 2021 · S/N 006 N150CGRomano Brian P · Terryville, CTBuilt 1967 · S/N 15066615 N150RDMiller Robert C · Marshallberg, NCBuilt 1975 · S/N 15077548 N157ECJones Joseph B · Newport, NCBuilt 2007 · S/N 1017-2007 N160KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1976 · S/N 15078474 N17257Johnson Ralph R · Roanoke Rapids, NCBuilt 1972 · S/N 15073693 N179DBBrisco Daniel J · Fort Myers, FLS/N 15075498 N18609Underwood Gary · Lewisville, TXBuilt 2006 · S/N EW-1 N18JNNerstrom James S · Green Oaks, ILBuilt 2017 · S/N NC-1 N202SHHoskins Samuel R · Murphysboro, ILS/N 2614 N211TSalazar Frank A · Los Angeles, CABuilt 1975 · S/N 15077046 N23051Gradle Roger Thomas · Fairhope, ALS/N 15068700 N236MSSylvester Michael L · Trussville, ALBuilt 2016 · S/N 1276 N239GSSale Reported · Lake Helen, FLSale reportedS/N 601-011S N2601Bowdler Bruce M · Newport, MIBuilt 2006 · S/N 601-005S N273ACGriffin Connor W · Warren, OHBuilt 2010 · S/N 101 N274ACWelch Thomas R · Modesto, CABuilt 2007 · S/N 1014-2007 N30267Odell John P · Tehachapi, CABuilt 2008 · S/N LA 9 N3141HSheddan Henry W · Live Oak, FLS/N 6081 N3280NAirborne Aircraft Inc · Wilmington, DEBuilt 1946 · S/N 22476 N3418HRegistration Pending · Brady, TXRegistration pendingBuilt 1946 · S/N 4043 N342RJBrowncoat Aviation LLC · Saint Louis, MOBuilt 2006 · S/N 601-008S N353PDOnstott Kimberly L · Burkburnett, TXBuilt 2011 · S/N TX-1003 N3747Thieking Bruce H · Delta, COBuilt 2007 · S/N AL-1107 N380JBBarron Stony J · Spearsville, LABuilt 2021 · S/N L-250 N380RGibbs Clifford E · Saint Clair, MIBuilt 2008 · S/N TM15 N3950HKlein Jerry L · Athens, MIBuilt 1947 · S/N 4651 N39XDHall Thomas D · Monrovia, CABuilt 2012 · S/N 001 N3DHHaig Dennis A · Andover, KSBuilt 1969 · S/N DWH-1 N406CBRegistered aircraftBuilt 2006 · S/N 601-023S N417YBWaddell Richard K · Loveland, COBuilt 2017 · S/N L-116 N424EFGullet Samuel H · Lafayette, LABuilt 2011 · S/N AF-001 N4364ELangley Aaron · Auburn, CABuilt 1948 · S/N 25 N44045Pvb36 Leasing LLC · Roanoke, TXBuilt 1943 · S/N L-5713 N44047Rogers Luke R · Fairbanks, AKBuilt 1946 · S/N 9847 N4414SVanvalkenburg Eric · Hudson, WIBuilt 1946 · S/N 7330 N4744MZenstol LLC · Carmi, ILBuilt 2015 · S/N 75-8874 N479EMatcho Jonathan M · Martinsville, NJBuilt 1995 · S/N 2080

Back to Continental 0-200-A