SAIB NE-09-04

Registry models it may concern · 276

Registry airframe and engine models matched to the bulletin’s products the same way as ADs, most registered aircraft first.

Query with SQL
duckdb -csv -c "-- One row per registry model code; the page joins codes that share a name
  SELECT 'aircraft' AS kind, m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
  WHERE m.code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_saib.parquet' WHERE saib_id = '1B24525E9C6ECE6E8625753C00497FF9')
  GROUP BY ALL
  UNION ALL
  SELECT 'engine' AS kind, m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
  FROM 'https://openairdocs.org/data/latest/faa_engine_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.engine_model_code = m.code
  WHERE m.code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_saib.parquet' WHERE saib_id = '1B24525E9C6ECE6E8625753C00497FF9')
  GROUP BY ALL
  ORDER BY aircraft DESC, code"

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.

Continental TSIO-360-C6 registered aircraftEngine modelContinental TSIO-360-E6 registered aircraftEngine modelLycoming AEIO-320-E1B6 registered aircraftEngine modelLycoming AEIO-320-E2B6 registered aircraftEngine modelLycoming HIO-360-C1A6 registered aircraftEngine modelLycoming IO-320-D1B6 registered aircraftEngine modelLycoming IO-360-B1C6 registered aircraftEngine modelLycoming LIO-360-C1E66 registered aircraftEngine modelLycoming TIO-540-A2C6 registered aircraftEngine modelLycoming TIO-540-J2B6 registered aircraftEngine modelSuperior IO-320 series6 registered aircraftEngine modelLycoming AEIO-360-B4A5 registered aircraftEngine modelLycoming HIO-360-A1A5 registered aircraftEngine modelLycoming IO-360-A3B65 registered aircraftEngine modelLycoming IO-540-K1E55 registered aircraftEngine modelLycoming LTIO-540-J2BD5 registered aircraftEngine modelLycoming TIO-540-A1A5 registered aircraftEngine modelContinental LTSIO-360-EB4 registered aircraftEngine modelContinental TSIO-360-CB4 registered aircraftEngine modelLycoming AEIO-360-B1F4 registered aircraftEngine modelLycoming IO-320-E2B4 registered aircraftEngine modelLycoming IO-360-D1A4 registered aircraftEngine modelLycoming IO-540-B1A54 registered aircraftEngine modelLycoming IO-540-E1A54 registered aircraftEngine modelLycoming IO-540-E1B54 registered aircraftEngine modelLycoming IO-540-L1B5D4 registered aircraftEngine modelLycoming IO-540-P1A54 registered aircraftEngine modelLycoming IO-540-T4A5D4 registered aircraftEngine modelLycoming TIO-540-A2B4 registered aircraftEngine modelLycoming TIO-540-F2BD4 registered aircraftEngine modelContinental TSIO-360-A3 registered aircraftEngine modelLycoming AEIO-360-A1A3 registered aircraftEngine modelLycoming AEIO-540-D4B53 registered aircraftEngine modelLycoming HIO-360-E1BD3 registered aircraftEngine modelLycoming IO-320-E1A3 registered aircraftEngine modelLycoming IO-320-E1B3 registered aircraftEngine modelLycoming IO-360-A1D6D3 registered aircraftEngine modelLycoming IO-360-B1F63 registered aircraftEngine modelLycoming IO-360-B2E3 registered aircraftEngine modelLycoming IO-360-C1G63 registered aircraftEngine modelLycoming IO-360-E1A3 registered aircraftEngine modelLycoming IO-360-F1A3 registered aircraftEngine modelLycoming IO-540-G1B53 registered aircraftEngine modelLycoming IO-540-G1C53 registered aircraftEngine modelLycoming IO-540-K1A5D3 registered aircraftEngine modelLycoming TIO-540-AF1A3 registered aircraftEngine modelLycoming TIO-540-U2A3 registered aircraftEngine modelContinental TSIO-360-H2 registered aircraftEngine modelLycoming AEIO-320-D1B2 registered aircraftEngine modelLycoming AEIO-360-A1E62 registered aircraftEngine model
Back to SAIB NE-09-04