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