Beechcraft SB 71-3142
Service difficulty reports that cite it · 6
Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.
Query with SQL
duckdb -csv -c "SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'beechcraft/sb-71-3142' AND c.record_type = 'faa_service_difficulty_report'
GROUP BY ALL
ORDER BY max(c.record_date) DESC"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 s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id WHERE c.document_id = 'beechcraft/sb-71-3142' AND c.record_type = 'faa_service_difficulty_report' GROUP BY ALL ORDER BY max(c.record_date) DESC
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.
SDR CA030327001Tube · Beech C90A(CAN) ENGINE INTAKE ANTI-ICE TUBES REPLACED AS PER BEECH SB 71-3142. NEW TUBES FOUND CRACKED AT SECOND INSPECTION AFTER SB COMPLIANCE.SDR CA030210001Tube · Beech C90A(CAN) LT INBOARD ANTI ICE TUBE FOUND CRACKED AT LOWER (COWL) ATTACH POINT .1 INCH FROM ANGLE FITTING. FLEX HOSE ASSY REPLACED WITH NEW PART. NOTE, RECENT INSTALATION IN COMPLIANCE WITH RAYTHEON S/B 71SDR CA021022003Tube · Beech C90A(CAN) ENGINE INLET ANTI-ICE TUBES REPLACED AS PER BEECH SB 71-3142. NEW TUBES FOUND CRACKED AT FIRST INSPECTION AFTER SB COMPLIANCE.SDR CA021030004Tube · Beech C90A(CAN) ENGINE INLET ANTI-ICE TUBES REPLACED AS PER BEECH SB 71-3142. NEW TUBES FOUND CRACKED AT FIRST INSPECTION AFTER SB COMPLIANCE.SDR CA020927002Tube · Beech C90A(CAN) ENGINE ANTI-ICE INTAKE TUBES REPLACED AS PER BEECH SB 71-3142, WERE FOUND CRACKED AT FIRST INSPECTION AFTER SB COMPLIANCE.SDR CA020927004Tube · Beech C90A(CAN) ENGINE ANTI-ICE INTAKE TUBES REPLACED AS PER BEECH SB 71-3142, WERE FOUND CRACKED (NOT SEPARATED) ATFIRST INSPECTION AFTER SB COMPLIANCE.
Back to Beechcraft SB 71-3142