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.

N2488VSpencer Robert J · Florence, AZBuilt 1948 · S/N 14757 N2491VZweifel Stephan G · Northfield, MNBuilt 1948 · S/N 14760 N2493VAir Enterprises LLC · Dover, DEBuilt 1948 · S/N 14762 N2497NFischer John T · Fort Worth, TXBuilt 1947 · S/N 12750 N2497VDarr Nicholas D · Boron, CABuilt 1948 · S/N 14766 N2498NReynolds Brent · Marietta, GAS/N 12751 N2498VFountain John Harrison · Willis, TXS/N 14767 N2505NPeterson Todd D · Bonfield, ILBuilt 1947 · S/N 12762 N2508NSchneider Kalan J · Intl Falls, MNBuilt 1947 · S/N 12765 N2514NLeavitt Kevin · Cathlamet, WAS/N 12771 N2520NJavarey David J · Corning, NYBuilt 1947 · S/N 12778 N2523NTourtelotte Joel H · Newburgh, MEBuilt 1946 · S/N 10959 N2526NBlair Stanley P · Fort Myers, FLBuilt 1947 · S/N 12782 N2540NStover Charles E · Osceola, INBuilt 1947 · S/N 12796 N2543NFunes Mauricio A · Durham, NCBuilt 1947 · S/N 12799 N2544NMaslen Halbrook · Carson City, NVBuilt 1947 · S/N 12800 N2553NSandhills Veterinary Clinic P C · Arthur, NEBuilt 1947 · S/N 12809 N2555NVroom David H · Oro Valley, AZBuilt 1947 · S/N 12811 N2573NKruger Thomas H Jr · Hoquiam, WABuilt 1947 · S/N 12832 N2574NWest Thomas L · Payson, AZBuilt 1947 · S/N 12833 N2578NSeanez Justin · Hollister, CABuilt 1947 · S/N 12838 N2581NWise Jeffrey R · Ocala, FLS/N 12841 N2585NChandler Ronald James Seth · Tucson, AZS/N 12845 N2588NSchweller James O · Centerville, OHBuilt 1947 · S/N 12848 N2597NJohson David G · Cleburne, TXBuilt 1947 · S/N 12857 N2602NBunting Dale R · Cambria, CABuilt 1947 · S/N 12862 N2603NMonroe James C Jr · Winston Salem, NCBuilt 1947 · S/N 12863 N2608NCutter Anthony D · Corning, CAS/N 12868 N2609NWest Earl W · Canton, TXS/N 12869 N2615NMckusker Jeremy · New Canton, VAS/N 12875 N2618NCole Raymond L · Cordova, TNBuilt 1947 · S/N 12878 N2622NKunicki Robert W · Corpus Christi, TXBuilt 1947 · S/N 12678 N2628NCrawford Christopher S · Catlin, ILBuilt 1947 · S/N 12886 N2632NHanna Raymond A · Yuma, AZBuilt 1947 · S/N 12890 N2635NPastore Michael J Jr · Naperville, ILBuilt 1947 · S/N 12893 N2637NRegistration Pending · Greenfield, INRegistration pendingBuilt 1947 · S/N 12895 N2644NMcphee Charles E · Hartford, NYBuilt 1947 · S/N 12902 N2646NChester Darren D W · Sioux Falls, SDBuilt 1947 · S/N 12904 N2649NKennedy John E · Henrico, NCBuilt 1947 · S/N 12907 N2652NRounds Chris DBA · Waller, TXS/N 12910 N2671NKrajci Michael T · Yardley, PABuilt 1947 · S/N 12929 N2673NPreston Harold W · Carrollton, TXBuilt 1955 · S/N 12931 N2674NHillmer Daniel M · Manitowoc, WIBuilt 1947 · S/N 12932 N2685NEvans Sheila Margaret · Griffin, GAS/N 12943 N2692NSinnott-Simonis Lyle · Girdwood, AKBuilt 1947 · S/N 12950 N2694NTodd Gregg A · Moneta, VABuilt 1947 · S/N 12952 N2697NOrsak Chris L · Seymour, TXBuilt 1947 · S/N 12955 N2700NDague James L · Kewanna, INBuilt 1947 · S/N 12958 N2707NLarsen James A · Minot, NDBuilt 1947 · S/N 12965 N2709NFannin Warren Haukland · Yulee, FLBuilt 1947 · S/N 12967

Back to Cessna 140