Skip to content

Registered aircraft · 122

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

N11RSager Timothy P · Tullahoma, TNBuilt 1952 · S/N 7765 N1586DZucchero David M · Stanwood, WABuilt 1952 · S/N 7869 N1950CTupelo Aeronautics Inc · Tupelo, MSBuilt 1954 · S/N 16183 N195APTupelo Aeronautics Inc · Tupelo, MSS/N 16106 N195BAButterfly Aviation Inc · Goodland, KSBuilt 1953 · S/N 16069 N195BSSlatter Lowell J · Buhl, IDBuilt 1953 · S/N 16021 N195BTPerlman Nathaniel H · Kirkland, WABuilt 1955 · S/N 16176 N195BVAir Logistics Group LLC · Winston Salem, NCBuilt 1953 · S/N 16057 N195CCMcguire Michael D · Lake Stevens, WABuilt 1953 · S/N 16093 N195CNNoslen Enterprises · Goodland, KSBuilt 1954 · S/N 16163 N195CW3 Birds Aviation LLC · Galesburg, ILBuilt 1954 · S/N 16174 N195DPPhilyaw David Arthur · Saint James, MOS/N 16149 N195DZKozura Bret T · Wellsville, PABuilt 1953 · S/N 16077 N195GTTrebon Gregory L · Port Orange, FLS/N 16055 N195HJJorgensen Bryan H · Wadsworth, OHBuilt 1952 · S/N 7880 N195JGores Thomas J · Franklin, WIBuilt 1954 · S/N 16123 N195JAR H K Of Kansas Inc · Overland Park, KSBuilt 1950 · S/N 7504 N195JWFroes Jonathan C · Little Elm, TXBuilt 1953 · S/N 16094 N195KPlymate Jeffrey L · Sandy, ORS/N 7867 N195LCWindsock Holdings LLC · Amarillo, TXS/N 16144 N195LWSmiley Neil G · Clover, VABuilt 1954 · S/N 16126 N195MKScholten Calvin B · Lakeland, TNBuilt 1952 · S/N 7907 N195MMCasa Acquistions LLC · Winter Haven, FLS/N 16032 N195MSMccombs Dale A · Midlothian, TXBuilt 1952 · S/N 7994 N195NHewitt Roger L · Kent, WABuilt 1953 · S/N 16075 N195PCBurson Anthony W · Cape Charles, VABuilt 1954 · S/N 16140 N195RAJaeb Gerald E · Yankeetown, FLS/N 16099 N195RCDuke Kay L · Darrouzett, TXBuilt 1953 · S/N 16102 N195RERamey Robert L · Rose Hill, KSBuilt 1952 · S/N 7934 N195SFreedom Leasing Ent Inc · Wilmington, DEBuilt 1952 · S/N 7924 N195SBJones Caleb A · Sanger, TXBuilt 1952 · S/N 7911 N195UDowd Darin R · Frisco, TXBuilt 1951 · S/N 7705 N195WSSaloga William A Trustee · Batavia, ILBuilt 1952 · S/N 7908 N195WTRowe James D · Nome, AKBuilt 1954 · S/N 16128 N1960CSenger Bruce D · Mount Solon, VABuilt 1952 · S/N 7919 N2104CBenger Jeffrey S · Bozeman, MTBuilt 1953 · S/N 16089 N2105CEast Texas Aircraft Engines LLC · Palestine, TXBuilt 1953 · S/N 16090 N2112CRenkel Christopher P · Westlake, OHBuilt 1953 · S/N 16097 N2113CHuton Thomas Wessie · Sanger, TXBuilt 1953 · S/N 16098 N2116CMilton William W · Amsterdam, NYS/N 16101 N2118C140 Ventures LLC · Lewes, DEBuilt 1953 · S/N 16103 N2120CQuilter Charles J II Trustee · Laguna Beach, CABuilt 1953 · S/N 16105 N2122CIrwin Dennis R · San Diego, CABuilt 1953 · S/N 16107 N2123CZeiner Ty R · Marion, KSBuilt 1953 · S/N 16108 N2124CSutliff Larrie G · Briarcliff Manor, NYBuilt 1953 · S/N 16109 N2125CFroes Jonathan · Avondale, AZS/N 16110 N2137CSchmiedt Daniel M · Westminster, SCBuilt 1954 · S/N 16122 N2137DVasenden David A Trustee · Verdi, NVBuilt 1952 · S/N 7905 N2139CWilson Todd B · Newnan, GABuilt 1953 · S/N 16124 N2140CMilton William H · Amsterdam, NYS/N 16125

Back to Cessna 195B