Skip to content

Registered aircraft · 166

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

N14TXMcbride Robert W Jr · Mineola, TXBuilt 1963 · S/N 15060031 N150CPrincess North Inc · Lindstrom, MNS/N 15059959 N150LGFredette Michael Richard · Queen Creek, AZBuilt 1963 · S/N 15059958 N151PZMarvin Neil · Seattle, WABuilt 1962 · S/N 15059719 N169WCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1963 · S/N 15060082 N170JSDocjosh Ltd LLC · Essex, NYBuilt 1962 · S/N 15059706 N1902Z1st Stop Aviation Services And Consulting LLC · Tulsa, OKS/N 15059702 N1903ZBuzby Justin T · Wasilla, AKBuilt 1962 · S/N 15059703 N1904ZNorman John W · Burlington, WABuilt 1962 · S/N 15059704 N1907ZMontcalm Aviation LLC · Coral, MIBuilt 1962 · S/N 15059707 N1909ZGecy Robert G · Simpsonville, SCS/N 15059709 N1914ZKalember John L · Rimrock, AZBuilt 1962 · S/N 15059714 N1915ZGruskin Zachary Q · West Bloomfield, MIBuilt 1962 · S/N 15059715 N1918ZHay Darrell B · Snohomish, WAS/N 15059718 N1920ZRockwell Raymond H · Atlanta, INBuilt 1962 · S/N 15059720 N1923ZLutz Kristi A · Seville, OHBuilt 1962 · S/N 15059723 N1925ZButenhoff Harold M · Leonard, NDBuilt 1962 · S/N 15059725 N1926ZBeville Robert M · Newberry, FLBuilt 1962 · S/N 15059726 N1927ZBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 15059727 N1928ZRegistration Pending · Sunbury, PARegistration pendingBuilt 1963 · S/N 15059728 N1929ZKotter Julie B · Metropolis, ILS/N 15059729 N1931ZCrandell Cyrus · Rockville, INBuilt 1962 · S/N 15059731 N1933ZIsherwood Robert N · Carnesville, GABuilt 1962 · S/N 15059733 N1934ZKlausen Mark R · Overland Park, KSBuilt 1962 · S/N 15059734 N1935ZHubbert Leroy N · Mecosta, MIS/N 15059735 N1938ZSuffern Glenn · Shady Shores, TXS/N 15059738 N1939ZBrooks James R · Oak Grove, MOBuilt 1962 · S/N 15059739 N1943ZBeauford Bryan Tyler · Anderson, MOBuilt 1962 · S/N 15059743 N1944ZHauser Linda L · Ulysses, KSBuilt 1962 · S/N 15059744 N1950ZStafford Branson T · Maple Hill, NCS/N 15059750 N1951ZAnderson Zachery D · Bigfork, MTBuilt 1962 · S/N 15059751 N1953ZHigginbotham Laura · Woodbine, GABuilt 1962 · S/N 15059753 N195GSFairfield Eugene D · Wiscasset, MEBuilt 1962 · S/N 15059755 N1963ZMarker Nathan E · Amherst, OHS/N 15059760 N1964ZGreene John P · Yuba City, CABuilt 1962 · S/N 15059764 N1968ZDuffel Christopher · Bellevue, WABuilt 1962 · S/N 15059768 N1971ZKrebs Keith C · Fort Worth, TXBuilt 1962 · S/N 15059771 N1973ZFinnelly Daniel T · Pasco, WAS/N 15059773 N1978ZCarleton Caleb C · Palmer, AKBuilt 1962 · S/N 15059778 N1979ZBebo Michael R · Kapolei, HIBuilt 1962 · S/N 15059779 N1982ZBosch Kent D · Montevideo, MNBuilt 1962 · S/N 15059782 N1985ZLemke Kerry A · Healy, AKBuilt 1962 · S/N 15059785 N1987ZN1987z LLC · Jordan, NYBuilt 1962 · S/N 15059787 N1988ZMessner Mark R · Chesapeake, OHBuilt 1963 · S/N 15059788 N1989ZBehnke James R · Fort Collins, COBuilt 1962 · S/N 15059789 N1994ZGoldberg Marc Fred · Chandler, AZS/N 15059794 N1996ZEvans Christopher L · Summerville, SCBuilt 1962 · S/N 15059796 N1998ZMilhous Richard J · Aguila, AZS/N 15059798 N2000ZLemrow Thomas R Jr · Saint Augustine, FLS/N 15059800 N2003ZBehnken Paul · Sedgwick, MEBuilt 1963 · S/N 15059803

Back to Cessna 150C