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.

N3654VKellermann Denis John · Lompoc, CABuilt 1948 · S/N 14925 N3655VRobertson James E · Yucca Valley, CABuilt 1948 · S/N 14926 N3656VWells Charles L III Administrator · Jacksonville, FLS/N 14927 N3657VCollins Leon R · Palestine, TXBuilt 1948 · S/N 14928 N3659VBeech O Sphere LLC · Casper, WYBuilt 1948 · S/N 14930 N3667VDonohue Cody T · San Antonio, TXBuilt 1948 · S/N 14939 N3669VMeyjes Gus · Cadillac, MIBuilt 1948 · S/N 14985 N3677VNanny Seith A · Nine Mile Falls, WABuilt 1948 · S/N 14951 N3693VLennox Gregory P · Encinitas, CABuilt 1948 · S/N 14969 N3694VBuzzard Air Service LLC · Carleton, MIBuilt 1948 · S/N 14970 N3696VMojica William E · Hilliard, OHBuilt 1948 · S/N 14972 N36MCChase Michael A · Humboldt, TNS/N 9072 N3701VCopithorne Richard · West Paris, MES/N 14977 N3702VHolcomb Garry · Greenville, TXS/N 14978 N3703VBaker Scott S · Townsend, DES/N 14979 N3704VAutumn Crucus LLC · Cincinnati, OHS/N 14980 N3706VInternational Air Services Inc Trustee · Carson City, NVBuilt 1946 · S/N 15026 N3709VHashbarger Joel C · Hope, NDBuilt 1948 · S/N 14984 N3711VForty Eight One Forty LLC · Newberry, SCBuilt 1948 · S/N 14988 N3713VHam Ryan K · Seattle, WABuilt 1948 · S/N 14990 N3714VSamuelson Thomas A · Delanson, NYBuilt 1948 · S/N 14991 N3717VWahlers Richard H · Meridian, IDBuilt 1948 · S/N 14994 N3719VSkiles David A · Manassas, VABuilt 1948 · S/N 14996 N3720VBaldwin John D · Sisters, ORS/N 14997 N3724VKosik Steven J · Bennett, COBuilt 1948 · S/N 15001 N3725VRyan David Wayne · Lubbock, TXBuilt 1948 · S/N 15002 N3728V140 Ventures LLC · Lewes, DES/N 15005 N3730VSteingas David M · Karnack, TXBuilt 1949 · S/N 15007 N3732VRosenbach Jay A · Chugiak, AKBuilt 1949 · S/N 15051 N3738VPeirson Dana M · Carson City, NVBuilt 1948 · S/N 15015 N3742VPoppe David P · Nenana, AKBuilt 1948 · S/N 15019 N3743VOmni Aero LLC · Wilkesboro, NCBuilt 1948 · S/N 15020 N3744VRegistration Pending · Madison, WVRegistration pendingBuilt 1948 · S/N 15021 N3745VHill Lesly G · Folsom, CABuilt 1948 · S/N 15022 N3746VFritz Kurt M · Carson City, NVBuilt 1949 · S/N 15036 N3747VBurick John C · Juneau, AKBuilt 1948 · S/N 15024 N3751VPeters Neil H · Britton, SDBuilt 1949 · S/N 15031 N3752VWilburn Leon D · Hilltop Lakes, TXBuilt 1949 · S/N 15053 N3756VAdams Rex B · Devol, OKBuilt 1949 · S/N 15039 N3758VStolp-Carey Linda J · Anaheim, CABuilt 1949 · S/N 15041 N3759VR & M Disposal LLC · Red Cloud, NES/N 15042 N37623Hirst Jeremy · Solana Beach, CABuilt 1947 · S/N 13329 N3762VLuedtke Merlin G · Marana, AZS/N 15047 N3765VWest Daniel W · Tellico Plains, TNBuilt 1949 · S/N 15049 N3771VRussell Steven D · Waxhaw, NCBuilt 1949 · S/N 15064 N3775VGevers David E · Lafayette, INBuilt 1949 · S/N 15068 N3793VCrisp III Harold N · Universal City, TXBuilt 1949 · S/N 15214 N3836Trammell James S · Saint Paul, MNBuilt 1947 · S/N 12510 N3910BCannon Aero Services LLC · Colbert, WABuilt 1946 · S/N 8101 N4000NSanchez Sebastian · Albuquerque, NMBuilt 1947 · S/N 13458

Back to Cessna 140