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.

N8036SStern Mark A · Tallevast, FLBuilt 1965 · S/N 15061636 N8038FJackovich Dennis A · Bettendorf, IABuilt 1966 · S/N 15064138 N8038SPainter Bryan · Renton, WABuilt 1965 · S/N 15061638 N8040FWingfield Kyle M · Leesburg, GABuilt 1966 · S/N 15064140 N8040SNew Flight LLC · Dublin, VABuilt 1965 · S/N 15061640 N8042SBanning Braden L · Pleasant Hill, IABuilt 1965 · S/N 15061642 N8043SLund William R · Escondido, CABuilt 1965 · S/N 15061643 N8046SHolmes Gerald P · Billerica, MABuilt 1965 · S/N 15061646 N8047FPoole Terrell W · Rigby, IDBuilt 1966 · S/N 15064147 N8048FParris Morgan Aaron R · Taylors, SCBuilt 1966 · S/N 15064148 N8049STri State Aero Inc · Martinsburg, WVBuilt 1965 · S/N 15061649 N8050SWeeks George E · Trenton, SCS/N 15061650 N8053FCurell Ken E · Centerville, OHBuilt 1966 · S/N 15064153 N8055FGerken James D Jr · Salem, VABuilt 1966 · S/N 15064155 N8055SFoster Tommy L · Thaxton, VAS/N 15061655 N8057FThenappan Nachiappan · Round Rock, TXBuilt 1966 · S/N 15064157 N8060SGrinfeder Alex J · Little Rock, ARBuilt 1965 · S/N 15061660 N8061Gibson Isaac S · Saint John, INBuilt 1965 · S/N 15061669 N8061FMorales Jose · Mission, TXBuilt 1966 · S/N 15064161 N8062FJackson Hugh W · Cordova, SCBuilt 1966 · S/N 15064162 N8062SSturm Steve G Trustee · Springdale, ARS/N 15061662 N8066FWilson Edwin · Midland, MIBuilt 1966 · S/N 15064166 N8068FGoldmuntz Jeffrey A · Chandler, AZBuilt 1966 · S/N 15064168 N8068SJastrab Ryan M · Apple Valley, CABuilt 1965 · S/N 15061668 N8073FDoll J M Smokey · Austin, TXBuilt 1966 · S/N 15064173 N8075FLogan Francis Bodrero · Outlook, WABuilt 1966 · S/N 15064175 N8076FYoxtheimer David R · Mansfield, OHBuilt 1966 · S/N 15064176 N8076SChinn Thomas Blake · Arlington, TXBuilt 1965 · S/N 15061676 N8077FM-F Aviation LLC · Norman, OKS/N 15064177 N8077SRebecca Grace LLC · Riesel, TXBuilt 1965 · S/N 15061677 N8078SBazemore Kelley R · Ingleside, TXS/N 15061678 N8079FRegent Aero LLC · Kingsland, GAS/N 15064179 N8083SKoenig William J · Benedict, MDS/N 15061683 N8084FAustin Michael S · Utica, KYS/N 15064184 N8084SHunter Robert M · Rawlins, WYS/N 15061684 N8085SSchulz Michael L · Norfolk, NEBuilt 1965 · S/N 15061685 N8087FWarbington Michael L · Enid, OKS/N 15064187 N8087SBridges Jeffrey · Allen, TXBuilt 1965 · S/N 15061687 N8088SRutherford Thom J · Birchwood, WIBuilt 1965 · S/N 15061688 N8089FFlying A Aviation LLC · Archer City, TXBuilt 1966 · S/N 15064189 N8089SBleier Rachel · Grayslake, ILBuilt 1965 · S/N 15061689 N808ESStaples Safari Ministries Outreach · Clayton, WAS/N 15064164 N8093FHardy Peter Nicholas · Los Osos, CABuilt 1966 · S/N 15064193 N8095SKimball James D · Osceola, IABuilt 1965 · S/N 15061695 N8100SHigh Exposure Inc · Wilmington, DEBuilt 1965 · S/N 15061700 N8102FFerrier Robert Clifford · Lindsay, CABuilt 1966 · S/N 15064202 N8104FDunham John P · Colorado Springs, COS/N 15064204 N8104SFlowers Tony C · Panhandle, TXBuilt 1965 · S/N 15061704 N8106FHoward Mason · Phoenix, AZBuilt 1966 · S/N 15064206 N8106SMay Jason L · Alva, OKBuilt 1965 · S/N 15061706

Back to Cessna 150F