Bingen, WA
Registered aircraft · 54
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 = 'WA' AND g.registrant_city = 'BINGEN' 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 = 'WA' AND g.registrant_city = 'BINGEN' 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.
N1001TInsitu INTEGRATOR · S/N 3-12-1001N104TNInsitu INTEGRATOR · S/N 3-12-1004N107TRInsitu INTEGRATOR · S/N 107N108TRInsitu INTEGRATOR · S/N 108N109SEInsitu SCANEAGLE · S/N 10-1209N109TRInsitu INTEGRATOR · S/N 3-18-0109N110UUInsitu INTEGRATOR · S/N 110N13NTInsitu INTEGRATOR · S/N 3-12-1003N209SEInsitu SCANEAGLE X-200 · S/N 11-1459N238SEInsitu SCANEAGLE X-200 · S/N 14-1916N256SEInsitu SCANEAGLE · S/N 17-2449N257SEInsitu SCANEAGLE · S/N 09-922N258SEInsitu SCANEAGLE · S/N 09-882N259SEInsitu SCANEAGLE · S/N 08-769N260SEInsitu SCANEAGLE · S/N 12-1506N262SEInsitu SCANEAGLE · S/N 16-2279N263SEInsitu SCANEAGLE · S/N 11-1321N264SEInsitu SCANEAGLE · S/N 12-1510N265SEInsitu SCANEAGLE · S/N 08-725N267SEInsitu SCANEAGLE · S/N 12-1635N268SEInsitu SCANEAGLE · S/N 16-2280N274SEInsitu SCANEAGLE · S/N 06-241N301LRInsitu FLARES 2 · S/N HTMC-0031N304FSInsitu FLARES 3 · S/N HTMC-0304N306FFInsitu FLARES 3 · S/N HTMC-306N306FRInsitu FLARES 2 · S/N HTMC-0036N311LEInsitu SCANEAGLE3 · S/N 4-20-0001N311NTInsitu INTEGRATOR · S/N 3-23-1311N312LEInsitu SCANEAGLE3 · S/N 4-20-0002N313LEInsitu SCANEAGLE3 · S/N 4-20-0003N314LEInsitu SCANEAGLE3 · S/N 4-20-0004N315LEInsitu SCANEAGLE3 · S/N 4-20-0005N328LEInsitu SCANEAGLE3 · S/N 4-21-0008N330LEInsitu SCANEAGLE3 · S/N 4-21-0010N3350AInsitu SCANEAGLE2 · S/N 3350N3351AInsitu SCANEAGLE2 · S/N 3351N340FSInsitu FLARES 2 · S/N HTMC-0034N341SNInsitu SCANEAGLE · S/N 11-1341N376SEInsitu SCANEAGLE · S/N 07-376N401FAInsitu FLARES 3 · S/N 400-0001N403FLInsitu FLARES 3 · S/N 400-0003N410XXInsitu SCANEAGLE3 · S/N 410N411YYInsitu SCANEAGLE3 · S/N 411N509SXMadaris Michael G SONEX · S/N 509N53015Insitu X-500 · S/N 5-23-0001N571SEInsitu SCANEAGLE · S/N 17-2571N643SEInsitu SCANEAGLE · S/N 18-2643N68NSInsitu INTEGRATOR · S/N 3-14-0068N70NSInsitu INTEGRATOR · S/N 70N73NTInsitu INTEGRATOR · S/N 3-24-1331
Back to Bingen, WA