OpenAirDocs.org
Middletown, NY

Registered aircraft · 34

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'NY' AND g.registrant_city = 'MIDDLETOWN'
  ORDER BY g.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.

N1172SSchweizer SGS 1-34 · S/N 72Built 1972 · Valley Soaring Club IncN1435Balony Kubicek Spol Sro BB30Z · S/N 1716Built 2020 · Above The Clouds IncN17924Schweizer SGS 1-26E · S/N 534Built 1972 · Valley Soaring Club IncN2385RHead Balloons AX7-77 · S/N 411Built 2011 · Palmer Arthur RN2459EAeronca 7AC · S/N 7AC-6037Built 1946 · Stopa GreggN2463WSchweizer SGS 2-33 · S/N 26Built 1967 · Valley Soaring Club IncN2538WBeech B24R · S/N MC-215Built 1974 · Beach Eric JN2556Kubicek Factory S R O BB70Z · S/N 2324Built 2024 · Above The Clouds IncN275APDJI AGRAS T40 · S/N 1581F574B226D00100EHPrecision Ag Drone Services LLCN276APDJI T50 · S/N 1581F6BUB246D0011XK4Precision Ag Drone Services LLCN2843NFlightstar IISL · S/N 109-46-D-6166Built 1997 · Estes William J IIIN3922PPiper PA-22-150 · S/N 22-3594Built 1955 · Moulton Robert PaulN4164EAeronca 11CC · S/N 11CC-67Built 1947 · Vitale Andrew RN474KSSchleicher ASK-21 · S/N 21197Built 1983 · Valley Soaring Club IncN5025KAerostar International RXS-8 · S/N RXS8-3120Built 2002 · Above The Clouds IncN550JBCessna 182P · S/N 18262671Built 1973 · Bowley John PN5594Kubicek Factory S R O BB51Z · S/N 1946Built 2022 · Above The Clouds IncN5787SSchweizer SGS 2-33A · S/N 116Built 1968 · Valley Soaring Club IncN6047ZPiper PA-25 · S/N 25-54Built 1959 · Valley Soaring ClubN60767Cessna 150J · S/N 15070561Built 1969 · Turnier Mikel WN6378QAerostar International RX 8 · S/N RX8-3141Built 1992 · Above The Clouds IncN70217Piper J3C-65 · S/N 17194Built 1946 · Stopa GreggN714TSLearjet 60 · S/N 340Built 2008 · Jet Connect LLCN7215FPiper PA-28-140 · S/N 28-25125Gailie Thomas EN735YCCessna 182Q · S/N 18265782Built 1977 · Lindsay Stephen JN7625Schweizer SGS 1-34 · S/N 5Built 1969 · Smart Ops Services LLCN7686Schweizer SGS 2-33A · S/N 171Built 1970 · Valley Soaring Club IncN799HGLiteflite PTY DRAGONFLY MODEL C · S/N 099Built 2007 · Estes William J IIIN82829Piper PA-28-236 · S/N 28-8111015Built 1980 · Wingin It 13 LLCN8787DPiper PA-18 · S/N 18-6324Ross ScottN89466Cessna 140 · S/N 8498Built 1946 · Stopa GreggN9001RHead Balloons AX8-88 · S/N 510Built 2023 · Palmer Arthur RN9560TCessna 210 · S/N 57360Stern Harvey WN96338Taylorcraft BC12-D · S/N 8638Built 1946 · Stover John J
Back to Middletown, NY