Skip to content

Registered aircraft · 100

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

N115RFPeabody Riley A · Minnetonka, MNBuilt 1961 · S/N 17556810 N175NSNovember Sierra Aviation LLC · Oneill, NEBuilt 1960 · S/N 17556945 N175PDD'Artenay Craig A · Coalinga, CABuilt 1960 · S/N 17556839 N175RJSwanson Matthew I · Wasilla, AKBuilt 1960 · S/N 17556901 N175VCCashmere Aviation LLC · Mcalester, OKBuilt 1960 · S/N 17556798 N531JBRegistration Pending · Cape Coral, FLRegistration pendingS/N 17556890 N6905XWoodley Aerial Leasing LLC · Walnut, ILBuilt 1960 · S/N 17556903 N7981TAshmore Rod L · Bonita Springs, FLBuilt 1960 · S/N 56681 N8078TWise James K · Billings, MTBuilt 1960 · S/N 17556778 N8079TSwannack Peter Jay · Lamont, WABuilt 1960 · S/N 17556779 N8080THigh Mesa Aviation LLC · Naturita, COBuilt 1960 · S/N 17556780 N8081TSproul Andrew W · Isabella, OKBuilt 1960 · S/N 17556781 N8082TStrahm Jennifer · Edgerton, KSBuilt 1960 · S/N 17556782 N8084TKnight Doyle D · Loon Lake, WABuilt 1960 · S/N 17556784 N8086TRains David O · El Paso, TXBuilt 1960 · S/N 17556786 N8089TGonzaez Richard · Granbury, TXBuilt 1960 · S/N 17556789 N8092TFlying Colors Airparts Inc · Leesburg, FLBuilt 1961 · S/N 17556792 N8093TScholl Adam J · Garretson, SDBuilt 1960 · S/N 17556793 N8094TMapes Rocky A · Thornton, COS/N 17556794 N8095TCarter Audie L · Port Saint Lucie, FLBuilt 1960 · S/N 17556795 N8096TSchoonover Emma L · Wichita Falls, TXBuilt 1960 · S/N 17556796 N8104TBrewer Lance A · King Salmon, AKBuilt 1960 · S/N 17556804 N8105TButcher Nicholas R · Litchfield Park, AZBuilt 1961 · S/N 56-805 N8108TEarly Robert A · White Oak, TXS/N 17556808 N8109TStoots David A · Fairbanks, AKS/N 17556809 N8111TRoy David J Sr · Summerland Key, FLS/N 17556811 N8115TGuarno Adam C · Jacksonville, FLS/N 17556815 N8116TBliss Kirk R · Maize, KSS/N 17556816 N8119TLarson Larry L · Gackle, NDBuilt 1960 · S/N 17556819 N8120TJordan Francis E · Hillsboro, WIS/N 17556820 N8123TBurns Lawrence S · New Smyrna Beach, FLBuilt 1960 · S/N 17556823 N8124TWanke Michael L · Merrill, WIBuilt 1960 · S/N 17556824 N8125TLinebaugh Ricky L · Dover, PABuilt 1960 · S/N 17556825 N8127TCahalan Robert J · Stroudsburg, PABuilt 1960 · S/N 17556827 N8128TSvoboda Patrick J · Bucyrus, KSBuilt 1960 · S/N 17556828 N8130TMoore Dallas L · Rotonda, FLRegistration revokedBuilt 1960 · S/N 17556830 N8132TSlade Richard · Halifax, PABuilt 1960 · S/N 17556832 N8138TSvoboda Patrick J · Bucyrus, KSBuilt 1960 · S/N 17556838 N8142TRodriguez Pablo · Toa Baja, PRBuilt 1960 · S/N 17556842 N8143TMatheny Larry E · Litchfield, MNBuilt 1960 · S/N 17556843 N8144TShanklin Christopher G · Port Aransas, TXBuilt 1960 · S/N 17556844 N8145TLobitz Walter A · Lake Almanor, CABuilt 1960 · S/N 17556845 N8150TAhs Aero LLC · Phoenix, MIS/N 17556850 N8151TAffordable Flight Time LLC · Eagle River, AKBuilt 1960 · S/N 17556851 N8155TChristen Richard P · Bend, ORS/N 17556855 N8160TWhite Orion H · Moses Lake, WABuilt 1960 · S/N 17556860 N8164TKent Larry A · Gaylord, MIS/N 17556864 N8165TEubanks James D · Horn Lake, MSBuilt 1960 · S/N 17556865 N8166TPakan John S Trustee · Wasilla, AKBuilt 1960 · S/N 17556866 N8167TSouthern Sky LLC · Henderson, NVBuilt 1960 · S/N 17556867

Back to Cessna 175B