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.

N4214NNininger Beverly S II · Vinton, VABuilt 1947 · S/N 13685 N4220NOneill Mark B · Pinckney, MIS/N 13691 N4223NLinden Michael A · Rockford, ILBuilt 1947 · S/N 13694 N4229NAero-Mobil Inc · Wilmington, DEBuilt 1947 · S/N 13700 N4239NWatosky Ian F · Wolcott, NYBuilt 1947 · S/N 13710 N4240NBennett Bob · Greenville, WIBuilt 1947 · S/N 13711 N4245NSell Scott F · Moody, TXS/N 13716 N4248NMatonti James Robert · ChonburiRegistration ineffective or invalidS/N 14021 N4249NCessna 140 LLC · Taylor, MOS/N 13720 N4254NBentch James · Lincoln, MOS/N 14028 N4259NBergeron Daniel M · Dickinson, TXBuilt 1947 · S/N 13730 N4263NHerold Robert D · Tallahassee, FLBuilt 1947 · S/N 13734 N4269NEdwards Bruce W · Palmer, AKBuilt 1947 · S/N 13740 N4270NAshley Edward A · San Antonio, TXBuilt 1947 · S/N 13741 N4278NConley Jay · Saxonburg, PABuilt 1947 · S/N 13749 N4279NQuevedo Joseph David · El Paso, TXBuilt 1947 · S/N 13750 N4285NSchrag Jeremy M · Garden Plain, KSBuilt 1947 · S/N 13756 N4289NKingsley Clint · Cerritos, CABuilt 1947 · S/N 13760 N4290NAlbion Aerial Sprayers Inc · Sargent, NEBuilt 1947 · S/N 13761 N4293NSpringfield Flying Service LLC · Columbia, CABuilt 1947 · S/N 13764 N4299NHogan Michael · Lansing, MIBuilt 1947 · S/N 13770 N42KHo Christopher Y · Anchorage, AKBuilt 1947 · S/N 12223 N4300NNotaras George John · Manhattan Beach, CABuilt 1947 · S/N 13771 N4601CCook Jeffrey B · Aiea, HIS/N 13190 N464SANoyes Daniel W · Oak Point, TXBuilt 1946 · S/N 8973 N47140Sproule Peter J · Buckley, WABuilt 1947 · S/N 12209 N4724CHarvey Douglas W · Shreveport, LABuilt 1947 · S/N 12498 N47WRRobillard Robert P · Lewis Center, OHBuilt 1946 · S/N 8454 N48DWYearwood Neva D · Mineola, TXBuilt 1948 · S/N 14561 N490DCWulff John D · Hayward, WIS/N 9123 N4984ERay L Ender · San Marcos, TXBuilt 1946 · S/N 10588 N508DLonguski Francis J · Vassar, MIBuilt 1946 · S/N 10940 N516ARBrown Michael D · Arlington, WAS/N 13049 N51ETRodopoulos Phillip · North Royalton, OHBuilt 1946 · S/N 8305 N521EFBowen Nathan William · Washington, GABuilt 1947 · S/N 12257 N5271MHarris Robert C Jr · San Diego, CABuilt 1947 · S/N 14089 N5307CFrantz William T · Wasilla, AKS/N 15427 N53JXVoligny Patrick E · Chillicothe, OHBuilt 1947 · S/N 12681 N546CPAustin Cody R · Pflugerville, TXBuilt 1948 · S/N 14875 N5529XFerguson Flying Service LLC · Springfield, MOS/N 14303 N5581MPlane Fun Inc Tr Trustee · Snellville, GAS/N 12599 N5582SLaroche John A · Ellington, CTS/N 14870 N55DCBement Robert · Kelsey, CABuilt 1946 · S/N 11395 N5625CWhittlesey Leslie F · Dana Point, CAS/N 15578 N5663CSykes Gregory P · Arlington, WAS/N 15619 N58FBurch Michael H · Bowling Green, FLS/N 11593 N599XCollins Curtis R · Tennessee Colony, TXS/N 10876 N6236UCaceres Rossel Bayardo J · Jamesville, NCBuilt 1946 · S/N 10332 N6321DBrown Kenneth R · Los Altos Hills, CABuilt 1946 · S/N 9117 N6400DDanker Dale W · Inola, OKBuilt 1946 · S/N 8026

Back to Cessna 140