Skip to content

Registered aircraft · 976

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

N2802SBurt Charley R · Anchorage, AKBuilt 1967 · S/N 15066702 N2804SAlmy David W · Riverside, CABuilt 1967 · S/N 15066704 N2810SWaco West Inc · Dover, DEBuilt 1967 · S/N 15066710 N2819SBeale Frank B II · Bowling Green, VABuilt 1967 · S/N 15066719 N2821SHancock Jeffrey A · Jacksonville, TXS/N 15066721 N2824SGolf Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 15066724 N2825SShore Luke S · Elkin, NCBuilt 1967 · S/N 15066725 N2832SMeyer Philipp J · Sioux Falls, SDBuilt 1967 · S/N 15066732 N2834SMcmahon Connor J · Brookfield, CTBuilt 1967 · S/N 15066734 N2835SDuyck Candace A · Cornelius, ORS/N 15066735 N2837SBuric Ivan · Panama City, FLBuilt 1967 · S/N 15066737 N2838SLewallen Roy W · Beaverton, ORBuilt 1967 · S/N 15066738 N2839SVon Trapp Ryan G · Charlotte, NCBuilt 1967 · S/N 15066739 N2842SRegistration Pending · Mountain Home, ARRegistration pendingBuilt 1967 · S/N 15066742 N2843SRegistration Pending · Tequesta, FLRegistration pendingS/N 15066743 N2844SJacks Grady M · Mena, ARS/N 15066744 N2856SPerera Nandana L · Logan, OHBuilt 1967 · S/N 15066756 N2857SCrum Brian B · Warrensburg, MOS/N 15066757 N2859SHout David D · Columbus, OHBuilt 1967 · S/N 15066759 N2861SEagley Ronald A · Anchorage, AKBuilt 1967 · S/N 15066761 N2862SGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 15066762 N2864STop Aircraft Leasing LLC · Wilmington, DEBuilt 1967 · S/N 15066764 N2867SJarrell Loyd F · Whitesburg, TNBuilt 1967 · S/N 15066767 N2875SHolland Van D · Sandy Valley, NVBuilt 1967 · S/N 15066775 N2876SRay Charlie B · Prosser, WAS/N 15066776 N2877SWarner David F · Altoona, IABuilt 1967 · S/N 15066777 N2880SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066780 N2881SSerbus Gary E · Olivia, MNBuilt 1967 · S/N 15066781 N2885SWinter Thomas N · Lincoln, NEBuilt 1967 · S/N 15066785 N2887SRobinson Andrew K · Pahrump, NVBuilt 1967 · S/N 15066787 N2889SKinter Christopher A · Kodiak, AKS/N 15066789 N2890SKeyte Clinton W · Colfax, CABuilt 1967 · S/N 15066790 N2895SMaur Karandeep · Meadville, PABuilt 1967 · S/N 15066795 N2905SCole Ezra L · Gentry, ARBuilt 1967 · S/N 15066805 N2908JBranton Hewett · Nashville, TNS/N 15065708 N2908SSloan Paul · Escondido, CABuilt 1967 · S/N 15066808 N2909SFatla Gregory F · Hixton, WIBuilt 1967 · S/N 15066809 N2910JWeldy Mark L · Etna Green, INBuilt 1966 · S/N 15065710 N2912SWard Ascher · Oxnard, CAS/N 15066812 N2913JMulti Engine Training Co Inc · Tuttle, OKS/N 15065713 N2913SMartin Richard E · Palmyra, WIBuilt 1967 · S/N 15066813 N2914JMaverick Aviation Holdings LLC · Sheridan, WYS/N 15065714 N2915SKoch Kenneth Scott · Coolidge, AZS/N 15066815 N2917JKnoll David Alexander · Godwin, NCBuilt 1966 · S/N 15065717 N2917SItz LLC · Lusby, MDBuilt 1967 · S/N 15066817 N2918JNiemann Benjamin W · Welton, IAS/N 15065718 N2918SAbove All Aviation Inc · Goleta, CABuilt 1967 · S/N 15066818 N2919SJust Plane Corp · Kokomo, INS/N 15066819 N2920JRegistration Pending · Powell Butte, ORRegistration pendingBuilt 1966 · S/N 15065720 N2920SLea Nathanael E · Olalla, WABuilt 1967 · S/N 15066820

Back to Cessna 150G