Skip to content

Registered aircraft · 166

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

N2004ZWhiting Robert A Jr · Scarborough, MEBuilt 1962 · S/N 15059804 N2006ZN2006z LLC · South Hill, VABuilt 1963 · S/N 15059806 N2007ZRau John M · Liberty, KSBuilt 1962 · S/N 15059807 N2016ZPederson William K Jr · Hillsboro, ORBuilt 1963 · S/N 15059816 N2018ZBurkel Shawn W · Greenbush, MNBuilt 1963 · S/N 15059818 N2020ZAbrahamson Nicholas P II · Grosse Ile, MIBuilt 1963 · S/N 15059820 N2021ZMclean Jr Rufus C · Rockingham, NCBuilt 1963 · S/N 15059821 N2025ZVgh Holdings LLC · Wilmington, DEBuilt 1963 · S/N 15059825 N2026ZIrons Gregory B · Nixa, MOS/N 15059826 N2032ZPointer Ned A · The Dalles, ORBuilt 1963 · S/N 15059832 N2039ZBradberry Charles G · Iowa Park, TXBuilt 1963 · S/N 15059839 N2040ZCreech Daniel B · Chewelah, WABuilt 1963 · S/N 15059840 N2042ZNedoba John · Stevensville, MIBuilt 1963 · S/N 15059842 N2043ZRobotico Holdings Corp · Roselle, ILBuilt 1963 · S/N 15059843 N2045ZBragg J Robert · Cortez, COBuilt 1963 · S/N 15059845 N2047ZDhall Sanjay · Canton, MIBuilt 1963 · S/N 15059847 N2052ZSchramm Craig O · Fenton, MIBuilt 1963 · S/N 15059852 N2053ZLangholz Denise · Covington, WABuilt 1963 · S/N 15059853 N2055ZGoebel Jacob · Rhome, TXBuilt 1963 · S/N 15059855 N2065ZBorn Stephen R · Yucaipa, CABuilt 1963 · S/N 15059865 N2066ZGrand Flying Club Inc · Redding, CAS/N 15059866 N2068ZThompson Jeffrey A · Bishop, CABuilt 1963 · S/N 15059868 N2069ZMiller Scott A · Norwood, MOBuilt 1963 · S/N 15059869 N2074ZKelly John M · Gastonia, NCBuilt 1963 · S/N 15059874 N2076ZHyer Lindsay C · Jacksonville, NCBuilt 1963 · S/N 15059876 N2078ZLockhart Flying Club · Lockhart, TXBuilt 1963 · S/N 15059878 N2079ZSpitler Scott M · Maryville, TNBuilt 1963 · S/N 15059879 N2081ZMcfarland Ryan E · Jacksonville, FLBuilt 1963 · S/N 15059881 N2082ZRamirez Frank Torres · Santa Rosa, CABuilt 1963 · S/N 15059882 N2083Z343 Aero Club · Bossier City, LAS/N 15059883 N2087ZFischer Gary H · Savannah, GABuilt 1963 · S/N 15059887 N2090ZRegistered aircraftRegistration pendingBuilt 1963 · S/N 15059890 N2094ZSpak Andrew T · Thousand Oaks, CABuilt 1963 · S/N 15059894 N2095ZLoose Keith · Saint Helens, ORS/N 15059895 N2096ZHammons Clayton W · Salome, AZBuilt 1963 · S/N 15059896 N2097ZSchieferecke Jeanine · Topeka, KSBuilt 1963 · S/N 15059897 N391DYHartje Ronald V · Sutter Creek, CABuilt 1962 · S/N 15059765 N602Watkins Arlo S · Chandler, AZBuilt 1963 · S/N 15060073 N6167EMiller James C III · Papillion, NES/N 15059791 N63150Parrish Jonathan · Boulder City, NVBuilt 1962 · S/N 15059756 N63CZCoan Eli P · Goldsboro, NCBuilt 1963 · S/N 15060070 N7801ZRegistered aircraftBuilt 1963 · S/N 15059901 N7804ZRegistered aircraftS/N 15059904 N7806ZRobinson Jordan P · Lexington, NCBuilt 1963 · S/N 15059906 N7807ZSmokovitz Joseph M · Tecumseh, MIBuilt 1963 · S/N 15059907 N7811ZTeske Robert E · Kalamazoo, MIBuilt 1963 · S/N 15059911 N7812ZAbbe Thomas E · Wasilla, AKBuilt 1963 · S/N 15059912 N7813ZMainus Virginia L · Westfield, PABuilt 1963 · S/N 15059913 N7814ZVaughn Rex · Spur, TXBuilt 1963 · S/N 15059914 N7820ZBuckley Joseph L · Gulfport, MSBuilt 1963 · S/N 15059920

Back to Cessna 150C