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.
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
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.
N103GTBurkhart Grob Flugzeugbau TWIN ASTIR · S/N 3075N1118SSchweizer SGS 1-26E · S/N 508N1263Glasflugel H 301 LIBELLE · S/N 78N126WESchweizer SGS 1-26E · S/N 680N134TMSchweizer SGS 1-34 · S/N 80N1500NPiper J3C-65 · S/N 23031N168STBell 206B · S/N 2566N1766HCessna 310C · S/N 35866N17867Schweizer SGS 2-33A · S/N 280N17933Schweizer SGS 1-26E · S/N 563N17950Schweizer SGS 1-26E · S/N 550N18AGBurkhart Grob G 103 TWIN II · S/N 3714N1943MCessna 210M · S/N 21061968N21TUPilatus B4-PC11 · S/N 133N26719Piper J3L-65 · S/N 4140N2767RSchweizer SGS 1-26A · S/N 234N2994HSchweizer SGS 1-26E · S/N 692N33983Schweizer SGS 2-33A · S/N 383N3YARolladen-Schneider LS 4A · S/N 4402N444YZCessna 172F · S/N 17253119N4686ZPiper PA-22-108 · S/N 22-8222N501JNHoward R Hinkelmann 2/3 SCALE EARLY BIRD · S/N 519BN52827Aerostar International RX 8 · S/N RX8-3339N5772SSchweizer SGS 2-32 · S/N 61N65804Schweizer SGS 2-33A · S/N 327N65976Schweizer SGS 2-33A · S/N 356N663SMGrumman American Avn. AA-5B · S/N AA5B0370N7040QCessna 172L · S/N 17260340N7047ZPiper PA-25-235 · S/N 25-2813N7308GCessna 172K · S/N 17259008N7380GCessna 172K · S/N 17259080N78066Cessna 172K · S/N 17257470N7833GCessna 172L · S/N 17259533N79826Mooney M20E · S/N 490N9333KPiper PA-34-200T · S/N 34-7670198N98JTMooney M20M · S/N 27-0335N9982TCessna 182D · S/N 18253082
Back to Blairstown, NJ