Skip to content

Registered aircraft · 33

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

N13EFMcgough Julie Eileen · Red Oak, TXBuilt 1967 · S/N 337-0794 N243MBSwanson Timothy J · Bannister, MIBuilt 1967 · S/N 337-0813 N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769 N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774 N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786 N2491SGeorge Ladelle L · Ashley, NDBuilt 1967 · S/N 337-0791 N2527SCensair LLC · Santa Fe, NMBuilt 1967 · S/N 337-0827 N254WTClik Services LLC · Forestdale, MABuilt 1968 · S/N 337-0921 N2554SHanan Roy T · Edgewater, FLS/N 337-0854 N2569SMatanane Roke C · Barrigada, GUBuilt 1968 · S/N 337-0869 N2575SDulin Morgan L · Midland, TXBuilt 1968 · S/N 337-0875 N2577SHurt Randall L · Smithville, TNBuilt 1968 · S/N 337-0877 N2587SFlying Tater LLC · Toms River, NJBuilt 1968 · S/N 337-0887 N2604SGillespie Dan L · Discovery Bay, CABuilt 1968 · S/N 337-0904 N2610SGordon Daryl B · Bellevue, WABuilt 1968 · S/N 337-0910 N2612SNixon Edward J · Collierville, TNS/N 337-0912 N2628SSpencer Bennett E · Cleburne, TXBuilt 1968 · S/N 337-0928 N2630SDuquette Stephen R · Fenton, MIBuilt 1968 · S/N 337-0930 N2633SAir Apparent LLC · Santa Rosa, CABuilt 1968 · S/N 337-0933 N2645SVenice Group LLC · Hopkinton, NHS/N 337-0945 N2648SRegistration Pending · Albuquerque, NMRegistration pendingBuilt 1968 · S/N 337-0948 N2657S57 Sierra LLC · Houston, TXBuilt 1968 · S/N 337-0957 N2664SMcclain Daniel S · Enon Valley, PABuilt 1968 · S/N 337-0964 N2666SHageness Hartley · Rugby, NDBuilt 1968 · S/N 337-0966 N2669SWilliams Kent A Jr · Kissimmee, FLBuilt 1968 · S/N 337-0969 N337CBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0905 N337RDDamschroder Rex A · Fremont, OHBuilt 1968 · S/N 337-0847 N37777Quiet Aviation LLC · Longwood, FLS/N 337-0898 N49917Moore Steven D · Los Gatos, CAS/N 337-0784 N610MMMaxq Composites LLC · Oxford, MEBuilt 1968 · S/N 337-0961 N61ABj Aviation LLC · Beaver Meadows, PABuilt 1968 · S/N 337-0886 N712JFN712jf LLC · Laveen, AZBuilt 1968 · S/N 337-0859 N8376GDakota Aircare Inc · Wagner, SDBuilt 1967 · S/N 337-0782

Back to Cessna 337C