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.

N72310Jackson Air LLC · Savannah, GABuilt 1946 · S/N 9487 N72317Aviation Services Of Tn Inc · Sparta, TNBuilt 1946 · S/N 9497 N72320Winkel Ray E · Glen Elder, KSBuilt 1946 · S/N 9500 N72325Registration Pending · Eagle River, AKRegistration pendingS/N 9505 N72328Newcomer Ryan D · Monroe, GABuilt 1946 · S/N 9508 N72331Reynolds Larry J · Rhome, TXBuilt 1946 · S/N 9511 N72332Registered aircraftBuilt 1946 · S/N 9512 N72333Niegel Gregory S Jr · Pleasant Grove, CAS/N 9513 N72339Romstadt Eric P · Oregon, OHBuilt 1946 · S/N 9523 N72341Michaud Daniel L · Brewer, MEBuilt 1946 · S/N 9525 N72344Kong Trudith A · Auburn, WABuilt 1946 · S/N 9528 N72362Elmira Aeronautical Associates Inc · Elmira, NYBuilt 1946 · S/N 9548 N72363Pathfinder Aero Services LLC · Sheridan, WYS/N 9549 N72371Clark Curtis E · Scottsdale, AZBuilt 1946 · S/N 9557 N72373Beishline Daniel · Bath, MEBuilt 1946 · S/N 9559 N72379Anderson Kacy L · San Juan Bautista, CABuilt 1946 · S/N 9565 N72386Sommers Timothy Wade · Elizabeth City, NCBuilt 1946 · S/N 9572 N72393Snow Joseph A · Monroe, WIBuilt 1946 · S/N 9579 N72394Rowlett Glen R · Brookshire, TXFirst renewal noticeBuilt 1946 · S/N 9580 N72398Brewer Joshua R · Sonora, CAFirst renewal noticeBuilt 1946 · S/N 9584 N72431Katzman Solomon J · Santa Cruz, CABuilt 1946 · S/N 9596 N72435Meruelo Andrea M · Ouray, COBuilt 1946 · S/N 9600 N7243NGray Gordon Thomas · Redmond, ORBuilt 1948 · S/N 14786 N72440Livingston Edward M Jr · Crestview, FLBuilt 1946 · S/N 9605 N72458Guritz John G · Dunlap, CABuilt 1946 · S/N 9623 N72460Harms Dakota J · Newton, KSBuilt 1946 · S/N 9625 N72464Tarr Sheryl L · Spokane, WABuilt 1946 · S/N 9629 N72475Pripps Seth · Appleton, WIBuilt 1946 · S/N 9643 N72477Ground Loop LLC · Clemmons, NCBuilt 1946 · S/N 9645 N72481Greenland Gary L · Three Springs, PABuilt 1946 · S/N 9649 N72483Lasalle Charles H · Williamstown, NYBuilt 1946 · S/N 9651 N72484Denly James E · Erie, COBuilt 1946 · S/N 9652 N72485Devane Alvin E · Oklahoma City, OKBuilt 1946 · S/N 9653 N72489Armor Air Corp · Foristell, MOBuilt 1946 · S/N 9657 N72495Georges Frederick K · Seward, AKBuilt 1946 · S/N 9665 N72498Dairy Air Inc · Wyoming, PABuilt 1946 · S/N 9668 N72499Vanbeber Richard L · Collinsville, OKBuilt 1946 · S/N 9669 N72507Brown Elijah E · Chino Valley, AZBuilt 1946 · S/N 9677 N72513International Air Services Inc Trustee · Carson City, NVBuilt 1946 · S/N 9683 N72514Mcintosh Douglas R · Wenatchee, WAS/N 9684 N72515Lingo John C · Hamilton, INS/N 9685 N72526Perry James R · Simpsonville, SCBuilt 1946 · S/N 9696 N72529Kreit Kenneth S · Catlett, VABuilt 1946 · S/N 9699 N72530Rutschow Kenneth T · La Vergne, TNBuilt 1946 · S/N 9700 N72531Voltz Kyle D · Oshkosh, WIBuilt 1946 · S/N 9701 N72533Hale Thomas A · Springfield, OHBuilt 1946 · S/N 9703 N72535Root Angelo R · Orovada, NVBuilt 1946 · S/N 9705 N72545Ejr Aviation LLC · Ashburn, VABuilt 1946 · S/N 9715 N72547Manifee Doris Darlene · Black Canyon City, AZBuilt 1946 · S/N 9717 N72549Windsock Capital LLC · Bertram, TXS/N 9719

Back to Cessna 140