Skip to content

Registered aircraft · 659

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

N50747N50747 LLC · Great Falls, MTBuilt 1968 · S/N 15069526 N50748Freeman Teresa L · Kinston, OHBuilt 1968 · S/N 15069527 N50749Blackwater Aviation LLC · Douglas, GABuilt 1968 · S/N 15069528 N50750Fly Chattanooga LLC · Ooltewah, TNBuilt 1968 · S/N 15069529 N50759Thode Leonard E · Michigan City, INBuilt 1968 · S/N 15069533 N50766Sheets Laura J · Follett, TXBuilt 1968 · S/N 15069539 N50769Miller Justin · Boaz, ALBuilt 1968 · S/N 15069540 N50774White T William · Londonderry, NHBuilt 1968 · S/N 15069543 N50777Morlan Scott A · Indianola, IABuilt 1968 · S/N 15069546 N50781Beard Michael E · Udall, KSBuilt 1968 · S/N 15069549 N50790Taylor Terry D · Orange Park, FLBuilt 1968 · S/N 15069556 N50793Matter In Motion Inc · Fox River Grove, ILBuilt 1968 · S/N 15069558 N50799Jungren Brett F · Elmwood, NEBuilt 1968 · S/N 15069560 N50805Dale Aero LLC · Eloy, AZBuilt 1968 · S/N 15069564 N50813Record John W · Apison, TNS/N 15069568 N50816Dingee Robert G · Clarks Summit, PABuilt 1968 · S/N 15069571 N50818Bradley Hayden Ace · Litchfield Park, AZBuilt 1968 · S/N 15069572 N50819Registered aircraftBuilt 1968 · S/N 15069573 N50832Whalen John F Jr · West Ossipee, NHS/N 15069584 N50835Henson Chad Cox · Galivants Ferry, SCBuilt 1968 · S/N 15069585 N50836Leeper Miles F · Douglass, KSBuilt 1968 · S/N 15069586 N50837N50837 LLC · Kaneohe, HIBuilt 1968 · S/N 15069587 N50840Dahlgren John W · Little Egg Harbor, NJBuilt 1968 · S/N 15069588 N50844Ellenson Conroy N · Browns Valley, CABuilt 1968 · S/N 15069590 N50846Jackson Bob · Bay City, TXS/N 15069592 N50850Knutson Wayne R · Tioga, NDBuilt 1968 · S/N 15069596 N50854Fulton Lanny G · Spartanburg, SCBuilt 1968 · S/N 15069600 N50865Smith Leslie A · Waresboro, GAFirst renewal noticeBuilt 1968 · S/N 15069606 N50868Krekacs Gabor · La Crescenta, CABuilt 1968 · S/N 15069608 N50871Saint Joseph Of Cupertino Shenandoah Flying Assoc · Winchester, VABuilt 1968 · S/N 15069610 N50874Priddle Linda Ann · Carlsborg, WABuilt 1968 · S/N 15069613 N50875Krs Aerial Inc · Plain City, OHS/N 15069614 N50876Parker David A · Sacramento, CAS/N 15069615 N50887Stanton Sport Aviation Inc · Stanton, MNBuilt 1968 · S/N 15069620 N50891Peterson Andrew B · Louisville, KYBuilt 1968 · S/N 15069623 N50896Bankhead David B · Montrose, WVBuilt 1968 · S/N 15069625 N50898Costa Air Service LLC · Painted Post, NYS/N 15069626 N50904Karges Kip · Tuscola, TXBuilt 1968 · S/N 15069631 N50909Keystone Aviation Group LLC · Paxinos, PABuilt 1968 · S/N 15069634 N50911Graves Robert E · Danville, INBuilt 1968 · S/N 15069636 N50914Calhoun John R · Baton Rouge, LABuilt 1968 · S/N 15069638 N50915Donato Robert J · East Berlin, PABuilt 1968 · S/N 15069639 N50920Campbell James R · Temple City, CABuilt 1968 · S/N 15069643 N50921Hernandez Jesus C · Elberton, GABuilt 1968 · S/N 15069644 N50936Qualitair LLC Trustee · MichelstadtS/N 15069656 N50948Salomonsson Mats E · Hayward, CABuilt 1968 · S/N 15069668 N50957Anklam Eugene E · Claremore, OKS/N 15069673 N50960Ortiz Tech LLC · Doral, FLBuilt 1968 · S/N 15069675 N50984Roberts Wayne A Jr · Juneau, AKBuilt 1968 · S/N 15069687 N50987Berg James O · Dunseith, NDBuilt 1968 · S/N 15069690

Back to Cessna 150J