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.

N90007Emerson Byron D · Sisters, ORBuilt 1946 · S/N 9061 N90025Hoffman David G · Givens Hot Springs, IDBuilt 1946 · S/N 9083 N90034Hawkins Rayma J · Little Rock, ARBuilt 1946 · S/N 9092 N90043Peters Nicholas J · Eagle River, AKBuilt 1946 · S/N 9101 N90051Eiland Justin C · Stephenville, TXS/N 9109 N90053Frost Chelsea L · Anacortes, WABuilt 1946 · S/N 9111 N90054Two Ten Aero LLC · Safford, AZBuilt 1946 · S/N 9112 N90055Hance Everett P · Hubbardsville, NYBuilt 1946 · S/N 9113 N90060Schweiser John T · Sterling, KSBuilt 1946 · S/N 9121 N90066Beech O Sphere LLC · Casper, WYS/N 9127 N90067Right Rudder Flight Training LLC · La Verne, CABuilt 1946 · S/N 9128 N90068Clifton George F · Seattle, WABuilt 1946 · S/N 9129 N90072Epple Jason E · Canby, MNS/N 9133 N90075Whitney Kenton C Trustee · Tempe, AZBuilt 1946 · S/N 9136 N90083Wittnebel Karl D · Los Angeles, CABuilt 1946 · S/N 9144 N90084Holmsley Perry · Sheffield, TXBuilt 1946 · S/N 9145 N90092Durand Gregory M · Marquette, MIBuilt 1946 · S/N 9153 N90106Jj Aero LLC · Chuckey, TNS/N 9167 N90110Joao James T · West Melbourne, FLBuilt 1946 · S/N 9171 N90111Dill Tharold J Jr · Boron, CABuilt 1946 · S/N 9172 N90112Pieszala John W · Larksville, PABuilt 1946 · S/N 9173 N90116Gaylord Michael L · San Francisco, CABuilt 1946 · S/N 9177 N90120Lawson Kenneth H · Logandale, NVS/N 9181 N90122White Darrell J · Radford, VABuilt 1946 · S/N 9183 N90127Spradling Robin P · Henderson, NVBuilt 1946 · S/N 9188 N90130Duncan John H · Franklin, NCBuilt 1946 · S/N 9191 N90138Baker Air Service · Baker, MTBuilt 1946 · S/N 9199 N90139Groff Russell D · Winchester, TNBuilt 1946 · S/N 9200 N90148Lsrw Aviation LLC · Zebulon, NCS/N 9209 N90152Mcdonald Timothy · Daytona Beach, FLBuilt 1946 · S/N 9217 N90154Mathis Ryan Blake · Madison, ALBuilt 1946 · S/N 9219 N90155Blanc Christopher F · Renton, WABuilt 1946 · S/N 9220 N90163Roehm John P · Clinton, INBuilt 1946 · S/N 9228 N90164Boutwell Nathan G · Pelham, NHBuilt 1946 · S/N 9229 N90167Reeves Richard E · Lincoln, NEBuilt 1946 · S/N 9232 N90172Doll J M Smokey · Austin, TXBuilt 1946 · S/N 9237 N901742001 LLC · Lakeville, MNBuilt 1946 · S/N 9239 N90175Patz Michael · Anchorage, AKBuilt 1946 · S/N 9240 N90179Thomason Todd · Harrison, ARBuilt 1946 · S/N 9244 N90190Bobka Christian · NorthamptonshireS/N 9255 N90192Johnson Dennis F · Detroit Lakes, MNBuilt 1946 · S/N 9257 N90195Meggers Roger D · Baker, MTBuilt 1946 · S/N 9260 N90199Stoddard David J · Lagrange, WYBuilt 1946 · S/N 9264 N911LWeese Cameron · Quinlan, TXS/N 15006 N9129RMckee Bradley Cole · Temple, TXBuilt 1946 · S/N 8601 N913SSMosher Duane · Lubbock, TXS/N 14913 N9198ZMitchell Grant Avery · Fallon, NVBuilt 1946 · S/N 10629 N91TMitchell Carl D · Gainesville, TXBuilt 1946 · S/N 10244 N9482ASnyder Kenneth C · Lonsdale, MNBuilt 1949 · S/N 15303 N94HRSheets Jeffrey · Fort Worth, TXBuilt 1947 · S/N 12802

Back to Cessna 140