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.

N76351Cloudcruise Ventures LLC · Sacramento, CABuilt 1946 · S/N 10768 N76356Duisenberg Brian R · Santa Cruz, CAS/N 10773 N76358Dutchess Community College · Poughkeepsie, NYBuilt 1946 · S/N 10775 N76364Tedder Chase M · Harriman, TNBuilt 1946 · S/N 10781 N76366Trotter Virgil R · Asheboro, NCBuilt 1946 · S/N 10783 N76370International Air Services Inc Trustee · Carson City, NVBuilt 1946 · S/N 10787 N76371Hayward Billy · Hyannis, NEBuilt 1946 · S/N 10792 N76372Denelsky Logan · Medina, OHBuilt 1946 · S/N 10793 N76379Wiseth Devin · Fargo, NDBuilt 1946 · S/N 10800 N76380Mcdonald Jessica M · Prior Lake, MNBuilt 1946 · S/N 10801 N76383Fischer Gregory Paul · Onekama, MIBuilt 1946 · S/N 10804 N76391Roughan Letricia F · Castaic, CABuilt 1946 · S/N 10812 N76403Renco Angelo Julio · San Diego, CABuilt 1946 · S/N 10829 N76405Koch Carson B · Vancouver, WABuilt 1946 · S/N 10831 N76406Abbott Benjamin W · Morris, OKBuilt 1946 · S/N 10832 N76410Mccarthy Kiva A · Kodiak, AKBuilt 1946 · S/N 10836 N76413Registered aircraftBuilt 1946 · S/N 10839 N76415Sprinkle David C · Alameda, CABuilt 1946 · S/N 10841 N76421Jayviation Inc · Lake City, FLS/N 10847 N76423Nartapura Feldo · Renton, WABuilt 1946 · S/N 10849 N76426Dilillo Kenneth W · Poplar Grove, ILBuilt 1946 · S/N 10852 N76427Bir James F · Marietta, OHS/N 10853 N76437Buck Fifty LLC · Freeport, ILBuilt 1946 · S/N 10869 N76440Alldredge Aviation · Auburn, WABuilt 1946 · S/N 10872 N76441Hetland Jacob R · Las Vegas, NVBuilt 1946 · S/N 10873 N76445Liptrap Debra L · Spokane, WABuilt 1946 · S/N 10877 N76447Gentrys Flying Service LLC · Prattville, ALBuilt 1946 · S/N 10879 N76460Wendt Tony V · Avon, INBuilt 1946 · S/N 10892 N76463Ohara Joseph M · Van Horn, TXS/N 10895 N76464Naile Ethan A · Inverness, FLBuilt 1946 · S/N 10896 N76473Wingnut Inc · Wilmington, DES/N 10905 N76475Jones Kiffen · Summer Shade, KYExpired dealerBuilt 1946 · S/N 10907 N76476Legas Alan Michael · Midlothian, VAS/N 10908 N76477Vandervliet Robert E · Louisa, VABuilt 1946 · S/N 10909 N76484Weaver Harold M · Martinsville, INS/N 10916 N76496Kossuth Keith E · Chino Hills, CABuilt 1946 · S/N 10928 N76509Briner John T · Celina, TXBuilt 1946 · S/N 10941 N76512Duvall James G III · Silver Springs, NVBuilt 1946 · S/N 10944 N76520Fine Robert W · North Pole, AKBuilt 1946 · S/N 10952 N76521Noslen Enterprises · Goodland, KSBuilt 1946 · S/N 10953 N76525Hendry Kyle · Santa Rosa, CABuilt 1946 · S/N 10961 N76527Malsberger Tim J · Blakely, GAFirst renewal noticeBuilt 1946 · S/N 10963 N76535Wingo John W Jr · Washington, DCBuilt 1946 · S/N 10971 N76536Dix David G · Centre Hall, PABuilt 1946 · S/N 10972 N76539Garcia Miguel A · Boqueron, PRBuilt 1946 · S/N 10975 N76555Vancil Jon D · Collierville, TNBuilt 1946 · S/N 10991 N76565Peterson Dean · Gothenburg, NEBuilt 1946 · S/N 11001 N76567Reavis Paul B · Gatesville, TXBuilt 1946 · S/N 11003 N76573Conrad Nicholas A · Midlothian, TXBuilt 1946 · S/N 11009 N76575Ibrahim George F · Redwood City, CAS/N 11011

Back to Cessna 140