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.

N2864NFerguson Ernest E · Portland, ORS/N 13125 N2870NOlson Carl I · North Pole, AKBuilt 1947 · S/N 13131 N2874NPreston Philip L · Tucson, AZBuilt 1947 · S/N 13135 N2882NWhite 120 LLC · Galesburg, KSS/N 13143 N2886NRose Jeffrey C · Carmichael, CAS/N 13147 N2890NDruskins Christina M · Hartford, WIBuilt 1947 · S/N 13151 N2896NPfeiffer Michael D · Greenfield, INBuilt 1947 · S/N 13157 N2898NBaxter Gail L Jr · Rock Hill, SCBuilt 1947 · S/N 13159 N2900NLogsdon Dale L · Alva, OKBuilt 1947 · S/N 13161 N2904NEvolution Aircraft Inc · Zephyrhills, FLBuilt 1947 · S/N 13165 N2906NSchulte Steven P · Rocklin, CABuilt 1947 · S/N 13167 N2908NFodie Kerry J · Aurora, ORBuilt 1947 · S/N 13169 N2924NRhoades William P · Northfield, MNBuilt 1947 · S/N 13185 N2926NMitchell John P · Sandia, TXBuilt 2001 · S/N 13187 N2930NDuenas Carlos · Hurricane, UTBuilt 1947 · S/N 13191 N2932NEsmiol Matthew · Durham, NHBuilt 1947 · S/N 13193 N2938NChesnut John W · Arlington, TXBuilt 1947 · S/N 13199 N2955NTatman Robin R · Vallejo, CABuilt 1947 · S/N 13213 N2965NAllen Scott A · Bend, ORBuilt 1947 · S/N 13223 N2966NSegerstrom Erik M · Sonora, CABuilt 1947 · S/N 13224 N2968NDream Waco LLC · Oklahoma City, OKBuilt 1947 · S/N 13226 N2982NNewman Richard D · South Beach, ORBuilt 1947 · S/N 13240 N2983NCmr Aviation LLC · Perry, UTBuilt 1947 · S/N 13241 N2985NMcvay Myron A · Auburndale, FLBuilt 1947 · S/N 13243 N2LJHouton Fred L · Dublin, GABuilt 1947 · S/N 12151 N3008NForthofer Richard · King Salmon, AKBuilt 1947 · S/N 13266 N3017NJohnson Kyle J · Albert City, IABuilt 1947 · S/N 13275 N3019NPatterson Sherwood H · Girard, OHBuilt 1957 · S/N 13277 N3029NSalzer Brayden V · Ashley, NDS/N 13287 N3031NTurnage Brody G · Brock, TXS/N 13289 N3034NWoodward Jeremiah · Manton, MIBuilt 1947 · S/N 13292 N3036NDill Tharold J III · Fort Valley, GAS/N 13294 N3040NJenison Timothy P · Shavano Park, TXBuilt 1947 · S/N 13298 N3067NAlvarez Carlos A · Murphy, NCBuilt 1947 · S/N 13325 N3074NOsborne Kirk J · Rockford, ILBuilt 1947 · S/N 13332 N3080NArmor Toby B · Bradenton, FLBuilt 1947 · S/N 13338 N3082NDayton Stephen Glen · Oceano, CAS/N 13340 N3085NGivens Benjamin Todd · Ruffin, SCBuilt 1947 · S/N 13343 N3091NWesterinen John P · Mass City, MIBuilt 1947 · S/N 13349 N3102NParker Steve E · Wasilla, AKBuilt 1947 · S/N 13360 N3104NWard David C · Mcpherson, KSS/N 13362 N3112NMoore Jarrel D · Waelder, TXBuilt 1947 · S/N 13370 N3114NClassic Aviation Inc · Pella, IABuilt 1947 · S/N 13372 N3120NDahlke Philip H · Smyrna, GABuilt 1947 · S/N 13378 N3128NSale Reported · Kalispell, MTSale reportedBuilt 1947 · S/N 13386 N3130NMatthews Dennis B · Cameron, NCS/N 13388 N3132NBaer Nicholas · Marshall, VABuilt 1947 · S/N 13390 N3141NSale Reported · Lone Jack, MOSale reportedBuilt 1947 · S/N 13399 N3151NWayman Richard · Crystal, MNBuilt 1947 · S/N 13409 N3157NRich Melody L Trustee · Port Hueneme, CABuilt 1947 · S/N 13415

Back to Cessna 120