Lockheed SB 382-57-85
Service difficulty reports that cite it · 58
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-85' 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-85' 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 LR7A2021011402721Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LOWER SURFACE FORWARD PANEL (398850-3) CRACKED AT THE MOST OUTBOARD HOLE COMMON TO THE 3732SDR LR7A2021011402722Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LOWER SURFACE FORWARD PANEL (398850-3) CRACKED AT THE MOST OUTBOARD HOLE COMMON TO THE 3732SDR LR7A2021011402723Attach Angle · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LT FILLET FAIRING ATTACH ANGLE CRACKED AT FS 517, LBL 76. REPAIR BY REPLACEMENT ACCOMPLISHESDR LR7A2021011402724Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE RT MLG EXTRUDED RISER PANEL WEB CRACKED AT TWO LOCATIONS BETWEEN FS 530-577, WL 250, RBL 61.5. REPAIR BSDR LR7A2021011402725Beam · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE RT FS 577 MLG BEAM CRACKED AT 2ND FASTENER HOLE FROM THE TOP. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LSDR LR7A2021011402726Beam · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE RT FS 588 MLG BEAM CRACKED AT TOP TWO FASTENER HOLES. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SDR LR7A2021011402727Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE LT MLG EXTRUDED RISER PANEL WEB CRACKED THROUGH FASTENER HOLES AT FS 580 AND FS 607 WL 255, LBL 61. REPSDR LR7A2021011402728Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE LT MLG EXTRUDED RISER PANEL WEB CRACKED THROUGH FASTENER HOLES AT FS 537, FS 557 AND FS 577 WL 255, LBLSDR LR7A2021011402729Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE LT MLG EXTRUDED RISER PANEL WEB CRACKED THROUGH FASTENER HOLES AT FS 517, WL 255, LBL 61. REPAIR BY REPSDR LR7A2021011402730Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX B INSPECTION, AFTER REMOVING THE DRAG ANGLE, FOUND THE CENTER WING LOWER FWD PANEL (P/N 398850-3) AND CWS178L BULKHEAD LOWER CASDR LR7A2021011402731Beam · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX B INSPECTION, FOUND THE FS 528 LT MLG VERTICAL TRACK BEAM WITH CRACKED HOLE AT WL 256.6, LBL 61.6. REPAIRED IAW LAC MEA 382-53-SDR LR7A2021011402732Beam · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX B INSPECTION, FOUND THE LT FS 557 MLG BEAM WITH MISALIGNED HOLES AT WL 251, LBL 59. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCSDR LR7A2021011402733Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN LT LOWER FWD SURFACE AND BULKHEAD LOWER FOOT, FS 520, LBL 60.2, HOLSDR LR7A2021011402734Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN LT LOWER FWD SURFACE, STRINGER & BULKHEAD LOWER FOOT AT FS 521, LBLSDR LR7A2021011402735Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN RT LOWER AFT SURFACE AND STRINGER FS 592.7 RBL 58.5 HOLE B51. REPAISDR LR7A2021011402736Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN RT LOWER FWD SURFACE AND CAP, FS 519, RBL 60, HOLE C2. REPAIRED, IASDR LR7A2021011402737Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN RT LOWER FWD SURFACE AND CAP, FS 519, RBL 59, HOLE B2. REPAIRED, IASDR LR7A2021011402738Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN RT LOWER FWD SURFACE AND BULKHEAD LOWER FOOT, FS 520, RBL 60.2, HOLSDR LR7A2021011402739Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN THE RT LOWER FWD SURFACE AND BULKHEAD LOWER FOOT, FS 521, RBL 60.2,SDR LR7A2021011402740Stringer · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND TOOLING DAMAGE TO CENTER WING STRINGER NR 24 AFT FOOT, FS 593, RBL 59, TOP SIDE OF STRINGER FOOT. REPAIRED SDR LR7A2021011402741Stringer · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN LT LOWER AFT SURFACE AT FS 593.7, LBL 58.5, HOLE B52. REPAIRED IAW SDR LR7A2021011402742Stringer · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN LT LOWER AFT SURFACE, STRINGER, & BULKHEAD LOWER FOOT AT FS 592.7, SDR LR7A2021011402743Stringer · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH OVERSIZED HOLES IN LT LOWER AFT SURFACE AND STRINGER, FS 592.7, LBL 59.25, HOLE C51. RSDR LR7A2021011402744Stringer · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LT LOWER AFT SURFACE & STRINGER WITH OVERSIZED HOLE AT FS 592.7, LBL 58.5, HOLE B51. REPAIRSDR LR7A2021011402745Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LT LOWER FWD SURFACE & CAP WITH OVERSIZED HOLES AT FS 519, LBL 60, HOLE C2. REPAIRED IAW LASDR LR7A2021011402746Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LT LOWER FWD SURFACE AND CAP WITH OVERSIZED HOLE AT FS 519, LBL 59, HOLE B2. REPAIRED IAW LSDR LR7A2021011402747Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING RT LOWER AFT SURFACE, STRINGER, & BULKHEAD FOOT WITH OVERSIZED HOLE AT FS 592.7, RBL 59.25,SDR LR7A2021011402748Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING RT LOWER AFT SURFACE AND CAP WITH OVERSIZED HOLE AT FS 595, RBL 59.25, HOLE C53. REPAIRED ISDR LR7A2021011402749Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING RT LOWER AFT SURFACE WITH OVERSIZED HOLE AT FS 593.7, RBL 59, HOLE B52. REPAIRED IAW LAC MESDR LR7A2021011402750Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING RT LOWER AFT SURFACE AND BULKHEAD LOWER FOOT WITH OVERSIZED HOLE AT FS 593.7, RBL 60.25, HOSDR LR7A2021011402751Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING RT LOWER AFT SURFACE, STRINGER, AND BULKHEAD FOOT WITH OVERSIZED HOLE AT FS 592.7, RBL 60.2SDR LR7A2021011402752Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LT LOWER AFT SURFACE AND CAP WITH OVERSIZED HOLE AT FS 595, LBL 60, HOLE C53. REPAIRED IAW SDR LR7A2021011402753Stringer · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING WITH TOOLING DAMAGE TO LT STRINGER NR 24 AFT FOOT, FS 593, LBL 59, TOP SIDE OF STRINGER AFTSDR LR7A2021011402754Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LT LOWER AFT SURFACE WITH OVERSIZED HOLE AT FS 588, LBL 60, HOLE D48. REPAIRED IAW LAC MEA SDR LR7A2021011402755Panel · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX A INSPECTION, FOUND THE CENTER WING LT LOWER AFT SURFACE AND BULKHEAD LOWER FOOT WITH OVERSIZED HOLE AT FS 593, LBL 60.25, HOLESDR LR7A2021011402759Drag Fitting · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX B INSPECTION, FOUND THE NR 3 ENGINE INBOARD LOWER NACELLE DRAG FITTING HOLES ARE DAMAGED. REPAIR BY REPLACEMENT ACCOMPLISHED, ISDR LR7A2021011402762Beam · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX B INSPECTION, FOUND THE LT FS 557 LOWER BOW BEAM UPPER END WITH DAMAGE FOUND ON EXISTING REPAIR LBL 62, WL 199. REPAIRED IAW LOSDR LR7A2021011402768Drag Fitting · Lkheed 382GDURING P4-LAS SCHEDULED C-3 CHECK WHILE PERFORMING SB 382-57-85 APPENDIX B INSPECTION, FOUND THE NR 2 ENGINE NACELLE INBOARD LOWER DRAG FITTING CORRODED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHESDR LR7A2015031800533Skin · Lkheed 382GDURING SCHEDULED C-11 CHECK, WHILE PERFORMING SB 382-57-85 R2 APPENDIX A NDI, FOUND THE LT CENTER WING LOWER SURFACE PANEL UNDER THE LT WING ATTACH ANGLE HAD 1 CRACK EVIDENT; FS 570, CWS 60L, WL 256. SDR LR7A2015031800534Panel · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2 APPENDIX A NDI, FOUND 1 CRACK EVIDENT ON THE LT SIDEWALL AT FS 484, LBL 61, WL 252 UNDER THE WING ATTACH ANGLE. REPAIR BY REPLACEMENT ACCOMSDR LR7A2015031800535Panel · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2, APPENDIX A NDI, FOUND 1 CRACK EVIDENT ON THE E533 SIDEWALL AT FS 528, LBL 61 WL 252, UNDER THE WING ATTACH ANGLE. REPAIR BY REPLACEMENT ACSDR LR7A2015031800540Skin · Lkheed 382GDURING SCHEDULED C-11 CHECK, WHILE PERFORMING SB 382-57-85, R2 APPENDIX B NDI, FOUND 1 CRACKED FASTENER HOLE EVIDENT ON RT CENTER WING LOWER NR 1 PANEL AT FS538, CWS 178R, WL 256. REPAIRED IAW LAC MEASDR LR7A2015031800541Skin · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2 APPENDIX D NDI AND SB 382-57-86 R1, FOUND 1 CRACK EVIDENT AT LT CENTER WING LOWER PANEL NR 1 COMMON TO THE LT ATTACH ANGLE AT FS518, CWS72LSDR LR7A2015031800542Skin · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85, R2 APPENDIX D NDI AND SB 382-57-86 R1, FOUND 2 CRACKS EVIDENT AT RT CENTER WING LOWER PANEL NR 1 COMMON TO THE RT ATTACH ANGLE AT FS518, CWS7SDR LR7A2015031800543Beam · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2 APPENDIX D NDI AND SB 382-57-86 R1, FOUND 1 CRACKED FASTENER HOLE EVIDENT ON THE RT FS517 MLG BEAM'S INBD AND OTBD CAPS COMMON TO THE ATTACSDR LR7A2015031800544Bulkhead · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2 APPENDIX A NDI AND SP-141 NDI, FOUND 2 CRACKS EVIDENT ON THE RT FS528-FS577 SIDEWALL AT FS528, RBL61. REPAIR BY SIDEWALL REPLACEMENT ACCOMPSDR LR7A2015031800545Bulkhead · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2 APPENDIX A NDI AND SP-141 NDI, FOUND 3 CRACKS EVIDENT ON THE RT FS577-FS617 SIDEWALL AT FS576, FS577, & FS588, RBL61. REPAIR BY REPLACEMENTSDR LR7A2015031800546Skin · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2 APPENDIX A NDI AND SP-141 NDI, FOUND 2 CRACKS EVIDENT ON THE RT CENTER WING LOWER PLANK LAYER AT FS596, CWS59R WL256 AND 1 CRACK EVIDENT ONSDR LR7A2015031800547Stringer · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85 R2 NDI, FOUND 3 MISDRILLED HOLES WITH DOUBLE FLUSH RIVETS PLUGGING THEM AT NR 3 DRY BAY LOWER RIB CAP AT CWS178.78R PLANK STRINGERS 16, 17, & SDR LR7A2015031800548Stringer · Lkheed 382GDURING SCHEDULED C-11 CHECK WHILE PERFORMING SB 382-57-85, R2 NDI, FOUND 3 MISDRILLED HOLES WITH DOUBLE FLUSH RIVETS PLUGGING THEM AT NR 2 DRY BAY LOWER RIB CAP AT CWS178.78L PLANK STRINGERS 17 & 18 A
Back to Lockheed SB 382-57-85