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.

N5861ETeets Trent D · West Fargo, NDS/N 17361 N5863EAj Financial LLC · Sachse, TXS/N 17363 N5866EUrban Performance · Newark, OHBuilt 1959 · S/N 17366 N5869EWells Dave · Nampa, IDBuilt 1959 · S/N 17369 N5876EFoster Garry R · Advance, NCBuilt 1959 · S/N 17376 N5879EDrennan Monte Dean · Caddo, OKBuilt 1959 · S/N 17379 N5883EHowser Kevin E · Fort Ashby, WVBuilt 1959 · S/N 17383 N5885EZeller Bruce C · Shelton, WAS/N 17385 N5893EWafer James R · Buellton, CABuilt 1959 · S/N 17393 N5896EKyle James H · Snohomish, WABuilt 1959 · S/N 17396 N5900EGreene Charles A · Easley, SCBuilt 1959 · S/N 17400 N5902TMaglaughlin Ronald D · Udall, KSS/N 15060602 N5908EEncarnacion Rosario Joel Alberto · Norwalk, CTBuilt 1959 · S/N 17408 N5911EOne Fiddy LLC · Bellingham, WAS/N 17411 N5912ERobinson Brayden K · Palmer, AKBuilt 1959 · S/N 17412 N59150Jp Aero Holdings Inc · Carson City, NVBuilt 1959 · S/N 17265 N5916EBetz Albert N Jr · Lewiston, IDBuilt 1959 · S/N 17416 N5917EKing Davids Heart · Henderson, NVBuilt 1959 · S/N 17417 N5919EBeaty David L · Mesa, AZBuilt 1959 · S/N 17419 N5924ENowlin Edwin H III · Oakboro, NCBuilt 1959 · S/N 17424 N5926ERegistration Pending · Marble Falls, TXRegistration pendingBuilt 1959 · S/N 17426 N5929EAnderson Raymond O · Bismarck, NDBuilt 1959 · S/N 17429 N5932ELockwood Shawn O · Volborg, MTBuilt 1959 · S/N 17432 N5933EForsha Scott A · Cypress, TXBuilt 1959 · S/N 17433 N5936EJensenius Danial P · Ray Twp, MIBuilt 1959 · S/N 17436 N5940EHorton Bill · Derby, KSBuilt 1959 · S/N 17440 N5941ERoxbury Public Schools · Succasunna, NJBuilt 1959 · S/N 17441 N5945EBaby 80 LLC · Chandler, AZBuilt 1959 · S/N 17445 N5947ESwenson Roger A · Pahrump, NVS/N 17447 N5957ESingleton Bruce W · Grafton, OHBuilt 1959 · S/N 17457 N5958EClover Park Technical College · Tacoma, WABuilt 1959 · S/N 17458 N5959ETrotter Patrick J · North Las Vegas, NVBuilt 1959 · S/N 17459 N5960EPuryear John S · Graham, TXBuilt 1959 · S/N 17460 N5962EWagar Dennis Murphy · Marion, MTS/N 17462 N5966EHowe Allen R · Waterloo, WIS/N 17466 N5967ERegistration Pending · Winter Haven, FLRegistration pendingBuilt 1959 · S/N 17467 N5969EFithian Michel · Putnam Valley, NYBuilt 1959 · S/N 17469 N5970EKolodziejczak Benjamin D · Orchard Park, NYBuilt 1959 · S/N 17470 N5972ESutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 17472 N5973EKcantarano LLC · Mukilteo, WABuilt 1959 · S/N 17473 N5974EHunt Ellwood M · Texarkana, TXS/N 17474 N5975EFoley Charles E · Poland, MEBuilt 1959 · S/N 17475 N5979ELamarca Kenneth M · Jonesboro, GABuilt 1959 · S/N 17479 N5980EHarris Kenneth L · Greeley, COS/N 17480 N5981ENelson David F · Onalaska, WAS/N 17481 N5982EAblaihan Inc · Angels Camp, CABuilt 1959 · S/N 17482 N5985EAlderman Melvin R · Jacksonville, FLBuilt 1959 · S/N 17485 N5989ESchiller Gregory L · Pittsburg, NHBuilt 1959 · S/N 17489 N5991EWilliford Travis C · Sandersville, GAS/N 17491 N5994EMccallister Shawn D · Hendersonville, NCBuilt 1959 · S/N 17494

Back to Cessna 150