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.

N2220VHarland Gary · Tuscumbia, ALBuilt 1948 · S/N 14451 N2221VStone Wall Acres · Antigo, WIS/N 14452 N2224VSokol Dennis A · Milan, OHBuilt 1948 · S/N 14455 N2225VNebrig Kenneth J Trustee · Prescott, AZBuilt 1948 · S/N 14456 N2226VPrince Benjamin D · Lincoln, MTBuilt 1948 · S/N 14457 N2227NMakotyn Andrzej · Northbrook, ILBuilt 1947 · S/N 12463 N2227VWingnut Inc · Wilmington, DEBuilt 1948 · S/N 14458 N2228VZerener Mark A · Wichita, KSFirst renewal noticeBuilt 1948 · S/N 14459 N2230NHansen Aviation LLC · Savannah, GAS/N 12466 N2230VThompson Dan W · Canby, ORBuilt 1948 · S/N 14461 N2231NStokes Michael J · Chino, CABuilt 1947 · S/N 12467 N2234VWeed Kelli · Stevensville, MTBuilt 1948 · S/N 14465 N2236VHerrington Kevin M · Honey Grove, TXBuilt 1948 · S/N 14467 N2237NLoucks Gregory B · Flushing, MIBuilt 1947 · S/N 12473 N2237VTodd Doug · Brainerd, MNS/N 14468 N2238VPulte Frank A · Burton, MIS/N 14469 N223PEMiller James L · Galena, ILBuilt 1946 · S/N 9336 N2242VNelson Richard · Edna, TXBuilt 1948 · S/N 14473 N2245VGustav Flabelhauser LLC · Spokane, WABuilt 1948 · S/N 14519 N2246CKorman Nicholas · Lebanon, INBuilt 1946 · S/N 8098 N2247NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N 12483 N2248NSmith David J · Duluth, MNS/N 12484 N2252VZampa Joseph A · Whitewater, COBuilt 1948 · S/N 14483 N2253VBurnet Robert C · Niceville, FLBuilt 1948 · S/N 14484 N2254VPhillip Ashiku · Ukiah, CAS/N 14485 N2255VPrice Tracker C · Hattiesburg, MSBuilt 1948 · S/N 14486 N2257NHolmes Dallas Wade · Bend, ORS/N 12493 N2257VPurnell Aviation LLC · Little Rock, ARBuilt 1948 · S/N 14488 N2258VPearman Hattie Allison · Tupelo, MSS/N 14489 N2260VNorth Valley Aircraft Inc · Valley City, NDS/N 14491 N2265VMalzer Mark A · Turtle Lake, NDBuilt 1948 · S/N 14523 N2266NBovington Thomas P · Helena, MTS/N 12506 N2266VFerris Elden L · Vancouver, WABuilt 1948 · S/N 14521 N2267VHast David W · Caledonia, MIBuilt 1948 · S/N 14498 N2270VWise River Aviation LLC · Manhattan, MTBuilt 1948 · S/N 14501 N2271NKasuske Gerald A · Watertown, SDBuilt 1947 · S/N 12511 N2273VMarsh John E · Washington, DCS/N 14504 N2277NMillikan Jeffrey C · Trinity, NCBuilt 1947 · S/N 12517 N2278NTucker Christian T · Butler, MOS/N 12518 N2279VBenedict Larry D · Dexter, NMBuilt 1948 · S/N 14510 N2280VSwinney Stephen A · Blue Springs, MOBuilt 1948 · S/N 14433 N2281VCarter Nicholas J · Milton, VTS/N 14511 N2282NWelborn Mark G · Boonville, NCBuilt 1947 · S/N 12522 N2284NFinn Michael R · Maple Grove, MNBuilt 1947 · S/N 12524 N2285VFitzgerald Thomas T Jr · Park Ridge, ILBuilt 1948 · S/N 14515 N2287UMuse Robert C · Vienna, VABuilt 1946 · S/N 9055 N2288NDoose Charles L · Clarendon Hills, ILBuilt 1947 · S/N 12528 N2291VMorton Roger J · Baldwinsville, NYBuilt 1948 · S/N 14527 N2292VBurton Robert E Jr · Vancouver, WABuilt 1948 · S/N 14528 N2294VWudtke Andrew T · Palos Park, ILBuilt 1948 · S/N 14530

Back to Cessna 140