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.

N77211Rigsby Robert A · Burien, WABuilt 1946 · S/N 11673 N77218Fuhrman Ronald A · Fargo, NDS/N 11680 N77219Creglow Jacob A · Soldotna, AKBuilt 1946 · S/N 11681 N77221Heiter Samuel L · South Bend, INBuilt 1946 · S/N 11683 N77245Fcboulder LLC · Boulder, COBuilt 1946 · S/N 11707 N77249Snead Travis S · South Boston, VABuilt 1949 · S/N 11711 N77253Raasch Keith A · Gresham, WIBuilt 1946 · S/N 11715 N77265Registered aircraftBuilt 1946 · S/N 11393 N77275Rodriguez Joseph Ray · Lake Elsinore, CAS/N 11488 N77284Hernandez Jorge L · Luthersville, GABuilt 1946 · S/N 11726 N77304Deckard Steven · Wellington, NVS/N 11746 N77310Picquet Blake · Albany, TXBuilt 1946 · S/N 11752 N77330Steiner Zachary J · Bethlehem, CTBuilt 1946 · S/N 11772 N77334Rotert Adam · Tulsa, OKFirst renewal noticeS/N 11776 N77341Monti Marco G · Mechanicsville, VABuilt 1946 · S/N 11782 N77345Taylor Mark S · Goshen, OHS/N 11786 N77357Registration Pending · Benton, KSRegistration pendingBuilt 1946 · S/N 11798 N77370Fitzgerald Paul · Grapevine, TXBuilt 1946 · S/N 11811 N77391Sawyer Andrew · Pleasanton, TXS/N 11832 N773SHLochman Marty R · Newalla, OKBuilt 1946 · S/N 11512 N77401Stout Philip L · Ephrata, WABuilt 1946 · S/N 11842 N77405Roach Daniel J · Centerville, OHBuilt 1946 · S/N 11846 N77417Thompson Randy L · Anderson, CAS/N 11858 N77439Timbs Gary O · Ontario, CABuilt 1947 · S/N 11881 N77442Registered aircraftBuilt 1946 · S/N 11884 N77443Aznarez Adrian B · Miami, FLFirst renewal noticeS/N 11886 N77444Holderby Jeff F · Davenport, WABuilt 1947 · S/N 11887 N77452Inderbitzin Mark Richard · Tacoma, WABuilt 1947 · S/N 11896 N77JPeters Duane · Anchorage, AKS/N 11489 N7856CSanders Dusty A · Slaton, TXBuilt 1946 · S/N 9224 N786DClifton Jerry E · Sylvania, GABuilt 1947 · S/N 13786 N797Hoctor Ray B Jr · Webster, TXBuilt 1947 · S/N 13124 N7FNHawke Aviation Inc · Oakdale, CABuilt 1946 · S/N 10748 N803NGKingdom Air Corps · Sutton, AKBuilt 1946 · S/N 9689 N8042LHigdem Dane Matthew · Kimberly, IDS/N 9367 N81030Russell Michael G · Condon, MTBuilt 1946 · S/N 10320 N81033Kreikemeier Spencer · Manhattan, MTS/N 10323 N81049Allen John B Jr · Sutter Creek, CABuilt 1946 · S/N 10339 N81051Driskill David M · Garden Ridge, TXS/N 10341 N81054Jansen Charles C · Machesney Park, ILBuilt 1946 · S/N 10344 N81055Van Steenis William W · Boulder City, NVBuilt 1946 · S/N 10345 N81057N81057 LLC · Seattle, WABuilt 1946 · S/N 10347 N81059Lyon Patrick · Elkton, MDBuilt 1946 · S/N 10349 N81065Ramaswamy Gautam · Clearwater, FLS/N 10355 N81066Dunn Michael E · Queen Creek, AZS/N 10356 N81071Registered aircraftS/N 10365 N81073Larson Dustin · Baldwin City, KSBuilt 1946 · S/N 10367 N81074Holland Andrew K · Sterling, AKBuilt 1946 · S/N 10368 N81077Egmond Aircraft LLC · Lewes, DEBuilt 1946 · S/N 10371 N81083Klugman Dale F Trustee · Helena, MTBuilt 1946 · S/N 10377

Back to Cessna 140