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.

N63210Johnson Mark L · Bend, ORBuilt 1975 · S/N 15077177 N63211Prestige Worldwide Charters LLC · Edgartown, MABuilt 1975 · S/N 15077178 N63214Brady William Berte · Venice, FLS/N 15077181 N63219Cresap Dale A · Idaho Falls, IDS/N 15077185 N6321KBrookby John M · Grand Prairie, TXBuilt 1975 · S/N 15077642 N63220Ronchini Denis · Haverhill, MABuilt 1975 · S/N 15077186 N63221Ruebush Joshua K · Eaton, OHBuilt 1975 · S/N 15077187 N63231Stafford Anthony T · Collierville, TNS/N 15077189 N63233Gill Charles D · Baton Rouge, LABuilt 1975 · S/N 15077191 N63234Guerrero Erwin F · South Bend, INBuilt 1975 · S/N 15077192 N63237Biemer Alexander · Spring Branch, TXBuilt 1975 · S/N 15077195 N63244Bacus Brent · Indianapolis, INS/N 15077199 N63246Musser John R · Freeport, ILBuilt 1975 · S/N 15077200 N63248Lewis Luther Daniel · New Bern, NCBuilt 1975 · S/N 15077202 N6324KRegistration Pending · Princeton, NJRegistration pendingBuilt 1975 · S/N 15077643 N63252Bork Michael F · Kalamazoo, MIBuilt 1975 · S/N 15077205 N63256Bridge To Freedom Investments LLC · Atlanta, GAS/N 15077207 N63258Cleven Randall L · Moncure, NCBuilt 1975 · S/N 15077209 N63259Lloyd Kevin S · Tacoma, WABuilt 1975 · S/N 15077210 N63260Van Hise Austin S · Fort Denaud, FLBuilt 1975 · S/N 15077211 N63263Debonair Solutions LLC · Leesville, LAS/N 15077214 N63265Cessna Flyers LLC · Zephyrhills, FLS/N 15077216 N63270Louise Flyers LLC · Cheyenne, WYBuilt 1975 · S/N 15077219 N63272Glantz Charles P · Albuquerque, NMS/N 15077221 N63283Johnston Daniel · Virginia Beach, VABuilt 1975 · S/N 15077227 N63285Honan John A · Lincroft, NJBuilt 1975 · S/N 15077228 N63287Waters Brandon J · Bushnell, ILBuilt 1975 · S/N 15077230 N63290N63290 LLC · Boulder City, NVBuilt 1975 · S/N 15077232 N63293Roesner Alvin R · Indianapolis, INBuilt 1975 · S/N 15077233 N63332Andavia LLC · Fort Worth, TXBuilt 1975 · S/N 15077241 N63338Scarbrough Mark B · San Miguel, CAS/N 15077247 N63341Puget Sound Flyers Inc · Everett, WAS/N 15077250 N63342Vmax Aviation LLC · Uhrichsville, OHBuilt 1975 · S/N 15077251 N63346White Thomas L · Willow Springs, MOBuilt 1975 · S/N 15077253 N63359Flick Adam C · Findlay, OHBuilt 1975 · S/N 15077261 N63362Bels Holdings LLC · Albert Lea, MNBuilt 1975 · S/N 15077262 N63363Shaner John D · Tallahassee, FLBuilt 1975 · S/N 15077263 N6336KFlanders Steve L · Brea, CAS/N 15077650 N63375Pocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15077268 N63376Devaney Aviation Inc · Palm City, FLBuilt 1975 · S/N 15077269 N63384Sa Kim J · Hayward, CABuilt 1975 · S/N 15077274 N6338KBurchinal Sam F · Brookston, TXBuilt 1975 · S/N 15077652 N63395Reiman Jeffrey Scott · Chandler, AZBuilt 1975 · S/N 15077282 N63399Vogt Gerald J · Erie, PABuilt 1975 · S/N 15077284 N63401Evans Harold M · Dunnellon, FLBuilt 1975 · S/N 15077286 N63406Searfoss Robert L · Atlanta, GABuilt 1975 · S/N 15077290 N63407Mcguire Ryan · Redwood City, CABuilt 1975 · S/N 15077291 N63412Knh Aviation LLC · Yuma, AZBuilt 1975 · S/N 15077294 N63414Simonis Kenneth W · Girdwood, AKBuilt 1975 · S/N 15077296 N63418Knutson Wayne R · Tioga, NDBuilt 1975 · S/N 15077299

Back to Cessna 150M