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.

N2030NShampain Noah M · South Beach, ORBuilt 1947 · S/N 12266 N2031VLombard David P · Soquel, CABuilt 1947 · S/N 14244 N2032VTruex Andrew S · Peachtree City, GABuilt 1947 · S/N 14245 N2036VMunoz Pedro L · Ontario, NYS/N 14249 N2037VMarshall Rodney E · Roscoe, ILBuilt 1947 · S/N 14250 N2057VHiggins Derrick G · Arbyrd, MOBuilt 1947 · S/N 14270 N2061VLivgren Douglas Dale · Harvard, NEBuilt 1948 · S/N 14672 N2062VShelton Kim · Holt, FLBuilt 1947 · S/N 14275 N2066VWalker Cindy · Florence, ALBuilt 1947 · S/N 14279 N2076VEverhart Benjamin F Jr · Winston Salem, NCBuilt 1947 · S/N 14310 N2078VMiles John W · Eagle River, WIBuilt 1947 · S/N 14312 N2081VRankin Paul D · Hudson, WIBuilt 1947 · S/N 14314 N2089VCooley Dennis A DBA · Wasilla, AKBuilt 1948 · S/N 14696 N2093VMellott Cole E · Central City, KYBuilt 1947 · S/N 14320 N2097VOverton Robert R · Gun Barrel City, TXBuilt 1947 · S/N 14322 N2103VPenz Racing Co · Braselton, GABuilt 1948 · S/N 14728 N2106VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1948 · S/N 14627 N2110VSnyder Leslie D · Mc Alisterville, PABuilt 1948 · S/N 14718 N2111VJedlicka Sue A · Beatrice, NES/N 14684 N2115VLee John Michael · Van Nuys, CABuilt 1948 · S/N 14340 N2118VFowler Rex · Auburn, ALBuilt 1948 · S/N 14343 N2122VBender Evan D H · Linville, VABuilt 1948 · S/N 14347 N2123VHupe John F · Wamego, KSBuilt 1948 · S/N 14734 N2126VNerstrom James S · Libertyville, ILBuilt 1948 · S/N 14719 N2128VHolmes Dallas Wade · Bend, ORBuilt 1948 · S/N 14353 N2131VKelley Edward T · Iowa Park, TXS/N 14356 N2132VOlson Ethan T · Loves Park, ILS/N 14357 N2136VKegin Kevin M · Salem, ILBuilt 1948 · S/N 14361 N2139VGrant Michael R · Fort Lauderdale, FLBuilt 1948 · S/N 14364 N2209NReady Aim Flyer LLC · New Castle, DEBuilt 1947 · S/N 12445 N2254NPokorski Kenneth R · Bisbee, AZBuilt 1947 · S/N 12490 N2279NBunnell Dale L · Chesterfield, MOBuilt 1947 · S/N 12519 N2295NHickam Steven A · Pinetop, AZBuilt 1947 · S/N 12535 N2324NDicicco Matthew Trustee · Los Gatos, CABuilt 1947 · S/N 12564 N2339NCaldera Efrain · La Mirada, CABuilt 1947 · S/N 12579 N2340NFarewell Eric · Lake Wales, FLS/N 12580 N2359NBehel Bobby O · Tuscumbia, ALS/N 12608 N2374NAutoair Research Inc · Wilmington, DEBuilt 1947 · S/N 12623 N2376NDavis Herbert W · Danville, ARS/N 12625 N2383NEggleston Robert E · Loveland, COBuilt 1947 · S/N 12632 N2389NFrederick Coy B · Mount Erie, ILBuilt 1947 · S/N 12638 N2391NMees Martin B · Eagle River, AKBuilt 1947 · S/N 12640 N2395NCondon Anthony B II · Wichita, KSBuilt 1947 · S/N 12644 N2401NHendrickson Richard A · Kerrick, MNBuilt 1947 · S/N 12650 N2406NNovak Mark S · Dawson, NEBuilt 1947 · S/N 12655 N2410NTipton Jeff K · Anton, TXBuilt 1947 · S/N 12659 N2442NBecker Anthony D · Northfield, MNBuilt 1947 · S/N 12695 N2460NCox Scot A · Delphos, OHBuilt 1947 · S/N 12713 N2462NSimpson Jeffery C · Abbeville, SCBuilt 1947 · S/N 12715 N2469NSeuring Karl E · Kirkland, WAS/N 12722

Back to Cessna 120