Skip to content

Turbomeca ASTAZOU IIIC2

Registered aircraft · 12

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('60088')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('60088')
ORDER BY 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.

N1433WVan Der Walt Inc · Oregon City, ORBuilt 1976 · S/N 1433 N334XZRegistered aircraftBuilt 1977 · S/N 1673 N341FNeue Kinetik LLC · Lexington, KYBuilt 1976 · S/N 1482 N341RDTres Hombres LLC · Missoula, MTBuilt 1976 · S/N 1501 N341XXJwc Holdings LLC · Lake Havasu City, AZBuilt 1972 · S/N 1267 N383GZExcel Power Ventures Inc · Wilmington, DEBuilt 1975 · S/N 1383 N497MMRegistered aircraftBuilt 1975 · S/N 1384 N544GZGazelle LLC · Cerrillos, NMBuilt 1976 · S/N 1544 N846XWRegistered aircraftBuilt 1973 · S/N 1009 N868GZLajk Inc · Wilmington, DEBuilt 1974 · S/N 1281 N981MHRegistered aircraftBuilt 1976 · S/N 1419 N98ZHBeaver Creek Adventures LLC · Bangor, MEBuilt 1976 · S/N 1518

Back to Turbomeca ASTAZOU IIIC2