Boeing 767-223
Service difficulty reports · 2,039
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '767223' ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '767223' ORDER BY difficulty_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 AALA20111208AFW11Shear Tie · corrodedSHEAR TIE STATION 1285 BETWEEN STRINGERS 36 TO 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111208AFW10Shear Tie · corrodedSHEAR TIE STATION 1285 BETWEEN STRINGERS 37 TO 38 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111208AFW09Shear Tie · corrodedSHEAR TIE STATION 1285 BETWEEN STRINGERS 38 TO 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111208AFW05Shear Tie · corrodedSHEAR TIE AT STATION 588 BETWEEN STRINGERS 39 AND 38 RIGHT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111208AFW04Shear Tie · corrodedSHEAR TIE AT STATION 588 BETWEEN STRINGERS 36 AND 37 LEFT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111208AFW03Shear Tie · corrodedSHEAR TIE AT STATION 588 BETWEEN STRINGERS 38 AND 37 LEFT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111208AFW02Shear Tie · corrodedSHEAR TIE AT STATION 588 BETWEEN STRINGERS 39 RIGHT AND 39 LEFT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111208AFW01Stringer · corrodedFORWARD CARGO STRINGER 34 RIGHT HAS CORROSION ON OUTBOARD SIDE OF STRINGER AT STATION 428. INSTALLED REPAIR SPLICES ON STRINGER 34 RIGHT AT STATION 428 PER SRM 53-00-03-2R.SDR AALA20111207AFW12Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 38 AND 39 LEFT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111207AFW11Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 38 AND 37 LEFT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111207AFW10Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 37 AND 36 LEFT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111207AFW09Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 39 AND 38 RIGHT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111207AFW08Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 37 AND 36 RIGHT IS CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111207AFW03Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 632 BETWEEN STRINGERS 36 AND 35 LEFT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111207AFW02Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 632 BETWEEN STRINGERS 36 AND 37 LEFT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111207AFW01Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 632 BETWEEN STRINGERS 38 AND 37 LEFT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111210AFW01Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 632 BETWEEN STRINGERS 38 AND 39 RIGHT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111205AFW04Stringer · corrodedFORWARD CARGO STRINGER 35 LEFT HAS CORROSION AT STATION 434. INSTALLED STRINGER SPLICE ON 35 LEFT FROM STATIONS 420 TO 440 PER SRM 53-30-03-2R.SDR AALA20111205AFW01Wedge · damagedSEVERAL SHARP DENTS/GOUGES ON UPPER SURFACE OF THE NUMBER 6 SLAT WEDGE APROXIMATELY 8 INCHES FROM INBOARD EDGE AND APROXIMATELY 8 INCHES FROM TRAILING EDGE. ACCOMPLISHED SLAT REPAIR PER SRM 51-70-10.SDR AALA20111205AFW03Shear Tie · corrodedSHEAR TIE AT STATION 632 BETWEEN STRINGERS 36 AND 37 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111205AFW02Stringer · corrodedFORWARD CARGO STRINGER 33 RIGHT AT STATION 414 HAS CORROSION ON UPPER SIDE. INSTALLED REPAIR PER SRM 53-00-03-2R.SDR AALA20111204AFW10Shear Tie · corrodedSHEAR TIE AT STATION 1329 BETWEEN STRINGERS 39 LEFT AND 39 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111204AFW04Shear Tie · corrodedSHEAR TIE AT STATION 1351 BETWEEN STRINGERS 37 AND 38 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW19Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 654 BETWEEN STRINGERS 36 AND 35 LEFT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW18Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 654 BETWEEN STRINGERS 36 AND 37 LEFT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW17Shear Tie · corrodedSHEAR TIE AT STATION 654 BETWEEN STRINGERS 38 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW16Shear Tie · corrodedSHEAR TIE AT STATION 654 BETWEEN STRINGERS 39 AND 38 LEFT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW15Shear Tie · corrodedSHEAR TIE AT STATION 654 BETWEEN STRINGERS 37 AND 38 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW14Shear Tie · corrodedSHEAR TIE AT STATION 654 BETWEEN STRINGERS 35 AND 36 RIGHT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW13Shear Tie · corrodedSHEAR TIE AT STATION 676 BETWEEN STRINGERS 35 AND 36 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW12Shear Tie · corrodedSHEAR TIE AT STATION 676 BETWEEN STRINGERS 37 AND 36 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW11Shear Tie · corrodedSHEAR TIE AT STATION 676 BETWEEN STRINGERS 37 AND 38 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW10Shear Tie · corrodedSHEAR TIE CORRODED STATION 676 BETWEEN STRINGERS 39 LEFT AND 39 RIGHT. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW09Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 37 AND 38 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW07Cap · corrodedJ-CAP IS CORRODED AT STATION 698 LEFT BUTTLINE 6. REPLACED J-CAP PER SRM 51-10-02.SDR AALA20111203AFW06Shear Tie · corrodedSHEAR TIE AT STATIONS 698 BETWEEN STRINGERS 36 AND 37 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW05Shear Tie · corrodedSHEAR TIE AT STATION 698 BETWEEN STRINGERS 38 AND 37 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW04Shear Tie · corrodedSHEAR TIE AT STATIONS 698 BETWEEN STRINGERS 39 AND 38 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW03Shear Tie · corrodedSHEAR TIE AT STATION 698 BETWEEN STRINGERS 37 AND 38 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW02Shear Tie · corrodedSHEAR TIE AT STA 698 BETWEEN STRINGERS 36 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111203AFW01Shear Tie · corrodedSHEAR TIE STATION 698 BETWEEN STRINGERS 35 AND 36 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111220AFW02Stiffener · corrodedRADIAL STIFFENER ON FORWARD SIDE OF AFT PRESSURE BULKHEAD STATION 1596 LEFT BUTTLINE 10 CORRODED. ACCOMPLISHED NESTED ANGLE REPAIR PER EA 020714.SDR AALA20111207AFW04Torque Box · crackedLEFT PYLON UPPER TORQUE BOX SKIN CRACKED OUTBOARD AFT SIDE WHERE INTEGRATED DRIVE GENERATOR FEEDER CABLES RUN THRU. INSTALLED REPAIR DOUBLER PER EA B767-54-020372.SDR AALA20111204AFW16Shear Tie · corrodedSHEAR TIE AT STATION 1241 BETWEEN STRINGERS 36 AND 35 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111129AFW01Cap · corrodedJ-CAP AT STATION 676 IS CORRODED AT LEFT BUTTLINE 19. ACCOMPLISHED REPLACEMENT OF J-CAP PER SRM 51-10-02.SDR AALA20111208AFW08Shear Tie · corrodedSHEAR TIE STATION 1307 AT STRINGER 35 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20111205AFW06Stringer · damagedSTRINGER 39 LEFT AT STATIONS 1395 TO 1436 DAMAGED. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-03-2R.SDR AALA20111122AFW02Intercostal · crackedINTERCOSTAL ANGLE ON CABIN FLOOR STRUCTURE STATION 742 TO STATION 764, LEFT BUTTLINE 40 CRACKED. REMOVED AND REPLACED WITH A SERVICEABLE INTERCOSTAL ANGLE.SDR AALA20111122AFW01Intercostal · crackedINTERCOSTAL ANGLE ON CABIN FLOOR STRUCTURE, STATIONS 742 TO 764 AT RIGHT BUTTLINE 40 IS CRACKED. REMOVED AND REPLACED WITH SERVICEABLE INTERCOSTAL ANGLE.SDR AALA20111208AFW07Shear Tie · corrodedSHEAR TIE STATION 1307 AT STRINGER 39 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.
Back to Boeing 767-223