Skip to content

Registered aircraft · 1,065

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

N8171SLeavitt Adam · Boulder City, NVS/N 15061771 N8172FButler Donald S · Oak Ridge, NCBuilt 1966 · S/N 15064272 N8173FJohnson Jacob A · Shawnee, OKS/N 15064273 N8174FRangefinder Aviation LLC · Fort Collins, COS/N 15064274 N8175SAnderson Marcus D · Memphis, TNBuilt 1965 · S/N 15061775 N8177FLong Steven J · Amery, WIBuilt 1966 · S/N 15064277 N8179SOllantair LLC · Chicago, ILBuilt 1965 · S/N 15061779 N8181SCopeland Kevin D · Vidalia, GABuilt 1965 · S/N 15061781 N8183FArvizu Jason Arthur Scott · Bakersfield, CABuilt 1966 · S/N 15064283 N8185SJanssen Christopher M · Manchester, IABuilt 1965 · S/N 15061785 N8187FCoady Michael J · Taylorville, ILBuilt 1966 · S/N 15064287 N8187SCounter Kevin · Windsor, CAS/N 15061787 N818MLTurning Point Northwest LLC · Stanwood, WABuilt 1966 · S/N 15064017 N8191FMoore Clayton P · Cayce, SCBuilt 1966 · S/N 15064291 N8191SStang Daniel Jr · Lindale, TXBuilt 1965 · S/N 15061791 N8193FMother Lode Flying Club · San Andreas, CABuilt 1966 · S/N 15064293 N8193SVoshell Frank T · Freeport, MIBuilt 1965 · S/N 15061793 N8195SMolina Manolo R · Fayetteville, ARBuilt 1965 · S/N 15061795 N81963Larson Wayne M · Plymouth, MNBuilt 1966 · S/N 15063608 N8197FHartman Eric J · Wilson, NYBuilt 1966 · S/N 15064297 N8198FDesterfans Lance · Lodi, CAS/N 15064298 N8198SHhd Aviation LLC · Hamilton, OHS/N 15061798 N819EBWalker Kyle V · Bastrop, TXBuilt 1966 · S/N 15063984 N8200FCallanan Craig E · Stillwater, NJBuilt 1966 · S/N 15064300 N8200SPoms Maxfield David · Groveland, CABuilt 1965 · S/N 15061800 N8201FYellott Jerry L Jr · Dequincy, LABuilt 1966 · S/N 15064301 N8201SMann Derek W · Burwell, NEBuilt 1965 · S/N 15061801 N8202F98x LLC · Caddo Mills, TXBuilt 1966 · S/N 15064302 N8202SBell Tammy L · San Antonio, TXS/N 15061802 N8205FRegistered aircraftBuilt 1966 · S/N 15064305 N8205SMckay Christopher · Point Arena, CAS/N 15061805 N8207FChantry Terrell A · Lake Havasu City, AZFirst renewal noticeBuilt 1966 · S/N 15064307 N8213SMcilrath Paul J · Des Moines, IABuilt 1965 · S/N 15061813 N8214FHoneycutt David · Columbus, MSBuilt 1966 · S/N 15064314 N8218FDel Rosario Jose · Hackettstown, NJBuilt 1966 · S/N 15064318 N8219FKietzer Tyler L · Mankato, MNS/N 15064319 N8220SHammack Lindsey M · Westlake, TXBuilt 1965 · S/N 15061820 N8221FSale Reported · Eau Claire, MISale reportedBuilt 1966 · S/N 15064321 N8223FSoderman David W · Gilby, NDBuilt 1966 · S/N 15064323 N8223SRedditt William L · Erie, PABuilt 1965 · S/N 15061823 N8224FDiamond David Z · Wrentham, MABuilt 1966 · S/N 15064324 N8226FPrahin Michael H · Novi, MIBuilt 1966 · S/N 15064326 N8227SKashani Asher Farzan · Reseda, CABuilt 1965 · S/N 15061827 N8228SMorristown Flying Service Inc · Talbott, TNS/N 15061828 N8229SShanaman Baratt S · Ann Arbor, MIBuilt 1965 · S/N 15061829 N8231FNeuman Paul · Campbellsburg, KYBuilt 1966 · S/N 15064331 N8232FSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15064332 N8237SArth Richard E · Newcomerstown, OHBuilt 1965 · S/N 15061837 N8239FTeeters Larry N · Shreveport, LABuilt 1966 · S/N 15064339 N823FStout Philip L · Ephrata, WAS/N 15064514

Back to Cessna 150F