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.

Lycoming AEIO-360-B1B2 registered aircraftEngine modelLycoming AEIO-360-B1H2 registered aircraftEngine modelLycoming HIO-360-B1B2 registered aircraftEngine modelLycoming HIO-540-A1A2 registered aircraftEngine modelLycoming IO-320-A1A2 registered aircraftEngine modelLycoming IO-320-B1C2 registered aircraftEngine modelLycoming IO-360-A2B2 registered aircraftEngine modelLycoming IO-360-B1D2 registered aircraftEngine modelLycoming IO-360-C1F2 registered aircraftEngine modelLycoming IO-540-K1F52 registered aircraftEngine modelLycoming IO-540-K1H52 registered aircraftEngine modelLycoming IO-540-M1B5D2 registered aircraftEngine modelLycoming IO-540-M1C52 registered aircraftEngine modelLycoming TIO-540-AA1AD2 registered aircraftEngine modelLycoming TIO-540-V2AD2 registered aircraftEngine modelContinental LTSIO-360-E1 registered aircraftEngine modelContinental LTSIO-360-KB1 registered aircraftEngine modelContinental TSIO-360-HB1 registered aircraftEngine modelContinental TSIO-360-SB1 registered aircraftEngine modelLycoming AEIO-360-A1B1 registered aircraftEngine modelLycoming AEIO-360-A2C1 registered aircraftEngine modelLycoming HIO-360-C1B1 registered aircraftEngine modelLycoming IO-320-B2A1 registered aircraftEngine modelLycoming IO-360-A3D6D1 registered aircraftEngine modelLycoming IO-360-B2F1 registered aircraftEngine modelLycoming IO-540-C2C1 registered aircraftEngine modelLycoming IO-540-D4C51 registered aircraftEngine modelLycoming IO-540-K1C51 registered aircraftEngine modelLycoming IO-540-L1A51 registered aircraftEngine modelLycoming IO-540-R1A51 registered aircraftEngine modelLycoming IO-580-A1A1 registered aircraftEngine modelLycoming LIO-320-C1A1 registered aircraftEngine modelLycoming LTIO-540-F2BD1 registered aircraftEngine modelLycoming TIO-540-AB1BD1 registered aircraftEngine modelLycoming TIO-540-AG1A1 registered aircraftEngine modelLycoming TIO-540-K1AD1 registered aircraftEngine modelLycoming TIO-540-R2AD1 registered aircraftEngine modelContinental LTSIO-360-RB0 registered aircraftEngine modelContinental TSIO-360-AB0 registered aircraftEngine modelContinental TSIO-360-B0 registered aircraftEngine modelContinental TSIO-360-BB0 registered aircraftEngine modelContinental TSIO-360-D0 registered aircraftEngine modelContinental TSIO-360-DB0 registered aircraftEngine modelContinental TSIO-360-F0 registered aircraftEngine modelContinental TSIO-360-JB0 registered aircraftEngine modelContinental TSIO-360-NB0 registered aircraftEngine modelContinental TSIO-360-PB0 registered aircraftEngine modelLycoming AEIO-320-D2B0 registered aircraftEngine modelLycoming AEIO-320-E1A0 registered aircraftEngine modelLycoming AEIO-320-E2A0 registered aircraftEngine model
Back to SAIB NE-09-04