Lockheed SB 382-57-82
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 = 'lockheed/sb-382-57-82' 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 = 'lockheed/sb-382-57-82' 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 LR7A2023010403244Beam · Lkheed 382GDURING SCHEDULED B-3 CHECK UNDER SB 382-57-82, FOUND LH OW UPPER BEAM CAP WITH CORRODED HOLE AT OWS3L, FS517, WL287. / REPAIRED IAW LAC MEA 382-57-22-114. NR# 1000796213. / PSE# 57-50-08, AD 2012-06-0SDR LR7A2023010403256Fitting · Lkheed 382GDURING SCHEDULED B-3 CHECK UNDER SB 382-57-82 , FOUND MULTIPLE DEFECTS IN LH OUTER WING LOWER PANEL ATTACH HOLES WITH MULTIPLE CRACKS. REPAIRED IAW LAC MEA 382-57-22-086.SDR LR7A2023010403257Attach Plate · Lkheed 382GDURING SCHEDULED B-3 CHECK UNDER SB 382-57-82 , FOUND MULTIPLE DEFECTS IN RH OUTER WING LOWER PANEL ATTACH HOLES WITH MULTIPLE CRACKS AT FS517-579, OWS3.5-6.5L, WL255-260. / REPAIRED IAW LAC MEA 382-5SDR LR7A2023010403259Splice · Lkheed 382GDURING SCHEDULED B-3 CHECK UNDER SB 382-57-82, FOUND CORRODED FASTENER HOLE ON LH OW UPPER FWD CORNER SPLICE FITTING AT OWS3L, FS517, WL287. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRSDR LR7A202301043260Splice · Lkheed 382GDURING SCHEDULED B-3 CHECK UNDER SB 382-57-82, FOUND RH OW UPPER FWD CORNER SPLICE FITTING WITH MULTIPLE FASTENER HOLES CORRODED AT OWS3-10R, FS517, WL287. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCSDR LR7A2009030900007Fitting · Lkheed 382GDURING SCHEDULED C-8 CHECK PER JOB CARD HSP57217, FOUND CRACK ON RT LOWER CENTER WING RAINBOW FITTING CUTOUT NR 5. REPLACED RAINBOW FITTING IAW SB 382-57-82 REV 3.
Back to Lockheed SB 382-57-82