Service difficulty reports that cite it · 4

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

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-757-54-0034' AND c.record_type = 'faa_service_difficulty_report' GROUP BY ALL ORDER BY max(c.record_date) DESC

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-757-54-0034' 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-757-54-0034' 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 DL757080780Brace · Boeing 757232DURING ACCOMPLISHMENT OF THE SIP MOD, S/B 757-54-0034 REV 1, THE DIAGONAL BRACE LOWER/FWD I/B LUG WAS INADVERTENTLY OVERSIZED TO 2.003" INSTEAD OF THE REQUIRED 2.000" MAXIMUM. AN OVERSIZED BUSHING WASMay 27, 2008 · N641DL · Revision 1 SDR DL757080781Fitting · Boeing 757232DURING ACCOMPLISHMENT OF THE SIP MOD PER S/B 757-54-0034 REV 1, THE NR 2 PYLON MID SPAR FITTING UPPER HORIZONTAL TANGE WAS MISDRILLED IN A FORWARD MOST HOLE LOCATION. THE FINAL CLEANUP SIZE HOLE WAS 0May 27, 2008 · N641DL · Revision 1 SDR DL757071003Attach Fitting · Boeing 757232NUMBER 2 PYLON SIDE LINK ATTACH FITTING HOLE NR 3 WAS FOUND MISALIGNED WHILE ACCOMPLISHING DELTAS EO 6-70332-3 COVERING SB 757-54-0034. A TAPERED RADIUS FILLER WAS INSTALLED PER ANAMOC TO AD 2003-18-0Aug 3, 2007 · N635DL · No revision named SDR DL757071004Attach Fitting · Boeing 757232INSTALLATION OF NEW NR 1 AND NR 2 PYLON WING ATTACH TENSION CLIPS WOULD HAVE REQUIRED SPOTFACE GREATER THAN THE 0.005" ALLOWABLE PER EO 6-070332-03 WHICH PERTAINED TO S/B 757-54-0034 REV 1 FOR THE SIPAug 3, 2007 · N635DL · Revision 1

Back to Boeing SB 757-54-0034