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.

N8169TPerry Edward Glen Trustee · Ozark, ARBuilt 1960 · S/N 17556869 N8170TThorn Walter W · Guilford, VTS/N 17556870 N8174TMeacham Thomas · Myton, UTBuilt 1960 · S/N 17556874 N8175TMachovsky Randolph P · Montague, MIBuilt 1960 · S/N 17556875 N8177TRegistration Pending · Fairmont, WVRegistration pendingBuilt 1960 · S/N 17556877 N8178TFairbanks Kelly E · Twin Falls, IDBuilt 1960 · S/N 17556878 N8179THill Jason M · Bakersfield, CABuilt 1960 · S/N 17556879 N8181THetge Kenneth R · Viola, ARBuilt 1961 · S/N 17556881 N8183THysell Donovan · Atwater, OHBuilt 1960 · S/N 17556883 N8184TGraham Steven K · Mc Grath, AKBuilt 1960 · S/N 17556884 N8186TBouton Vern H · Fairbanks, AKBuilt 1961 · S/N 17556886 N8187TLawdawg Property Rentals LLC · Williston, NDBuilt 1961 · S/N 17556887 N8191TDavis Jonathan L · Pleasanton, CAFirst renewal noticeBuilt 1960 · S/N 17556891 N8192TFranke Darren W · Yorktown, TXBuilt 1960 · S/N 17556892 N8193TGulick Andrew C · Phoenix, AZS/N 17556893 N8196TPetersen Cam L · Pensacola, FLBuilt 1960 · S/N 17556896 N81BMHollrock Engineering Inc · Hadley, MABuilt 1961 · S/N 17556914 N8204TChampion Anthony R · Troy, MOBuilt 1960 · S/N 17556904 N8207TColorado Aircraft Maintenance Solutions LLC · Denver, COBuilt 1961 · S/N 17556907 N8213TMortenson Jay E · Venice, CABuilt 1960 · S/N 17556913 N8224TBeausoleil Randy L · Livingston, TXS/N 17556924 N8226TDrain Jerald R · Gainesville, FLBuilt 1960 · S/N 17556926 N8227TFulenchek Raymond D · Sherman, TXBuilt 1960 · S/N 17556927 N8229TGreen Bernard L · Greensburg, INS/N 17556929 N8230TJstream Lc · Sheridan, WYBuilt 1960 · S/N 17556930 N8232TDavidson E Bryant Trustee · Owasso, OKBuilt 1960 · S/N 17556932 N8234THughes James G · Smartsville, CABuilt 1960 · S/N 17556934 N8236TRobson Aaron T · Fairview, PABuilt 1960 · S/N 17556936 N8237TLamattino Brandon L · Hanford, CABuilt 1960 · S/N 17556937 N8249TTolmachev Nikolay A · Anchorage, AKBuilt 1960 · S/N 17556949 N8251TSkylark 61 LLC · Fair Oaks, CAS/N 17556951 N8253THolzgrove Daniel R · Detroit Lakes, MNBuilt 1960 · S/N 17556953 N8254TBaxter Christopher D · Trimble, MOBuilt 1960 · S/N 17556954 N8255TVan Hoomissen James · Wasilla, AKBuilt 1960 · S/N 17556955 N8258TStevens Scott D · Corsicana, TXS/N 17556958 N8262TJohnson Durwood D · Beaumont, TXBuilt 1961 · S/N 17556962 N8263THaig Richard J · Lawrence, KSBuilt 1961 · S/N 17556963 N8265TBrooks Charles W · Hesperia, CABuilt 1961 · S/N 17556965 N8266TSrock Charles L K · Alexandria, MNBuilt 1961 · S/N 17556966 N8267TGatewood Keith Alan · Albuquerque, NMS/N 17556967 N8270TMathison John M · Fernley, NVS/N 17556970 N8273TElliott Clay E · Gillette, WYBuilt 1961 · S/N 17556973 N8276TCooper Craig S · Pasco, WABuilt 1961 · S/N 17556976 N8279TGaddis James W · Steelville, MOS/N 17556979 N8280TSwift Raptor Aviation LLC · Herndon, VAS/N 17556980 N8282TLoveless Phillip A · Independence, KSBuilt 1961 · S/N 17556982 N8286TWelch Scott P · Lovell, WYFirst renewal noticeBuilt 1961 · S/N 17556986 N8288TDooley Kenneth J · Charleston, TNBuilt 1961 · S/N 17556988 N8291TKnight James M · Wilton, CABuilt 1961 · S/N 17556991 N8293TNational Refining Co · Owosso, MIBuilt 1962 · S/N 17556993

Back to Cessna 175B