Skip to content

Porterfield CP-65

Registered aircraft · 19

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

N25453Yates Cecil R · Westminster, CABuilt 1940 · S/N 651 N25499Slinger LLC · Randolph, WIBuilt 1940 · S/N 654 N25539Koblenzer F Matt · Key Largo, FLS/N 660 N255401940 Porterfield LLC · Santa Paula, CABuilt 1940 · S/N 661 N25542Johnson Daryl E · Garrison, NDBuilt 1940 · S/N 663 N25590Cable Robert A · Upland, CAS/N 696 N27207N27207 LLC · Richland, WAS/N 704 N27217Case Marion · Guthrie, OKS/N 714 N27280Converse Donald A · Los Alamitos, CABuilt 1940 · S/N 761 N32428Cooley David A · Harrod, OHBuilt 1940 · S/N 858 N34726Port Townsend Aero Museum · Port Townsend, WABuilt 1941 · S/N 892 N34814Schiermeister Lloyd G · La Center, WABuilt 1941 · S/N 916 N37703Taxman Arthur M · Port Orange, FLBuilt 1941 · S/N 932 N37708Mann Thomas A · Ford, WAS/N 937 N37709Rhinebeck Aerodrome Museum · Rhinebeck, NYS/N 938 N37714Self Mark A · Athens, GABuilt 1941 · S/N 943 N37716Feauto Kevin J · Saint Cloud, FLS/N 945 N37743Boast Mark R · Richland, WABuilt 1941 · S/N 963 N37862Fisher Lance K · Excelsior, MNBuilt 1941 · S/N 1009

Back to Porterfield CP-65