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.

N77266Gates Eric C · Menomonie, WIS/N 11394 N77281Hiemstra Thomas R · Sonora, CAS/N 11723 N77282Gallman Alexander C · Livingston, TXBuilt 1946 · S/N 11724 N77291Borden David M · Los Angeles, CABuilt 1946 · S/N 11733 N77297Cullman Daniel H · Kent, WABuilt 1946 · S/N 11739 N77298Shooting Star Services LLC · Rosamond, CABuilt 1946 · S/N 11740 N77312Van Lehn Sethany A · Frederick, MDBuilt 1946 · S/N 11754 N77315Kostroski Larry J · Tucson, AZBuilt 1946 · S/N 11757 N77325Ellis Sean J · Eagle River, AKS/N 11767 N77328Juenke David Parker · Fort Bragg, CAS/N 11770 N77333Mortenson Dennis L · Spanaway, WABuilt 1946 · S/N 11775 N77335Zambelli Robert G · Manning, SCBuilt 1946 · S/N 11777 N77351Nelson Stephen A · Milaca, MNBuilt 1946 · S/N 11792 N77352Heyrman Larry L · New Franken, WIBuilt 1946 · S/N 11793 N77356Ogletree William H · Saint Helena, CABuilt 1946 · S/N 11797 N77360Beech O Sphere LLC · Casper, WYS/N 11801 N77363Jazz Air LLC · Melbourne, FLBuilt 1946 · S/N 11804 N77368Goehringer Zachary · Cameron, TXBuilt 1946 · S/N 11809 N77376Thayer Stephen · Bloomington, MNS/N 11817 N77382Leavitt Jack A · Cathlamet, WAS/N 11823 N77388International Air Services Inc Trustee · Carson City, NVS/N 11829 N77389Acker Richard L · Coleman, MIBuilt 1946 · S/N 11830 N77396Galindo Don Ronald Jr · Walnut Grove, CABuilt 1946 · S/N 11837 N77402Severns Robert L · Eugene, ORBuilt 1946 · S/N 11843 N77403Roland Kenneth R · Tell City, INBuilt 1946 · S/N 11844 N77412Baluch Matthew J · Medina, OHBuilt 1946 · S/N 11853 N77415Swartz Jerome D · Olympia, WABuilt 1946 · S/N 11856 N77419Darr James S · Boron, CABuilt 1946 · S/N 11860 N77420Drever Richard J · Canton, PABuilt 1946 · S/N 11861 N77424Delta Ridge Farms LLC · Oak Grove, LAS/N 11865 N77428Schoff Wardell R · Hamilton, MOS/N 11869 N77441Dale James H · La Vernia, TXBuilt 1946 · S/N 11883 N77446Grady Keith L · Phoenix, AZBuilt 1946 · S/N 11889 N77447Kuharske Jeffrey H · Groveland, FLBuilt 1946 · S/N 11890 N77453Mabry Dale C · San Antonio, TXBuilt 1946 · S/N 11897 N77454Granger William B · Lake City, MIBuilt 1946 · S/N 11898 N77457Sprandel Paul A · Kendallville, INBuilt 1946 · S/N 11901 N77463Lohmeyer Wayne D · Katy, TXBuilt 1946 · S/N 11907 N77464Gustafson Bruce L · Eugene, ORBuilt 1946 · S/N 11908 N77466Quatro Queso Dos Fritos LLC · Buena Park, CABuilt 1946 · S/N 11910 N77468Nulsen Gillian E · Greenbrier, ARBuilt 1946 · S/N 11912 N77469Mabry Monte D · Anchorage, AKBuilt 1947 · S/N 11913 N77473Johnson James R · Etna, CABuilt 1946 · S/N 11917 N77474Bolin Michael A · Spokane, WABuilt 1946 · S/N 11918 N77475Freeland David D · Leawood, KSBuilt 1946 · S/N 11919 N77480White John D · Eagle River, AKBuilt 1946 · S/N 11924 N77486Rankin Paul D · Hudson, WIBuilt 1946 · S/N 11930 N77488Thomas Michael R · Marshall, MOFirst renewal noticeBuilt 1946 · S/N 11932 N77493Weeks James E · Georgetown, TXBuilt 1946 · S/N 11937 N77494Brisi Co · Wilmington, DEBuilt 1946 · S/N 11938

Back to Cessna 120