Skip to content

Registered aircraft · 1,605

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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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.

N2715NSaxon Thaddeus K · Daytona Beach, FLBuilt 1947 · S/N 12973 N2724NF F Enterprises · Hadley, MNBuilt 1947 · S/N 12982 N2730NKnot Yaw'S Plane LLC · Greenbrier, ARS/N 12988 N2733NSteinhausen Darrel · Torrington, WYS/N 12991 N2737NKarki Theodore J · Los Alamos, NMBuilt 1947 · S/N 12995 N2744NFordyce Joel M · Carlton, ORS/N 13002 N2746NLamont Chapin F · Inglis, FLS/N 13004 N2752NMaples Jeffery · Wilmington, DEBuilt 1947 · S/N 13010 N2754NTanley Nicholas N · Brooksville, FLBuilt 1947 · S/N 13012 N2767NBanks Robert D · Hartwell, GABuilt 1947 · S/N 13025 N2775NSavant Rusty W · Kinder, LABuilt 1947 · S/N 13036 N2778NDunshee Anette M · La Luz, NMBuilt 1947 · S/N 13039 N2781NLacey Scott M · Morris, ILS/N 13042 N2794NDestefano Anthony J · Freehold, NJBuilt 1947 · S/N 13055 N2796NWestra John Jacob Trustee · Santa Ynez, CABuilt 1947 · S/N 13057 N27HTims Duane R · Hemet, CABuilt 1946 · S/N 11688 N2802NAllen William T · Hawarden, IABuilt 1947 · S/N 13063 N2809NKalabus Edward A Jr · Dallas, TXBuilt 1947 · S/N 13070 N2811NBlake Trenton D · Anderson, INBuilt 1947 · S/N 13072 N2812NCook-Berry Timothy · Brooklyn, NYBuilt 1947 · S/N 13073 N2819NSpeer Melissa · Los Angeles, CABuilt 1947 · S/N 13080 N2821NJohnson Mark L · Hood River, ORBuilt 1947 · S/N 13082 N2823NByrne David D · Fountain Hills, AZBuilt 1947 · S/N 13084 N2829NPeterson William P · Keller, TXBuilt 1947 · S/N 13090 N2837NWells Mark A · Monroe, WIS/N 13098 N2839NTristar Aviation Services LLC · Hendersonville, TNBuilt 1947 · S/N 13100 N2848NIndy Air Sales LLC · Anderson, INBuilt 1947 · S/N 13108 N2851NBennett Bob · Greenville, WIS/N 13112 N2855NSchlehr Kenneth P · North Tonawanda, NYS/N 13116 N2857NGomez Oscar · El Mirage, AZS/N 13118 N2861NJulian Stan T · Holt, FLBuilt 1947 · S/N 13122 N2867NPdb Aviation LLC · Williamson, GABuilt 1947 · S/N 13128 N2869NPennell Mark G · Sparta, NCBuilt 1947 · S/N 13130 N2873NBeck Dustin R · Millbrook, ALBuilt 1947 · S/N 13134 N2875NBrooks Ryan M · Sorrento, LABuilt 1947 · S/N 13136 N2881NFugleberg Richard H · Mayville, NDS/N 13142 N2891NBell Bradley · Bothell, WABuilt 1947 · S/N 13152 N2893NWing Wendall E · Marion, MIBuilt 1947 · S/N 13154 N28FFalkenberg Hans T · Brodnax, VABuilt 1946 · S/N 8075 N2903NPatrick Steven B · Glencoe, CAS/N 13164 N2905NBrowning IV Lonnie O · Allendale, SCBuilt 1947 · S/N 13166 N2907NLawrence Doyle D · Dallas, TXBuilt 1947 · S/N 13168 N2915NN2915n LLC · Dillon, MTS/N 12829 N291AMBeck Joseph P III · Pollock, LABuilt 1946 · S/N 8085 N2933NWelch Aviation Services LLC · Houston, TXBuilt 1947 · S/N 12753 N2941NBonn Fred H · Jamestown, KYBuilt 1947 · S/N 13202 N2945NMcdermott Max E · Alva, OKBuilt 1947 · S/N 13206 N2949NSchoettmer Thomas C · Greensburg, INBuilt 1947 · S/N 13196 N2960NTurner Kirsh · Franklin, INBuilt 1947 · S/N 13218 N2969NNelson Richard W · Edna, TXBuilt 1947 · S/N 13227

Back to Cessna 140