Skip to content

Registered aircraft · 1,439

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

N714JFMetcalf Christopher A · Meadowview, VABuilt 1977 · S/N 15079206 N714JKDrouin Arnold R · Berlin, NHBuilt 1977 · S/N 15079210 N714JLWestra Todd A · Ireton, IABuilt 1977 · S/N 15079211 N714JTThompson John · Stevens Point, WIBuilt 1977 · S/N 15079217 N714JXPiteck Timothy S · Battle Ground, WAS/N 15079221 N714KEGustin Ralph P · New Smyrna Beach, FLFirst renewal noticeBuilt 1977 · S/N 15079228 N714KKMcnally Robert H · Tulsa, OKS/N 15079233 N714KMDavis Steven M · Eastsound, WABuilt 1977 · S/N 15079234 N714KQBowser Dwight H · Anchorage, AKBuilt 1977 · S/N 15079237 N714KRB2 W Corporation · Winona, MNBuilt 1977 · S/N 15079238 N714KTCox Garry G · Coleman, TXS/N 15079240 N714KUInsalaco Stephen C · Benson, AZS/N 15079241 N714KWHerbert Michael S · Crawford, COBuilt 1977 · S/N 15079243 N714KXLowder Harold E · Fresno, CABuilt 1977 · S/N 15079244 N714KZGlomb Andrew · Las Vegas, NVBuilt 1977 · S/N 15079246 N714LCCruz Martin G Jr · Prosper, TXBuilt 1977 · S/N 15079249 N714LFRollins David M · Martinsville, INBuilt 1977 · S/N 15079252 N714LPBlue Skies Time Builders LLC · Roy, WAS/N 15079260 N714LRSt Johns Aviation LLC · Saint Johns, MIS/N 15079262 N714LWMorcom Aviation Services Inc DBA · Everett, WABuilt 1977 · S/N 15079267 N714LXMock Joseph R · Huntsville, TXBuilt 1977 · S/N 15079268 N714LZKhosrovyan Rafayel · Fort Worth, TXS/N 15079270 N714MWicked Wings LLC · Falls Of Rough, KYS/N 15079274 N714MCAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 15079273 N714MGManandhar Raj P · Hawthorne, CABuilt 1977 · S/N 15079277 N714MJRheintgen Rachel L · Saint Petersburg, FLBuilt 1977 · S/N 15079279 N714MKMoe Hudson T · Anchorage, AKBuilt 1977 · S/N 15079280 N714MMBragg Peter M · Brooklet, GABuilt 1977 · S/N 15079282 N714MPHendrickson Reino W · Osage, MNBuilt 1977 · S/N 15079284 N714MWGanser Mark E · Seward, AKBuilt 1977 · S/N 15079290 N714MZAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1977 · S/N 15079293 N714NFSierra Lima Aviation LLC · Riverton, UTBuilt 1977 · S/N 15079298 N714NGIngold Terry L · Albemarle, NCBuilt 1977 · S/N 15079299 N714NHCarroll Douglas Orem Jr · Greenwood, DEBuilt 1977 · S/N 15079300 N714NJPortes Emerson · Merrimack, NHBuilt 1977 · S/N 15079301 N714NLAerolanding LLC · Enterprise, ALBuilt 1977 · S/N 15079303 N714NMJax Rentals LLC · Saint Augustine, FLS/N 15079304 N714NQSmith Christopher D · Limington, MEBuilt 1977 · S/N 15079307 N714NRUdenberg Scott M · Cotter, ARBuilt 1977 · S/N 15079308 N714NXPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1977 · S/N 15079314 N714PAOne Six Sierra LLC · Boulder, COS/N 15079317 N714PCSchuessler Christopher · Upland, CABuilt 1977 · S/N 15079319 N714PGJet & Rotor Aviation LLC · Sacramento, CAS/N 15079323 N714PHColitti Mark A · North Hollywood, CABuilt 1977 · S/N 15079324 N714PLImmel Titan M · Adair, IABuilt 1977 · S/N 15079327 N714PXLionudakis Christopher L · Conroe, TXBuilt 1977 · S/N 15079337 N714PZLehman Richard S · Mulberry, TNBuilt 1977 · S/N 15079339 N714QBVelasco Rolando · Belgrade, MTBuilt 1977 · S/N 15079341 N714QDMeese Brian D · Conroe, TXBuilt 1977 · S/N 15079343 N714QGFerrick James F · Mechanicville, NYBuilt 1977 · S/N 15079346

Back to Cessna 150M