Skip to content

Registered aircraft · 387

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

N7910EBobbitt Charles W · Madill, OKFirst renewal noticeBuilt 1960 · S/N 17710 N7912ECallahan Richard T · Lancaster, CABuilt 1960 · S/N 17712 N7914ESteiner Ward · Clayton, CABuilt 1959 · S/N 17714 N7916EFisher David N · Memphis, TNBuilt 1959 · S/N 17716 N7917EProby Trevor J · Adkins, TXBuilt 1960 · S/N 17717 N7919ENicodemus Trey M · Springfield, OHBuilt 1959 · S/N 17719 N7923EKelly Charles Michael · San Angelo, TXBuilt 1959 · S/N 17723 N7926ELtg Enterprises LLC · Fort Wayne, INBuilt 1959 · S/N 17726 N7930EHeck Jean M · Colorado Springs, COBuilt 1959 · S/N 17730 N7934EDevine Stephen P · Pearland, TXS/N 17734 N7935ELowe David M · Sacramento, KYBuilt 1959 · S/N 17735 N7940EAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1960 · S/N 17740 N7943EQuisenberry Richard S · Marietta, OKS/N 17743 N7949EPurstell Kevin · Burnt Hills, NYBuilt 1959 · S/N 17749 N7950EGanskop Brandy D · Flaxton, NDBuilt 1959 · S/N 17750 N7953ZMartin Aviation LLC · Bargersville, INBuilt 1963 · S/N 15060053 N7957ELynn Kerry E · Stow, MABuilt 1960 · S/N 17757 N7962ENesta Alex · Winder, GABuilt 1959 · S/N 17762 N7965ELangton Kathy A · Exeter, CAS/N 17765 N7970EMckenna Terence M · Scotts Valley, CABuilt 1959 · S/N 17770 N7973EDunham Matthew J · Duarte, CABuilt 1959 · S/N 17773 N7974EJstream Lc · Sheridan, WYBuilt 1959 · S/N 17774 N7978ESalyer Spencer · Modesto, CABuilt 1959 · S/N 17778 N7979EAglar Daniel P · Agate, COS/N 17779 N7980EEhrhardt Eric · Wauconda, ILBuilt 1959 · S/N 17780 N7982EBodin Logan · Lake Charles, LAS/N 17782 N7990EYankoviz Frank T · Monett, MOBuilt 1959 · S/N 17790 N7991EMiller Samuel A · Westphalia, KSS/N 17791 N7997ESmith Andrew H · BramfordNon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 17797 N7998ECunha Eduardo · Rochester, NYBuilt 1960 · S/N 17798 N80DTTerasaka Kotaro · Moab, UTBuilt 1959 · S/N 17052 N80RMMcguigan Robert J · Green Cove Springs, FLBuilt 2001 · S/N A1520745 N8302JValley Gabriel · Holden, MEBuilt 1967 · S/N 15066202 N8425GSaitto Jeffrey M · Media, PABuilt 1965 · S/N 15062525 N8797GTriplett Joseph C II · Pontotoc, MSBuilt 1966 · S/N 15062897 N999JCCoffman Mark · Sanger, CABuilt 1960 · S/N 17965 N99KACervera Rod · Kernville, CABuilt 1959 · S/N 17786

Back to Cessna 150