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.

N140YABeineke Paul R · Marion, OHBuilt 1946 · S/N 10993 N146FTTavener Frederick L · Cape May, NJBuilt 1946 · S/N 11303 N149JASummers Dennis L · Perry, OKBuilt 1948 · S/N 14937 N1508UKnefley J Michael · Ulysses, PABuilt 1948 · S/N 14995 N150RBailey Richard N · Danville, VABuilt 1948 · S/N 14441 N154DGFisher Jeffrey L · Thorndale, TXBuilt 1947 · S/N 12621 N1600KDenzil Charles David · Southmayd, TXBuilt 1946 · S/N 8639 N1604VShuel Dale W · Brighton, COBuilt 1947 · S/N 13776 N1612VQuan Justin · Ventura, CABuilt 1947 · S/N 13784 N1619VCushway Amos · Anchorage, AKS/N 13791 N1624VSmith John C · Greenville, NCBuilt 1947 · S/N 13796 N1627VSmith Eric M · Sanger, TXFirst renewal noticeBuilt 1947 · S/N 13799 N1649VLaforce Larry B · Big Sandy, TXBuilt 1947 · S/N 13821 N1661VWeggel Roger · Fairbanks, AKS/N 13833 N1663VBryant George R · Gainesville, TXBuilt 1947 · S/N 13835 N1671VHarris James J · Saint Marys, OHBuilt 1947 · S/N 13843 N1685VCreglow Jacob A · Soldotna, AKS/N 13857 N1695VAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1947 · S/N 13867 N1704VFigure 1 Foundation · Los Angeles, CABuilt 1948 · S/N 13889 N1706VHermann Christine F · Radford, VABuilt 1947 · S/N 13891 N1710VWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1947 · S/N 13895 N1720VEdmonds Sherry B · Georges Mills, NHBuilt 1947 · S/N 13905 N1722VLittle Bird Aviation · Abiquiu, NMBuilt 1947 · S/N 13907 N1726VBosquet Arthur · Highgate Center, VTS/N 14034 N1728VMoore Edward L · Hixson, TNBuilt 1947 · S/N 13913 N1776VNelson Richard W · Edna, TXBuilt 1947 · S/N 13961 N1778VWatkins James R · Granbury, TXBuilt 1947 · S/N 13963 N1784VHarlow Nathan D · Milton, VTBuilt 1947 · S/N 13969 N1788NLahti Matt · Waterford, MIBuilt 1946 · S/N 12032 N1790VThompson Randy L · Anderson, CABuilt 1947 · S/N 14023 N1792VScholz Paul W · Clifton Park, NYBuilt 1948 · S/N 14520 N1798VBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 13983 N1806VBrown Christopher · Mancelona, MIBuilt 1947 · S/N 13991 N1808VReller Bernard D · Gainesville, FLBuilt 1947 · S/N 13993 N1838VRegistered aircraftBuilt 1947 · S/N 14015 N1848VGray William G · Littlefork, MNBuilt 1947 · S/N 14019 N1850VHudson Dave C Jr · Sumrall, MSBuilt 1947 · S/N 14020 N1856CJones Mark S · Tampa, FLBuilt 1946 · S/N 8996 N1859VKorson James J · Yorkville, ILBuilt 1947 · S/N 14038 N1860VNuckles Charles A Jr · Suffolk, VABuilt 1947 · S/N 14039 N1863VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 14043 N1872VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N 14052 N1874VRaczynski Adam · Far Rockaway, NYS/N 14054 N1875VTigger LLC · Missoula, MTBuilt 1947 · S/N 14055 N1877VHickman Robert J · Canby, ORBuilt 1947 · S/N 14057 N1879VAnderson Marshall C · Jacobson, MNBuilt 1947 · S/N 14059 N1881VSimonson Todd D · Minnetonka, MNBuilt 1947 · S/N 14061 N1882VBell William F · Peachtree Corners, GABuilt 1947 · S/N 14062 N1888VMiller Thomas Lee · Clemmons, NCBuilt 1947 · S/N 14068 N1894VKohlert Jeffrey R · Saint Charles, ILBuilt 1947 · S/N 14083

Back to Cessna 140