Blairstown, NJ

Registered aircraft · 37

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 = 'NJ' AND g.registrant_city = 'BLAIRSTOWN'
  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.

N103GTBurkhart Grob Flugzeugbau TWIN ASTIR · S/N 3075Built 1978 · Aero Club AlbatrossN1118SSchweizer SGS 1-26E · S/N 508Built 1971 · Aero Club Albatross IncN1263Glasflugel H 301 LIBELLE · S/N 78Built 1968 · Browning JohnN126WESchweizer SGS 1-26E · S/N 680Built 1978 · Schwartz Ronald RN134TMSchweizer SGS 1-34 · S/N 80Built 1973 · Aero Club AlbatrossN1500NPiper J3C-65 · S/N 23031Built 1947 · Orlandi Properties LLCN168STBell 206B · S/N 2566Built 1977 · Motor Heads IncN1766HCessna 310C · S/N 35866Built 1959 · Orlandi Properties LLCN17867Schweizer SGS 2-33A · S/N 280Built 1973 · Aero Club AlbatrossN17933Schweizer SGS 1-26E · S/N 563Built 1973 · Jersey Ridge Soaring LLCN17950Schweizer SGS 1-26E · S/N 550Built 1972 · Aero Club AlbatrossN18AGBurkhart Grob G 103 TWIN II · S/N 3714Built 1982 · Jersey Ridge Soaring LLCN1943MCessna 210M · S/N 21061968Built 1977 · Benbrook Robert AN21TUPilatus B4-PC11 · S/N 133Built 1974 · Aero Club AlbatrossN26719Piper J3L-65 · S/N 4140Built 1940 · Orlandi Properties LLCN2767RSchweizer SGS 1-26A · S/N 234Built 1964 · Aero Club AlbatrossN2994HSchweizer SGS 1-26E · S/N 692Built 1979 · Aero Club AlbatrossN33983Schweizer SGS 2-33A · S/N 383Built 1975 · Jersey Ridge Soaring LLCN3YARolladen-Schneider LS 4A · S/N 4402Built 1984 · Aero Club AlbatrossN444YZCessna 172F · S/N 17253119Built 1965 · Blue Aero Group LLCN4686ZPiper PA-22-108 · S/N 22-8222Built 1961 · Macmoyle ScottN501JNHoward R Hinkelmann 2/3 SCALE EARLY BIRD · S/N 519BBuilt 2012 · Blue Aero Group LLCN52827Aerostar International RX 8 · S/N RX8-3339Skylands Ballooning LLCN5772SSchweizer SGS 2-32 · S/N 61Built 1968 · Jersey Ridge Soaring LLCN65804Schweizer SGS 2-33A · S/N 327Built 1974 · Aero Club AlbatrossN65976Schweizer SGS 2-33A · S/N 356Built 1974 · Jersey Ridge Soaring LLCN663SMGrumman American Avn. AA-5B · S/N AA5B0370Built 1976 · Macmoyle ScottN7040QCessna 172L · S/N 17260340Built 1971 · Orlandi Properties LLCN7047ZPiper PA-25-235 · S/N 25-2813Built 1964 · Jersey Ridge Soaring LLCN7308GCessna 172K · S/N 17259008Built 1970 · Orlandi Properties LLCN7380GCessna 172K · S/N 17259080Built 1970 · Orlandi Properties LLCN78066Cessna 172K · S/N 17257470Built 1968 · Orlandi Properties LLCN7833GCessna 172L · S/N 17259533Built 1970 · Orlandi Properties LLCN79826Mooney M20E · S/N 490Built 1964 · Martin Kevin JN9333KPiper PA-34-200T · S/N 34-7670198Built 1976 · Orlandi Properties LLCN98JTMooney M20M · S/N 27-0335Built 2005 · Mossip PaulN9982TCessna 182D · S/N 18253082Built 1960 · Aero Club Albatross
Back to Blairstown, NJ