Tunkhannock, PA
Registered aircraft · 33
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 = 'PA' AND g.registrant_city = 'TUNKHANNOCK' 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 = 'PA' AND g.registrant_city = 'TUNKHANNOCK' 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.
N110WGBell Helicopter Textron 206B · S/N 2367N13XRAlpha M Scientific SL-A · S/N 01004N13XTChristopher K Murley ACROSPORT 2S · S/N SM120N305SNCessna Ector 305A · S/N 2038N3283BPiper PA-20 · S/N 20-1096N3291ECessna 172N · S/N 17271493N3519NPiper J3C-65 · S/N 22749N4457PPiper PA-23-160 · S/N 23-1974N4588MPiper PA-11 · S/N 1191N4670HPiper PA-15 · S/N 15-372N46KWStinson VULTEE V-77 · S/N 77-23N47303Stinson SR-10J · S/N 5942N47JQJaquish O W/Jaquish W E SH IIS · S/N 2109N550MGCessna U206G · S/N U20606173N5702ZPiper PA-22-108 · S/N 22-9540N5913Stinson SR-10J · S/N C3-5911N608XFly Baby 1-A · S/N 63-38N6098DCessna 172N · S/N 17272602N6681PPiper PA-24-250 · S/N 24-1805N7315DPiper PA-22-150 · S/N 22-5103N7506NSchweizer 269C · S/N S1305N7540DPiper PA-22-150 · S/N 22-5270N8062DPiper PA-22-150 · S/N 22-5585N8068ENavion NAVION A · S/N NAV-4-1650N8196XCessna 172B · S/N 17248696N8368XCessna 172C · S/N 17248868N8573KStinson 108-1 · S/N 108-1573N91465Rosengrant Russell W SKYBOLT · S/N 01N919ZWarmkessel KORNS CAPER · S/N LPK-1N92PSCessna 421B · S/N 421B0134N963KABeech E-90 · S/N LW242N97746Universal Stinson 108-1 · S/N 108-746N98652Cessna 172P · S/N 17276329
Back to Tunkhannock, PA