Skip to content

Registered aircraft · 113

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

N38025Missaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1980 · S/N WA-198 N38026Terra Scott M · Vacaville, CABuilt 1980 · S/N WA-202 N38054Burr William L Jr · Johns Creek, GABuilt 1980 · S/N WA-201 N38062Marquez Naoko Quena · Henderson, NVBuilt 1980 · S/N WA-204 N3807KFaucette Micro Systems Inc · Fallon, NVS/N WA-200 N38086Autumn Crocus LLC · Cincinnati, OHS/N WA-210 N3809UMartus Michael · Russellville, OHBuilt 1980 · S/N WA-211 N3809YShaffer Kent R · Sour Lake, TXBuilt 1980 · S/N WA-212 N3809ZHelm Charles M · Darlington, WIBuilt 1980 · S/N WA-213 N3812QN3812q LLC · San Diego, CABuilt 1981 · S/N WA-214 N3812UBasquit Kenneth H · Pittsburgh, PABuilt 1980 · S/N WA-215 N3818ZRigney Mark E · Ponca City, OKBuilt 1981 · S/N WA-225 N38384Baisden James Brett · Manassas, VABuilt 1981 · S/N WA-231 N38397Registered aircraftS/N WA-232 N38462Krystofiak Steven · Scottsdale, AZBuilt 1981 · S/N WA-244 N3846UKrystofiak Steven · Scottsdale, AZS/N WA-242 N3851ZPurcell Jmes Patrick III · Bayville, NJBuilt 1981 · S/N WA-241 N3857DGill Michael T · Little Rock, ARS/N WA-248 N3860BFlight Club LLC · Middle River, MDS/N WA-273 N38644Harper Benjamin F III · Greensboro, ALS/N WA-275 N3868JParker Fred E · Portola, CABuilt 1981 · S/N WA-258 N3868KBeaver Mark · Valparaiso, INBuilt 1981 · S/N WA-259 N3870UJsn Aviation LLC · Huntersville, NCBuilt 1981 · S/N WA-260 N400RLJacobsson Charles A · San Gabriel, CAS/N WA-104 N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311 N577FCFlight Club · Middle River, MDS/N WA-43 N6001KAllred Warren D · Marshfield, MOBuilt 1979 · S/N WA-25 N6007FMobley Barbara Alice · Kathleen, GABuilt 1979 · S/N WA-4 N6007TMinton Richard D · Longville, LABuilt 1979 · S/N WA-5 N60199Krystofiak Steven · Scottsdale, AZBuilt 1979 · S/N WA-12 N6043YFreeman Eugene P · Paducah, KYBuilt 1979 · S/N WA-16 N610WMWilber Christian B · Waukesha, WIS/N WA-64 N66301Guidry David Brian · Lake Charles, LABuilt 1979 · S/N WA-29 N6630TRoberts Joshua E · Pike Road, ALBuilt 1980 · S/N WA-107 N6637RSchawang Darrin E · Falls City, NES/N WA-35 N6638LNewby Danny A · Mc Leansville, NCBuilt 1979 · S/N WA-37 N6707MLouis & Clark Aviation LLC · Fort Myers, FLBuilt 1979 · S/N WA-48 N6708XBaumbach James P · Lodi, CABuilt 1979 · S/N WA-53 N6709LBowlin Frank J · Santa Fe, NMBuilt 1979 · S/N WA-56 N6711RAme Flight Holdings LLC · Oasis, IDBuilt 1979 · S/N WA-60 N6713VMclendon Donnie E · Winder, GABuilt 1979 · S/N WA-61 N6715VByrds Wholesale Inc · Clayton, NCS/N WA-70 N6715YTrevitue LLC · Dripping Springs, TXS/N WA-65 N67169Arai Eisuke · San Jose, CABuilt 1979 · S/N WA-67 N6716SShelby Monroe Group LLC · Sioux City, IABuilt 1979 · S/N WA-71 N6718RVernier Deborah J · Goshen, KYBuilt 1980 · S/N WA-76 N6719VDaniel Scott · Kingston, GABuilt 1980 · S/N WA-81 N67201Sale Reported · Sunman, INSale reportedBuilt 1980 · S/N WA-111 N67217Pompano Hangars Inc · Lighthouse Point, FLBuilt 1980 · S/N WA-91 N6721VNoll Brent M · Burbank, CABuilt 1980 · S/N WA-89

Back to Beech 77