OpenAirDocs.org
Brooklyn, NY

Registered aircraft · 107

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 = 'BROOKLYN'
  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.

N103JFEngineering & Research ERCOUPE 415-C · S/N 745Built 1946 · Judkovitz ShmuelN111MABeech E-55 · S/N TE-1170Aero Quest IncN1125PBenjamin Ellis RV-8 · S/N 84117Ellis BenjaminN1129LMooney M20TN · S/N 31-0078Built 2008 · Flyclem LLCN1168XPiper PA-28-180 · S/N 28-7505219Built 1975 · Jz Air LLCN1333HPiper PA-32R-300 · S/N 32R-7780154N1333h LLCN159BAIcon A5 · S/N 00076Michellcona5 LLCN177WDPauley Bruce S VANS RV-7A · S/N 72742Built 2010 · N177wd Leasing LLCN2117QCessna 177RG · S/N 177RG0517Built 1974 · Gately BrianN2222TPiper PA-28-181 · S/N 28-7890490Built 1978 · Dishman John DavidN222NFCessna 525A · S/N 525A-0074Built 2002 · Shelter Air Charter LLCN2347ZBeech 23 · S/N M-59Built 1962 · Zaitsev Saba AN26692Cessna 310R · S/N 310R1849Built 1979 · Fields Douglas P JrN269RBDiamond Aircraft Ind DA 40 · S/N 40.740Built 2006 · Romeo Bravo Holdings LLCN2779HSchweizer SGS 1-35C · S/N 59Built 1976 · Ludolph William KN27SJDiamond Aircraft Ind DA 42 · S/N 42.AC014Built 2006 · 0x1b LLCN2812NCessna 140 · S/N 13073Built 1947 · Cook-Berry TimothyN287JGBeech 35-C33 · S/N CD934Built 1965 · Gully John FN287VCPiper PA-28-236 · S/N 28-7911231Built 1979 · Great Sky LLCN28KWAmerican General Acft AG5B · S/N 10085Built 1991 · Grumman Girl LLCN2973KPiper PA-28-161 · S/N 28-8016007Crown Heights FootcareN298PMCostruzioni Aeronautiche Tecna P2008 · S/N 199Built 2021 · Goldair LLCN3000GForney F-1 · S/N 5692Built 1959 · Sheets Bruce EN3038UPiper PA-28-236 · S/N 28-7911124Built 1979 · Venbro Holdings LLCN32067Piper PA-28-151 · S/N 28-7515060Legeros DavidN323APPiper PA-31-350 · S/N 31-8252031Em Concordia IncN32AKCessna 182P · S/N 18261935Built 1973 · Hummel KarlN340MKCessna 340A · S/N 340A1541Built 1982 · Milbern Aircraft CorporationN341LXExtra Flugzeugproduktions-Und EA 300/LC · S/N LC041Built 2015 · Zulu Aeronautics & Aviation Consulting Group LLCN344LXMagnus FUSION 212 · S/N MG-11-017Built 2019 · Zulu Aeronautics And Aviation Consulting Group LLCN345EFCirrus Design SR20 · S/N 2731Built 2021 · Venbro Holdings LLCN35259Cessna 177B · S/N 17702293Built 1975 · Gately Brian PN373SMasengil Benjamin T LANCAIR 320 · S/N 1Built 1995 · Anderson ThomasN38168Beech A36 · S/N E-1808Built 1981 · Jjj&S Aviation CorpN4021JCessna 150G · S/N 15065321Built 1966 · Sharapan IlyaN4034XAero Commander 100-180 · S/N 5134Built 1970 · Privus IncN407DEBell Helicopter Textron Canada 407 · S/N 54389Built 2013 · Pamoin 407 LLCN407NYBell 407 · S/N 53061Built 1996 · New York City Police Aviation UnitN4361HMooney M20J · S/N 24-0720Built 1978 · Sazhin MichaelN447XLLewis John T SONEX · S/N 0447Built 2003 · Judkovitz ShmuelN4632PWindward Performance DUCK HAWK · S/N 001Sazhin DanielN468PMPiper PA-28R-200 · S/N 28R-7335041Built 1972 · Earspasm LLCN4692GCessna 172N · S/N 17273318Jz Air LLCN472CDCirrus Design SR22 · S/N 1197Built 2004 · Lorton Kenneth PatrickN47391Piper PA-28-161 · S/N 28-7816067Crown Heights Footcare PlcN4779HPiper PA-11 · S/N 11-725Built 1948 · Salant Evan PN4880FCessna 172N · S/N 17273095Built 1979 · Fkm Air Shuttle LLCN5034YSchlanzer/Drlik/Lawrie FALCON XP · S/N 002Wynkoop Brett EN5051UAerostar International S57H · S/N S57H-3002Built 2003 · Frackman DavidN505JHCessna 501 · S/N 501-0126Built 1979 · Qwirk Jet LLC
Back to Brooklyn, NY