Skip to content

Registered aircraft · 209

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

N195LGInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 7303 N195LNGrones John G · Port Orange, FLS/N 7824 N195LVHughes David L · Uintah, UTS/N 7813 N195MJLutz Roald F · Sandia Park, NMBuilt 1952 · S/N 7882 N195PDDougherty Paul D Jr · Bethel, PABuilt 1950 · S/N 7460 N195PKKourtis Vintage Aviation LLC · Owasso, OKBuilt 1951 · S/N 7712 N195PLPerkins Terence R · Ormond Beach, FLBuilt 1948 · S/N 7262 N195RKLinnane Cory E · Schaumburg, ILS/N 7393 N195RWWhite Michael D Trustee · Willow Springs, MOFirst renewal noticeBuilt 1948 · S/N 7088 N195SCSmith William E · Highland, CABuilt 1949 · S/N 7402 N195SELewis Leigh Wade · Rockledge, FLS/N 7857 N195SMBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7806 N195TGGoodwin Pilar Z · Lancaster, CABuilt 1949 · S/N 7341 N195TWHenkemeyer Joseph · Cave Creek, AZBuilt 1952 · S/N 7981 N195VOdom John C · Fredericksburg, TXBuilt 1950 · S/N 7471 N195VFMcfarlane Claude L III · Fitchburg, WIBuilt 1948 · S/N 7268 N195VHKoehn Shane · Scooba, MSBuilt 1949 · S/N 7549 N195WGFisher Group LLC · Ashland City, TNBuilt 1952 · S/N 7926 N195WHCarolina Aero Tech LLC · Hilton Head Island, SCS/N 7324 N195YYoung Kenneth D · La Verne, CABuilt 1951 · S/N 7629 N1TBR S Rowe Enterprises Inc Sp · Wilmington, DES/N 7756 N2100CScootair LLC · Alburgh, VTBuilt 1953 · S/N 16085 N2103CAeromobile Inc · Hernando, MSBuilt 1953 · S/N 16088 N2134CQualitair LLC · MichelstatdtBuilt 1955 · S/N 16119 N2142CSteinsvik Magne · Seattle, WABuilt 1953 · S/N 16127 N251ZWatkinds Steven G · Hermiston, ORBuilt 1952 · S/N 7842 N2648Gaddis Donald O · Fredericksburg, OHBuilt 1952 · S/N 7797 N272CGStrickland Luther J Jr · San Luis Obispo, CABuilt 1949 · S/N 7301 N295APTupelo Aeronautics Inc · Tupelo, MSS/N 7836 N3006BMabry Thomas Coleman II · Atlanta, GABuilt 1952 · S/N 7889 N3015BDaniel Thompson G Jr · Greensboro, NCBuilt 1952 · S/N 7898 N3021BChase 13 LLC · Wilmington, DES/N 7904 N3032BHendrix Todd M · Bakersfield, CABuilt 1952 · S/N 7915 N3058BUpper Limit LLC · Big Lake, AKBuilt 1952 · S/N 7941 N3069BRampersad Carlyle · Wilmington, DEBuilt 1952 · S/N 7953 N3085BBrown Daniel A · Gettysburg, PABuilt 1952 · S/N 7970 N3089BSeibert Mark R · Monticello, MNBuilt 1952 · S/N 7974 N33VRegistration Pending · Colfax, ILRegistration pendingBuilt 1948 · S/N 7240 N3401RBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7395 N3435VChieffo Robert · Poughquag, NYBuilt 1948 · S/N 7120 N3442VAdams Richard J · Mesa, AZBuilt 1948 · S/N 7146 N3443VMenard Charles H · Burton, MIBuilt 1948 · S/N 7133 N3450VSchreiner Michael · Dallas, TXFirst renewal noticeBuilt 1948 · S/N 7147 N3457VSchwab Coyle P · St Charles, ILBuilt 1948 · S/N 7154 N3458VEastern Stearman Inc Trustee · Leesburg, VAS/N 7159 N3465VLiebfried Andrew · Lunenburg, MABuilt 1948 · S/N 7162 N3482VBorden Leon D · Arcadia, CAS/N 7182 N3484VWeiss Elliott · Fresno, TXS/N 7184 N3485VMyron Alexander Tedrow · Morristown, TNBuilt 1948 · S/N 7211 N3488VCurrier Susan · Greenvlle Jct, MEBuilt 1948 · S/N 7192

Back to Cessna 195