Skip to content

Registered aircraft · 1,439

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 ('2071830')
  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 ('2071830')
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.

N3820VShalom Aviation LLC · Miami, FLS/N 15076633 N3858VMission Aviation LLC · Orange Park, FLBuilt 1975 · S/N 15076637 N3859VK3 Safe Air LLC · Mokena, ILBuilt 1975 · S/N 15076638 N3875VBlaedow Kyle R · North Pole, AKBuilt 1975 · S/N 15076643 N3904VObloy James J · Brunswick, OHBuilt 1975 · S/N 15076649 N3936VRyden LLC · Goodyear, AZBuilt 1975 · S/N 15076658 N3939VSaddler Joshua L · Lincoln, CABuilt 1975 · S/N 15076660 N3940VSoderman Brian · East Bethel, MNBuilt 1975 · S/N 15076661 N3984VRussell Steve · Harper, ORBuilt 1975 · S/N 15076671 N3995VDesjardins James H · Troutdale, ORBuilt 1975 · S/N 15076674 N3997VWestfall Lorn W III · League City, TXS/N 15076675 N4020VDanielson Bradley M · Pelkie, MIBuilt 1975 · S/N 15076680 N4038VStirling Nathan L · Alton, MEBuilt 1975 · S/N 15076682 N4049VJustin William R · Sauk Rapids, MNBuilt 1975 · S/N 15076685 N4065VStiletto Beaver Touchdown LLC · Evanston, ILBuilt 1975 · S/N 15076689 N4076VPennington Charles A · Fort Smith, ARBuilt 1975 · S/N 15076691 N4081VLark Thomas S · Coppell, TXBuilt 1975 · S/N 15076694 N4086VBoyd Darrell M · Claremore, OKBuilt 1975 · S/N 15076695 N4088VSlezak Daniel S · Santa Margarita, CABuilt 1975 · S/N 15076696 N4092VGroves Donald L · Butler, PABuilt 1975 · S/N 15076697 N40WLBentley Thomas F · Lockport, ILBuilt 1976 · S/N 15078056 N4100VSanders Keith · Palm Bay, FLS/N 15076701 N4103VMoore Israel · Pasco, WABuilt 1975 · S/N 15076702 N444GSWhitten Andrew J · Astoria, ORBuilt 1975 · S/N 15077446 N447DKDecesare Lynnette · Charlotte, NCBuilt 1974 · S/N 15076128 N45023New Joel · Waco, TXBuilt 1975 · S/N 15076705 N45028Witke Ray · Menomonie, WIBuilt 1975 · S/N 15076706 N45031Stahla Russell · Girdwood, AKBuilt 1975 · S/N 15076709 N45034Coffelt Roy · Nampa, IDBuilt 1975 · S/N 15076710 N45045Lingle Gordon D · Gun Barrel City, TXBuilt 1975 · S/N 15076711 N45058Red Cardinal Aviation LLC · Chantilly, VAS/N 15076715 N45073Trailing Edge LLC · Elmira, NYBuilt 1975 · S/N 15076724 N45080Todd Doug A · Dewitt, IABuilt 1975 · S/N 15076726 N45082Long Robert D · Kinston, NCBuilt 1975 · S/N 15076727 N45112Iaba LLC · Norfolk, VABuilt 1975 · S/N 15076739 N45115Jiang Jun · Fremont, CAS/N 15076740 N45132Jamesweathers Robi J · Blaine, MNS/N 15076747 N45143Fly Sky Ads LLC · Manalapan, NJBuilt 1975 · S/N 15076753 N45156Flight Training Solutions LLC · Longwood, FLBuilt 1975 · S/N 15076760 N45166Jet Life LLC · Coconut Creek, FLS/N 15076764 N45169Carlisle Elizabeth L · Mohnton, PABuilt 1975 · S/N 15076766 N45170Smits Joel R · Crete, ILBuilt 1975 · S/N 15076767 N45190Violette Colin E · Rough And Ready, CABuilt 1975 · S/N 15076777 N45198Ebe Aviation LLC · Urbandale, IABuilt 1975 · S/N 15076781 N45203November 45203 LLC · Waterbury Center, VTBuilt 1975 · S/N 15076784 N45230Zutter Regan James · Hooper, UTBuilt 1975 · S/N 15076793 N45235Grimes James R · Carlton, GAS/N 15076796 N45237Defrees Brooks H · Boulder, COBuilt 1975 · S/N 15076797 N45243Keas Kirby Clay · Lakeway, TXS/N 15076800 N45245Rimar Dale S · Boca Raton, FLS/N 15076802

Back to Cessna 150M