Boeing SB 747-53-2283
Service difficulty reports that cite it · 10
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 = 'boeing/sb-747-53-2283' 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 = 'boeing/sb-747-53-2283' 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 UPS04443083Strap · Boeing 747212BINSPECTION TYPE: C, FX- BS 1241 LEFT WL 174-170 BETWEEN FX EXTERNAL INTERNAL LONGERON AREA FITTING ATTACH SPLICE STRAP FOUND CORROSION AS MARKED. CORROSION BLEND OUT WITH REMAIN THICKNESS 0.100 INCH RSDR UPS04442046Strap · Boeing 747SR46INSPECTION TYPE: C, REF EO B747-5310-1093M LEFT BS 1241 FWD HOLE FOUND A BUSHING IN BULKHEAD FORGING. LEFT BS 1241 FWD HOLE FORGING OLD BUSHING REMOVED. HFEC INSPECTED, RESULT NO CRACK FOUND. BUSHING SDR UPS02439732Forging · Boeing 747SR46INSPECTION TYPE: C CORROSION REVEALED ON RT BS 1241 BULKHEAD FORGING AT UPPER KICK FITTING ATTACH FASTENER HOLE BY APPROX 0.030" DEEP AS PER ATTACH FIGURE. R/H BS 1241 B/H KICK FTG ATTACH FORGING UPPESDR UPS02439733Forging · Boeing 747SR46INSPECTION TYPE: C CRACK FOUND ON LT BS 1241 BULKHEAD FORGING AT LWR KICK FITTING FASTENER HOLE BY APPROX 0.050" LONG RUNNING AT FWD DIRECTION. LH BS 1241 BULKHEAD KICK FTG ATTACH FORGING LOWER BOLT HSDR UPS02439729Strap · Boeing 747SR46INSPECTION TYPE: C LT SIDE BS 1241 SPLICE STRAP 2 EACH CRACKS REVEALED OF AFT HOLE RUNNING AFT THE THICKNESS. REF HX RS R-53-43-34916 & UPS EO B747-5310-17698A. THE CRACKED STRAPS MUST BE INSPECTED EVSDR UPS02439730Strap · Boeing 747SR46INSPECTION TYPE: C RT SIDE BS 1241 BULKHEAD SPLICE STRAP CRACK REVEALED AT AFT HOLE RUNNING FWD & AFT. REFER HX RS R-53-43-34916 & UPS EO B747-5310-17698-A. THE CRACKED STRAPS MUST BE INSPECTED EVERY SDR UPS02439731Strap · Boeing 747SR46INSPECTION TYPE: C LT SIDE BS 1241 BULKHEAD SPLICE STRAP AREA, CRACK REVEALED AT AFT HOLE AT SKIN RUNNING FWD APPROX 1/8" IN LENGTH. LH BS1241 B/H SKIN AFT HOLE REPAIRED AS PER HS RS R-53-43-34916 INSSDR P5CA9800966Splice · Boeing 747122RIGHT SIDE BS 1241 BH SPLICE STRAP CRACKED AT FWD HOLE THROUGH THICKNESS RUNNING AFT. MODIFIED PER SB 747-53-2283.SDR P5CA9800963Splice · Boeing 747122BS 1241 LEFT SIDE B/H SPLICE STRAP CRACKED AT FWD HOLE RUNNING AFT THROUGH THICKNESS. MODIFIED PER SB 747-53-2283.SDR P5CA9500221Splice Strap · Boeing 747121CRACKS IN AFT HOLES OF THE BS 1241 SPLICE STRAP LEFT AND RIGHT SIDE. REPLACED STRAPS PER BOEING SERVICE BULLETIN 747-53-2283.
Back to Boeing SB 747-53-2283