Skip to content

Registered aircraft · 303

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

N5898GIsaza Alvaro · Westminster, MDBuilt 1969 · S/N 15071398 N5903GRybarczyk Mathias M · Rice Lake, WIS/N 15071403 N5906GBennett Cass · Oxnard, CABuilt 1969 · S/N 15071406 N5908GRohrbough Nathan F · Weston, WVBuilt 1969 · S/N 15071408 N5913GFerguson Joe C · Shreveport, LABuilt 1969 · S/N 15071413 N5924GParsons Roderick L · Ripley, WVBuilt 1969 · S/N 15071424 N5926GMirandan5926g LLC · Napanoch, NYBuilt 1969 · S/N 15071426 N5931GOconnor Mary B · Anchorage, AKBuilt 1969 · S/N 15071431 N5932GBergen Henry E · Fond Du Lac, WIS/N 15071432 N5934GDevils Lake Aero Repair Inc · Devils Lake, NDS/N 15071434 N5935GDeaero LLC · Darwin, MNBuilt 1968 · S/N 15071435 N5937GD'Arge Ranyon Wc · Wilson, WYBuilt 1969 · S/N 15071437 N5939GMasek Ron J · Valley City, OHBuilt 1969 · S/N 15071439 N5942GGsell Bruce · Southampton, NJBuilt 1969 · S/N 15071442 N5947GGregorzewski Richard D · Jasper, ALS/N 15071447 N5951GWallace Grant R · Altoona, IABuilt 1969 · S/N 15071451 N5952GBradford III Properties LLC · Huntersville, NCBuilt 1969 · S/N 15071452 N5953GKibart Allan L · Eufaula, OKBuilt 1969 · S/N 15071453 N5955GHoughton Lawrence A · Rsm, CABuilt 1969 · S/N 15071455 N5961GSkypark Inc · Wadsworth, OHBuilt 1969 · S/N 15071461 N5962GVaught Andrew W · Long Beach, CABuilt 1969 · S/N 15071462 N5963GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071463 N5965GCavu Pilot LLC · Powell, TNS/N 15071465 N5970GOritz Benjamin Dale · Senoia, GABuilt 1969 · S/N 15071470 N5979GHargrave Michael K · Gladwin, MIBuilt 1969 · S/N 15071479 N5980GBall Albert N · Chugiak, AKBuilt 1969 · S/N 15071480 N5984GClifton Raymond L · Pleasanton, TXS/N 15071484 N5985GStanton Aviation Lc · Saint George, UTBuilt 1969 · S/N 15071485 N5992GPerry Aaron O · Piqua, OHS/N 15071492 N5993GSchoenrock Timothy · Stillman Valley, ILBuilt 1969 · S/N 15071493 N5996GRandle Jessica R · North Bend, ORBuilt 1969 · S/N 15071496 N5DTFive Delta Tango LLC · Tucson, AZBuilt 1970 · S/N 15071977 N6001GN6001g LLC · Wheeling, ILBuilt 1969 · S/N 15071501 N6004GLiberty University Aviation Dept · Lynchburg, VABuilt 1969 · S/N 15071504 N6005GCrockett Guy S · Louisville, KYBuilt 1969 · S/N 15071505 N6008GBernadt Aviation Inc · Steinauer, NEBuilt 1969 · S/N 15071508 N600SUFlying Aggies · Stillwater, OKBuilt 1969 · S/N 15071691 N6011GRose Michael · Buckingham, PABuilt 1969 · S/N 15071511 N6012GStepp Dave · Ruidoso, NMBuilt 1969 · S/N 15071512 N6015GDoctorian David S · Macon, MOS/N 15071515 N6016GWahl Gust K · Dillingham, AKBuilt 1969 · S/N 15071516 N6019GAgaliotis Paul E · San Martin, CABuilt 1969 · S/N 15071519 N601JRJumbo Gabrielle Inc · Wilmington, DEBuilt 1969 · S/N 15071513 N6020GBuckley Michael J · Billings, MTBuilt 1969 · S/N 15071520 N6025GBenitez Marlin A · Potomac, MDBuilt 1969 · S/N 15071525 N6028GVyatkin Denis · Sacramento, CABuilt 1969 · S/N 15071528 N6031GMorris Delbert A · Cashmere, WABuilt 1969 · S/N 15071531 N6045GWalls Sales LLC · Poplar Bluff, MOBuilt 1969 · S/N 15071545 N6050GNihan Gregory K · Hanson, MABuilt 1969 · S/N 15071550 N6053GKaeser Robert E · Lafayette, INBuilt 1969 · S/N 15071553

Back to Cessna 150K