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.

N2151VMerschdorf Albert · East Troy, WIBuilt 1948 · S/N 14380 N2154NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N 12390 N2156VRomilda Vane Flying Club LLC · Kalispell, MTS/N 14385 N2159VFers Therese C · Stafford Springs, CTBuilt 1948 · S/N 14388 N2161VHaesler Cullen D · Grayling, MIBuilt 1948 · S/N 14390 N2162VDennis Stanley C · Burnsville, NCS/N 14391 N2164NCrane Kelly D · Sterling, AKBuilt 1947 · S/N 12400 N2164VWilkinson Jeffrey M · Leavenworth, KSBuilt 1948 · S/N 14431 N2165VVonlinsowe John E · Metamora, MIBuilt 1948 · S/N 14394 N2166NSauer Lawrence W · Dwight, ILBuilt 1947 · S/N 12402 N2166VRegistration Pending · Sacramento, CARegistration pendingBuilt 1948 · S/N 14395 N2168NPatel Chinmay K · San Jose, CABuilt 1947 · S/N 12404 N2169NRayner Gary Andrew · Henderson, NVBuilt 1947 · S/N 12405 N2174NStiles Thomas W · Pocahontas, ILBuilt 1947 · S/N 12410 N2178NWillat Garret I · Warner Springs, CABuilt 1947 · S/N 12414 N2180VHammerle Tye F · Kenosha, WIBuilt 1948 · S/N 14409 N2181VClear Blue Marketing Inc · Reno, NVBuilt 1948 · S/N 14410 N2182NEtherton Bob · Hernando, MSBuilt 1947 · S/N 12418 N2184VLo Jeffrey G · San Jose, CABuilt 1948 · S/N 14413 N2185VStreeter M Clow · Mansfield, OHBuilt 1948 · S/N 14414 N2186NAircraft Ground Support Inc · Upland, CABuilt 1947 · S/N 12422 N2187VInternational Air Services Inc Trustee · Carson City, NVS/N 14416 N2189VCotter Nicholas P · Belvidere, ILS/N 14418 N2190NDoherty Tobias E · Twin Falls, IDBuilt 1947 · S/N 12567 N2194VDitlow LLC · Kingfisher, OKBuilt 1948 · S/N 14423 N2195NSchrek Debra A · Long Valley, NJBuilt 1947 · S/N 12431 N2197VBezdicek Taylor K · Auburn, WAS/N 14426 N2198NShaw Thomas A Jr · Belleville, MIBuilt 1948 · S/N 12434 N2198VPorterfield Mark A · Comer, GABuilt 1948 · S/N 14427 N2199NSkywagon Aero LLC · Wilmington, DEBuilt 1947 · S/N 12435 N2199VSimpson Eric · College Park, MDBuilt 1948 · S/N 14428 N2200NReischmann Mike · Eustis, FLBuilt 1947 · S/N 12436 N2201NOlson Duane A · Ft Dodge, IABuilt 1947 · S/N 12437 N2202VCarr Robert · North Pole, AKBuilt 1948 · S/N 14432 N2203NBaker Terry L · Fairland, INBuilt 1947 · S/N 12439 N2204FMacdonald Kaitlyn · Dillon, MTBuilt 1948 · S/N 14890 N2204NGurney Jay L · Palmer, AKBuilt 1947 · S/N 12440 N2204VJacobson Cody R · Pine, COS/N 14435 N2205NMetris Kimberly L · Clemson, SCBuilt 1947 · S/N 12441 N2205VValaer Samuel J · Las Cruces, NMBuilt 1948 · S/N 14436 N2206NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1947 · S/N 12442 N2207VBerna Glen F · Pulaski, WIBuilt 1948 · S/N 14438 N2212NScott Brian Trani · Parachute, COS/N 12448 N2212VLewis Gavin · Schererville, INBuilt 1948 · S/N 14443 N2213VHackens Donald G · New Underwood, SDBuilt 1948 · S/N 14444 N2215NAnsorge Inc · Elk Grove, CABuilt 1947 · S/N 12451 N2216NVillegas Joshua A · Bradley, CABuilt 1947 · S/N 12452 N2216VApisson John G III · Riviera Beach, FLS/N 14447 N2219NFalkenhagen Lonnie D · Menifee, CABuilt 1947 · S/N 12455 N2219VMeisdalen Glenn C · Malta, MTBuilt 1948 · S/N 14450

Back to Cessna 140