Skip to content

Registered aircraft · 978

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

N17618Kloptenstein Kevin S · Parker, AZBuilt 1977 · S/N CE-696 N17632Hunt Elizabeth H · Clifton, TXBuilt 1977 · S/N CE-697 N17636Rocha Heriberto · Houston, TXBuilt 1977 · S/N CE-698 N17692Starnes Robert D · Suwanee, GAS/N CE-700 N17702Bosley Blake R · Richmond, TXBuilt 1977 · S/N CE-701 N17735Stoppelbein Colby · Kenansville, NCBuilt 1977 · S/N CE-703 N17738Lambert Michael C · San Jose, CABuilt 1977 · S/N CE-702 N17747Davis 180 LLC · Baton Rouge, LABuilt 1977 · S/N CE-704 N17791Spuza Dan D · Sanger, TXBuilt 1977 · S/N CE-708 N17802Asxo · Dallas, TXBuilt 1977 · S/N CE-709 N17818Batie Gregory T · Rogers, ARBuilt 1977 · S/N CE-710 N17829Slayden Wesley B · White Bluff, TNBuilt 1977 · S/N CE-712 N17846Stalford Tom G · Nicholson, PABuilt 1977 · S/N CE-714 N17852Flores Gustavo · Dallas, TXBuilt 1977 · S/N CE-715 N179MCFulton Rick D · Marble Falls, TXBuilt 1990 · S/N CE-1530 N17REFarina Richard H · Ashburn, VAS/N CE-1128 N1801MIrish Christopher J · Overland Park, KSBuilt 1981 · S/N CE-953 N1809LThomson Brian Trustee · Saugus, CABuilt 1976 · S/N CE-639 N1813WMarsh Galen E · Minot, NDS/N CE-413 N1813YWarren Clifton W · Camarillo, CABuilt 1981 · S/N CE-961 N181ACTwo Tall Tamaracks LLC · Ovando, MTBuilt 1980 · S/N CE-914 N181JPRegistered aircraftS/N CE-965 N18246Radial-Air Leasing Inc · Caro, MIBuilt 1977 · S/N CE-720 N18291Meoli Christopher J · Rancho Mirage, CABuilt 1977 · S/N CE-724 N18321Bravo Delta Aviation LLC · Sand Springs, OKBuilt 1977 · S/N CE-727 N1832SColwell Anthony R · Houston, TXBuilt 1981 · S/N CE-969 N18334Jones Marine Inc · Salisbury, NCBuilt 1977 · S/N CE-728 N1833DGeese Jeffrey L · Pray, MTBuilt 1981 · S/N CE-952 N1833LScrap Metal LLC · Mountainside, NJBuilt 1977 · S/N CE-721 N1833QItb 10721 LLC · Edmonds, WABuilt 1985 · S/N CE-1069 N1836ZBrown Farms Inc · Central City, NEBuilt 1981 · S/N CE-970 N18381Texas Aero Services 1 LLC · Frisco, TXBuilt 1977 · S/N CE-732 N18413Cook Brian D · La Vernia, TXBuilt 1977 · S/N CE-736 N1841WN1841w LLC · Plant City, FLBuilt 1973 · S/N CE-437 N18429Withers John Justin · Paris, TXS/N CE-937 N1842WNorthwoods Aviation · Marion, IAS/N CE-438 N18483F33a Holdings LLC · Woodbridge, VABuilt 1977 · S/N CE-735 N1849PDaedalus LLC · Bozeman, MTBuilt 1982 · S/N CE-974 N1849SOnedown LLC · Kalispell, MTBuilt 1981 · S/N CE-973 N184EHTen Hi Flyers Inc · Denver, COBuilt 1989 · S/N CE-1355 N1855S1855 Sierra LLC · Brighton, MIBuilt 1981 · S/N CE-980 N1856ZBromley Wayne B · Colwich, KSBuilt 1981 · S/N CE-977 N1858LAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N CE-646 N1859CHadley Aviation LLC · Kent, CTBuilt 1981 · S/N CE-986 N186RLN186rl LLC · Fortson, GABuilt 1993 · S/N CE-1748 N1872LFreeman Gary M · Richmond Hill, GABuilt 1976 · S/N CE-648 N1874LRegistration Pending · Dover, DERegistration pendingBuilt 1976 · S/N CE-649 N1876WHeadsets Incorporated · Amarillo, TXBuilt 1973 · S/N CE-443 N18AWayman Ian A · Medford, ORS/N CE-629 N18BEStarkey Thomas David · Nashville, TNBuilt 1977 · S/N CE-726

Back to Beech F33A