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