Skip to content

Registered aircraft · 52

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

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_name = 'INSITU INC' OR list_contains(g.other_registrant_names, 'INSITU INC') ORDER BY g.n_number

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

Back to Insitu Inc