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.

N72971Hammerle Tye F · Kenosha, WIBuilt 1946 · S/N 10172 N72976Los Pajaros Flying Club Inc · El Macero, CABuilt 1946 · S/N 10177 N72979Pyne Jeffrey S · Spanish Fork, UTBuilt 1946 · S/N 10180 N72980Kraemer Todd R · Grand Blanc, MIBuilt 1946 · S/N 10181 N72982Burrill Donald M · White City, ORFirst renewal noticeBuilt 1946 · S/N 10183 N72983Seiler David · Anaheim, CAS/N 10184 N72992Bailey Carlton D Jr · Huntington, WVS/N 10197 N72994Elmore Kimberly L · Norman, OKBuilt 1946 · S/N 10199 N72AHawkes Arthur E · West Falmouth, MABuilt 1946 · S/N 9337 N73002Bureau Todd · Hope, AKBuilt 1946 · S/N 10207 N73003Schwieterman Neal J · Paonia, COBuilt 1946 · S/N 10208 N73011Maurer Christian N · Loveland, OHBuilt 1946 · S/N 10216 N73014Hunter Nicholas · Irwin, PABuilt 1946 · S/N 10219 N73016Devault Chelsey · Katy, TXBuilt 1946 · S/N 10221 N73022Edwards Christopher V · Seattle, WABuilt 1946 · S/N 10227 N73023J & T Aviation Llf Inc · Sparks, NVS/N 10228 N73026Plane Fun Inc Tr Trustee · Snellville, GAS/N 10231 N73037Borris Roy E · Miltona, MNBuilt 1946 · S/N 10245 N73039Schmidt David S · Brooksville, MSBuilt 1946 · S/N 10247 N73045Strachan Darrel A · San Jose, CABuilt 1946 · S/N 10253 N73065Austin Donald B · Locust Grove, GABuilt 1946 · S/N 10277 N73077Egmond Aircraft LLC · Lewes, DEBuilt 1946 · S/N 10293 N73081Sale Reported · Lone Jack, MOSale reportedBuilt 1946 · S/N 10297 N73087Plane Affair LLC · Miami, FLBuilt 1946 · S/N 10303 N73092Lynch Susan S · Saint Inigoes, MDS/N 10312 N73096Hammerle Tye F · Kenosha, WIBuilt 1946 · S/N 10316 N73099Lawson Lonnie B II · Linden, PABuilt 1946 · S/N 10319 N76006Miller Joseph A · Lompoc, CABuilt 1946 · S/N 10400 N76009Gullwing Aviation Holdings LLC · Lewes, DES/N 10403 N76014Strader Frank L · Walnut, ILS/N 10408 N76017Gilbeau Leslie A · Hobart, INBuilt 1946 · S/N 10411 N76022Grosso Michael F · Charleston, SCBuilt 1946 · S/N 10416 N76025Boehme Larry R · Albany, WIBuilt 1946 · S/N 10419 N76033Lemna Bradley Wade · Fort Wayne, INBuilt 1946 · S/N 10427 N76039Henrich Joseph E · New Hope, PABuilt 1946 · S/N 10433 N76043Mcpartland Patrick · Herriman, UTBuilt 1946 · S/N 10437 N76045Gertz David L II · Winston Salem, NCBuilt 1946 · S/N 10439 N76049Oneal Terry C · Pampa, TXBuilt 1946 · S/N 10443 N76051Odom James R · Plainview, TXBuilt 1946 · S/N 10445 N76058Flow Edwin E · Orange Park, FLBuilt 1946 · S/N 10452 N76063Wilson Travis W · Beaver Dam, KYBuilt 1946 · S/N 10457 N76071Dickinson Harley Dean · Saint Paris, OHBuilt 1946 · S/N 10465 N76074Eaton Billy J · Bridgeport, TXS/N 10468 N76075Dafoe Thomas B · Arbuckle, CABuilt 1946 · S/N 10469 N76092Greer Charles R Jr · Denair, CABuilt 1946 · S/N 10489 N76095Kephart John M · Franklin, INBuilt 1946 · S/N 10492 N76099Perdue Adrian V · Denton, NCBuilt 1946 · S/N 10496 N76102Johnson Lawrence F · Anchorage, AKBuilt 1946 · S/N 10499 N76106Cooper John R · Tilton, NHBuilt 1946 · S/N 10503 N76111Blake Joshua J · Detroit Lakes, MNBuilt 1946 · S/N 10508

Back to Cessna 140