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.

N2298NHall David K · Madisonville, TNBuilt 1947 · S/N 12538 N2298VArnett Freddy H Jr · Yulee, FLBuilt 1948 · S/N 14534 N2299NWard Worth W · El Cajon, CABuilt 1947 · S/N 12539 N2299VDouglas-Carter Tammi A · Greenville, KYS/N 14535 N2300VClay Ernest P · Huntington, WVBuilt 1948 · S/N 14536 N2302NAnimal Eye Clinic Of Pensacola LLC · Pensacola, FLBuilt 1947 · S/N 12542 N2305NJcfl LLC · Houma, LABuilt 1947 · S/N 12545 N2305VN2305v LLC · Grand Haven, MIBuilt 1948 · S/N 14541 N2307VKarel Benjamin R · Stillwater, MNBuilt 1948 · S/N 14543 N2308VInverted Aero LLC · Spring Hill, FLBuilt 1948 · S/N 14544 N2309VDahlke Philip H · Smyrna, GABuilt 1948 · S/N 14545 N2311NTeeters Chester Arthur Jr · Salinas, CABuilt 1947 · S/N 12581 N2313VFojtik Amy L · Edna, TXS/N 14549 N2314VSvec Aaron · Estelline, SDBuilt 1948 · S/N 14550 N2318VJones Stanley E · Castle Rock, COBuilt 1947 · S/N 14554 N2319VSottile Frank B · Lasalle, MIBuilt 1948 · S/N 14555 N2320NNye Roger V · Graham, WABuilt 1947 · S/N 12560 N2323NLee Marc · Goodyear, AZBuilt 1947 · S/N 12563 N2327NStapleton Kenneth E · Nocona, TXBuilt 1947 · S/N 12585 N2328NBlythe Anne T · Paso Robles, CAS/N 12586 N2330NWheadon William J · Napa, CABuilt 1947 · S/N 12570 N2331N642 Flyers LLC · Mankato, MNS/N 12571 N2331VStevens Linda J · Caldwell, IDBuilt 1948 · S/N 14567 N2332VMalato Lawrence M · Chicago, ILBuilt 1948 · S/N 14568 N2333NBasinger Kenneth J · Mcdonough, GABuilt 1947 · S/N 12573 N2335NGilbert Richard L · Eugene, ORBuilt 1947 · S/N 12575 N2336NNelson Richard W · Edna, TXBuilt 1947 · S/N 12576 N2338NNelson David L · Niceville, FLS/N 12578 N2341VChilman Nathan · Ellensburg, WABuilt 1948 · S/N 14726 N2342VDodge Inc · Wilmington, DEBuilt 1948 · S/N 14724 N2344VBoyes Robert L · Benton City, MOBuilt 1948 · S/N 14580 N2345NMurphy James L · El Reno, OKBuilt 1946 · S/N 9612 N2350NHarris Bradley S · Alexandria, VABuilt 1947 · S/N 12596 N2352VHuddleston Ronnie L · North Vernon, INBuilt 1948 · S/N 14588 N2353VSpredemann Carl A · Emmett, IDBuilt 1948 · S/N 14727 N2357VGillis John H · Elbert, COBuilt 1948 · S/N 14593 N2358VHerbert Aviation LLC · Spring City, UTBuilt 1948 · S/N 14594 N2359VDegolier-Schulze Stephanie L · Jefferson, WIBuilt 1948 · S/N 14595 N2360VZupan Michael J · Mount Vernon, INBuilt 1948 · S/N 14596 N2363VTerpstra Trevor W · Modesto, CABuilt 1948 · S/N 14599 N2365VHolley Jonathan O.A. · Rockmart, GABuilt 1948 · S/N 14601 N2366VWhite Trevor C · Anchorage, AKBuilt 1948 · S/N 14602 N2367NGeohagan Patrick Tom · Perry, FLBuilt 1947 · S/N 12616 N2367VHauser Linda L · Ulysses, KSBuilt 1948 · S/N 14603 N2368VHetchler Glenn A · Erie, COBuilt 1948 · S/N 14604 N2370VBlackburn Russell A · Clovis, CABuilt 1948 · S/N 14606 N2373NMorris Gray S · Chugiak, AKBuilt 1947 · S/N 12622 N2374VMelveney Aaron · West, TXBuilt 1947 · S/N 14610 N2375NLanducci Lou L · Brookshire, TXBuilt 1947 · S/N 12624 N2379NFussell Leon J · Broxton, GABuilt 1947 · S/N 12628

Back to Cessna 140