Skip to content

Registered aircraft · 659

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

N61177Spenner John T · Fenton, MOBuilt 1969 · S/N 15070863 N61178Seman Kenneth H · Ravenna, OHBuilt 1969 · S/N 15070864 N61182B2 W Corporation · Winona, MNBuilt 1969 · S/N 15070867 N61184Lawson Gary R · Olympia, WAS/N 15070869 N61186Petit Leon · Virgil, ILBuilt 1969 · S/N 15070871 N61187Registration Pending · Burleson, TXRegistration pendingBuilt 1969 · S/N 15070872 N61189Orr Jeffrey N · Waco, TXBuilt 1969 · S/N 15070874 N61190Freed Richard H · Watervliet, MIBuilt 1969 · S/N 15070875 N61192Possemato Domenic · Lincoln, NHS/N 15070877 N61205Lockhart Aero LLC · Austin, TXBuilt 1969 · S/N 15070886 N61206Hahlbohm Jeffrey S · Helena, MTS/N 15070887 N61207Desroches John · Scottsdale, AZS/N 15070888 N61208Cutone Ronald J · Old Saybrook, CTBuilt 1969 · S/N 15070889 N61212Cole Lauren · Rockford, MIS/N 15070890 N61213Madrigal Francisco Javier · Newman, CABuilt 1969 · S/N 15070891 N61215Moody Bible Institute Of Chicago · Spokane Valley, WABuilt 1969 · S/N 15070892 N61221Lang Christopher S · Genoa, NVBuilt 1969 · S/N 15070896 N61229Rivera Carlos A · Beach Park, ILBuilt 1969 · S/N 15070902 N61231US Flight Academy International Inc DBA · Post, TXBuilt 1969 · S/N 15070904 N61232East Bay Trading Company LLC · Fairview, PABuilt 1969 · S/N 15070905 N61233Advanced Aviation LLC · Kapolei, HIBuilt 1969 · S/N 15070906 N61234Registered aircraftBuilt 1969 · S/N 15070907 N61243Rios Leah F · Anchorage, AKBuilt 1969 · S/N 15070913 N61244Smith Rex M · Marshfield, MOS/N 15070914 N61251Chickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 15070916 N61253Flight Gate LLC · Wilton, CAS/N 15070918 N61259Lund Michael J · Poulsbo, WABuilt 1969 · S/N 15070924 N61282Trimble David G · Vici, OKBuilt 1969 · S/N 15070939 N61288Vanorman Curt M · Clarkesville, GABuilt 1969 · S/N 15070944 N61296Coomes Scott F · Seattle, WABuilt 1969 · S/N 15070947 N61297Highway Jet League Flyers Brotherhood LLC · Allouez, WIBuilt 1969 · S/N 15070948 N61311Wood James A · Madera, CABuilt 1969 · S/N 15070955 N61321Gerdes Brian K · Los Alamitos, CAS/N 15070963 N61324Wills Evan J · Lynnwood, WABuilt 1969 · S/N 15070964 N61325Zetir Mohamad · Oviedo, FLBuilt 1969 · S/N 15070965 N61329Girls Love To Fly Inc · Roseville, CABuilt 1969 · S/N 15070969 N61333Gustafson Michael J · Minnetonka, MNBuilt 1969 · S/N 15070972 N61336Evans David C · Thousand Oaks, CABuilt 1969 · S/N 15070973 N61338Flyit LLC · Camas, WABuilt 1969 · S/N 15070975 N61345Carlson Brent A · Shelley, IDS/N 15070980 N61354New Vision Aviation · Fresno, CABuilt 1969 · S/N 15070985 N61363Hulbert Stephen R · Fort Ransom, NDBuilt 1969 · S/N 15070989 N61365Plane Progress LLC · Waterloo, IABuilt 1969 · S/N 15070990 N622APCaradine Jimmie · Commerce, TXFirst renewal noticeBuilt 1969 · S/N 15071086 N623APHartman Michael F · Montclair, CABuilt 1969 · S/N 15070915 N677JFShorey Peter K · Newry, MEBuilt 1969 · S/N 15069677 N68PGNewsom Kevin J · Bloomington, INBuilt 1968 · S/N 15070027 N705TDFlight Gear Aviation LLC · Pickerington, OHS/N 15069561 N715SHPotoczek Jeffrey · Century, FLS/N 15070696 N7486SGarage Doors Of Greenville LLC · Greenville, MSBuilt 1969 · S/N 15070358

Back to Cessna 150J