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.

N18RBDuval Kenneth M · Richardson, TXBuilt 1973 · S/N CE-461 N1913LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N CE-656 N191BFKoziura Sebastian · Evanston, ILBuilt 1991 · S/N CE-1577 N191CCCarter Cleveland M · Willacoochee, GABuilt 1972 · S/N CE-399 N1928TWalters Jonathan · Malvern, OHBuilt 1990 · S/N CE-1533 N1932NChubb Stanley C · Mason, MIBuilt 1973 · S/N CE-417 N194ABennett Jay D · Indian Harbour Bch, FLBuilt 1990 · S/N CE-1465 N1978SWatson Jeffry T · Colorado Springs, COBuilt 1976 · S/N CE-640 N197FMGainey Mark P · San Antonio, TXBuilt 1987 · S/N CE-1131 N19REEtcheverry Ray L · Bakersfield, CABuilt 1970 · S/N CE-299 N1DJOwyhee Air LLC · Murphy, IDBuilt 1987 · S/N CE-1116 N1PHRegistered aircraftBuilt 1983 · S/N CE-1018 N200AFInternational Air Services Inc Trustee · Carson City, NVS/N CE-1578 N200GDBowen Watson K · Abilene, TXBuilt 1988 · S/N CE-1264 N200JFAustin Steven G · Tigard, ORBuilt 1990 · S/N CE-1516 N200QBluth Marshall S · Great Neck, NYBuilt 1971 · S/N CE-339 N2015T2015t LLC · Omaha, NEBuilt 1978 · S/N CE-795 N2019KBridges Benjamin D · Thomaston, GABuilt 1978 · S/N CE-796 N2020AComeaux Christopher E · Robeline, LABuilt 1978 · S/N CE-799 N20234Emaw Properties LLC · Ketchum, OKBuilt 1978 · S/N CE-801 N2023LStearns Ramsey Aviation LLC · Brooten, MNBuilt 1978 · S/N CE-802 N2024ANew Heights Aviation LLC · Waxhaw, NCFirst renewal noticeBuilt 1978 · S/N CE-804 N2031RRons Air Service Inc · Two Buttes, COS/N CE-811 N2033LYoung Randolph F · Martinsburg, WVBuilt 1978 · S/N CE-808 N2033ZHogarth De La Plante John Rammacher · Snohomish, WABuilt 1978 · S/N CE-810 N2037LSchryer Timothy B · Satsuma, ALBuilt 1978 · S/N CE-817 N2037NHoward Robert L · Jacksonville, NCBuilt 1978 · S/N CE-813 N2038NAnken Frederick W · Holland Patent, NYBuilt 1978 · S/N CE-818 N2038XMilam Douglas Franklin · Red Creek, WVBuilt 1978 · S/N CE-819 N2041PManke Brian W · Chesapeake, VABuilt 1978 · S/N CE-821 N20444Cesafsky Allen A · Bend, ORBuilt 1978 · S/N CE-824 N2046WKj Cessna LLC · Waxahachie, TXBuilt 1978 · S/N CE-825 N2048ZJulis Wings LLC · Jacksonville, FLBuilt 1978 · S/N CE-828 N204LPSteffenhagen Julian L Jr Trustee · Tustin, CABuilt 1988 · S/N CE-1262 N2050YSomerville Elizabeth M · West Dennis, MABuilt 1978 · S/N CE-826 N2063CKhumbu Flying Club · Wilmington, DEBuilt 1979 · S/N CE-838 N206CWAgri Med LLC · Belgrade, MTBuilt 1978 · S/N CE-836 N206GPAdaptive Aero Inc · Wilmington, DEBuilt 1978 · S/N CE-754 N2086LMortensen Daniel R Trustee · Newhall, CABuilt 1976 · S/N CE-658 N211VHull Robert Abbott · Payson, AZBuilt 1993 · S/N CE-1754 N2133WBeck Robert M · Bakersfield, CABuilt 1974 · S/N CE-502 N2137LPcb Air 2 LLC · West Palm Beach, FLBuilt 1976 · S/N CE-662 N215PDube William E Jr · Prescott, AZBuilt 1992 · S/N CE-1676 N2173LPritchard Timothy L · Fargo, NDBuilt 1976 · S/N CE-666 N217PDanford Air Inc · Wilmington, DEBuilt 1979 · S/N CE-839 N2203LForni Robert · Spring Grove, ILBuilt 1976 · S/N CE-669 N22099Falwell James C · Beaufort, NCBuilt 1978 · S/N CE-749 N221VRSperling Arnold L · Lincoln, MAS/N CE-1105 N221WSChaz LLC · Wilmington, DEBuilt 1976 · S/N CE-642 N222FNRegistered aircraftBuilt 1985 · S/N CE-1075

Back to Beech F33A