Skip to content

Registered aircraft · 660

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

N76578Macdonald Thomas L · Laveen, AZBuilt 1946 · S/N 11014 N76630Mosley Jessie W · Heber Springs, ARBuilt 1946 · S/N 11070 N76634Blunk Roger C · Wheatland, IABuilt 1946 · S/N 11074 N76654Pidgeon James E · Millington, TNS/N 11094 N76682Horn Norman R · Las Vegas, NVBuilt 1946 · S/N 10262 N76685Sisskin Enid · Gulf Breeze, FLFirst renewal noticeS/N 10814 N76706Franklin Special School District · Franklin, TNS/N 11138 N76710Soehner Harold D · Winslow, AZBuilt 1946 · S/N 11142 N76742Bossola Raymond L · Suffolk, VABuilt 1946 · S/N 11174 N76750Towery Daniel T II · Dover, DEBuilt 1946 · S/N 11182 N76754Walker James E · Englewood, COBuilt 1946 · S/N 11186 N76774Molek Jon · Warren, OHS/N 11206 N76778Estby Hans P · Hayfield, MNS/N 11210 N76786Engeman Nathon G · Bend, ORBuilt 1946 · S/N 11218 N76790Liddell Patrick A · Plains, MTBuilt 1946 · S/N 11222 N76798Finnegan John J · North Fort Myers, FLBuilt 1946 · S/N 11230 N76806Groenenboom Andrew J · Oskaloosa, IABuilt 1946 · S/N 11238 N76826Ramsey David H · Coosada, ALBuilt 1946 · S/N 11258 N76834Snider Eric L · Monroeville, INS/N 11266 N76838Mcmillen Joseph F · Dyersburg, TNBuilt 1946 · S/N 11270 N76844Passwater Michael E · Upland, CAS/N 11278 N76848Lott Dennis Paul II · Clinton, MSBuilt 1946 · S/N 11282 N76868Sanders Brittany M · Bakersfield, CAS/N 11302 N76924Donald Ben B · Carthage, TXBuilt 1946 · S/N 11366 N76932Lowe David M · Sacramento, KYBuilt 1946 · S/N 11374 N76944Fachko Michael J Jr · Grand Island, NYBuilt 1946 · S/N 11386 N76948Martin Gerard A · Boston, KYBuilt 1946 · S/N 11390 N76952Kling Ronald L · Kimberling City, MOBuilt 1946 · S/N 11398 N76980Acme Aircraft Leasing Mt LLC · Kalispell, MTBuilt 1946 · S/N 11426 N77008Hooker Robert E · Hamer, SCBuilt 1946 · S/N 11454 N77016Zucchero David M Jr · Stanwood, WABuilt 1946 · S/N 11462 N77028Smith Jimmy A Jr · Albemarle, NCBuilt 1946 · S/N 11474 N77032Registered aircraftS/N 11478 N77048Chapman Gary · Milton, WVBuilt 1946 · S/N 11502 N77116Wetherby Anna Rebecca · Wendell, MABuilt 1946 · S/N 11574 N77132Stamsta Marc J · Hartland, WIS/N 11590 N77140Bettendorf Elizabeth J · Salem, ORBuilt 1946 · S/N 11598 N77148Bruffy Matt · Boerne, TXBuilt 1946 · S/N 11610 N77176Clay Jeremy N · Dublin, TXBuilt 1954 · S/N 11638 N77196Mccann Michael · Springfield, ORBuilt 1946 · S/N 11658 N77212Hinson Stanley J Trustee · Grapevine, TXBuilt 1946 · S/N 11674 N77220Registration Pending · Howell, MIRegistration pendingBuilt 1946 · S/N 11682 N77224Baas Casey G · Oakland, FLBuilt 1946 · S/N 11686 N77230Fraser Steven · Sparks, NVBuilt 1946 · S/N 11692 N77234Vance Donn D · Monterey, TNBuilt 1946 · S/N 11696 N77239Corr Zachary R · Santa Paula, CABuilt 1946 · S/N 11701 N77244Debons Jeremy A · Lexington Park, MDBuilt 1946 · S/N 11706 N77248Stolley Nicholas A · Webster, MNBuilt 1946 · S/N 11710 N77254Pace T Kem · Ridgeway, VABuilt 1946 · S/N 11716 N77257Mix Timothy R · Hubbard, ORBuilt 1946 · S/N 11719

Back to Cessna 120