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 AALA20120520014Stringer · corrodedSTRINGER 34 RIGHT BETWEEN STATIONS 412 TO 434 HAS AREA OF CORROSION. INSTALLED DOUBLER REPAIR PER SRM 53-00-03-2R.SDR AALA20120520013Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 38 AND 39 LEFT CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120520012Shear Tie · corrodedSHEAR TIE AT STATION 720 BETWEEN STRINGERS 36 AND 37 LEFT CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120520011Shear Tie · corrodedSHEAR TIE AT STATION 676 BETWEEN STRINGER 37 AND 36 RIGHT CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120520010Shear Tie · corrodedSHEAR TIE AT STATION 676 BETWEEN STRINGERS 39 LEFT AND 39 RIGHT CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120520009Shear Tie · corrodedSHEAR TIE AT STATION 676 BETWEEN STRINGERS 39 AND 38 LEFT CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120520008Shear Tie · corrodedSHEAR-TIE AT STATION 676 BETWEEN STRINGERS 37 AND 38 LEFT HAS CORROSION. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120614013Frame · corrodedSTATION 1087 J-CAP CORRODED. REPLACED INNER J-FRAME PER SRM 51-10-02.SDR AALA20120604022Shear Tie · corrodedSHEAR TIE AT STATION 1175 AT STRINGERS 39 LEFT AND 39 RIGHT. REPLACED SHEAR TIE PER SRM 51-10-2.SDR AALA20120604021Shear Tie · corrodedSHEAR TIE AT STATION 1175 BETWEEN STRINGERS 38 AND 39 LEFT. REPLACED SHEAR TIE PER SRM 51-10-2.SDR AALA20120604020Shear Tie · corrodedSHEAR TIE AT STATION 1175 BETWEEN STRINGERS 38 AND 37 LEFT. REPLACED SHEAR TIE PER SRM 51-10-2.SDR AALA20120604019Shear Tie · corrodedSHEAR TIE AT STATION 1175 BETWEEN STRINGERS 36 AND 37 LEFT. REPLACED SHEAR TIE PER SRM 51-10-2.SDR AALA20120604018Shear Tie · corrodedSHEAR TIE AT STATION 1175 BETWEEN STRINGERS 38 AND 37 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120603006Shear Tie · corrodedSHEAR TIE AT STATION 1395 BETWEEN STRINGERS 38 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120602006Shear Tie · corrodedSHEAR TIE AT STATION 1153 AT STRINGERS 39 LEFT AND 39 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120602005Stringer Splice · corrodedSTRINGER SPLICE FOR 39 RIGHT BETWEEN STATIONS 1285 TO 1307 ON INBOARD SIDE HAS SHIM STOCK THAT IS CORRODED UNDER FLANGE. INSTALLED NEW SHIM WET PER SRM 53-00-03-1A.SDR AALA20120602004Stringer Splice · corrodedSTRINGER SPLICE FOR 37 LEFT AFT OF STATION 1307 HAS SHIM STOCK THAT IS CORRODED UNDER BOTH INBOARD AND OUTBOARD FLANGE. INSTALLED STRINGER REPAIR WET PER EA B767-53-024116.SDR AALA20120529014Frame · corrodedSTATION 1153 CARGO FLOOR INNER J FRAME CORRODED. REPLACED INNER J CHORD PER SRM 51-10-02.SDR AALA20120528050Shear Tie · corrodedSHEAR TIE AT STATION 1219 BETWEEN STRINGERS 38 AND 39 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528049Shear Tie · corrodedSHEAR TIE AT STATION 1219 AT STRINGERS 39 LEFT AND RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528048Shear Tie · corrodedSHEAR TIE AT STATION 1197 AT STRINGERS 38 AND 37 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528047Shear Tie · corrodedSHEAR TIE AT STATION 1219 BETWEEN STRINGERS 38 AND 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528046Shear Tie · corrodedSHEAR TIE AT STATION 1219 BETWEEN STRINGERS 37 AND 38 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528045Shear Tie · corrodedSHEAR TIE AT STATION 1197 AT STRINGERS 39 LEFT AND 39 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528044Shear Tie · corrodedSHEAR TIE AT STATION 1219 BETWEEN STRINGERS 36 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528043Shear Tie · corrodedSHEAR TIE AT STATION 1219 BETWEEN STRINGERS 35 AND 36 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528042Shear Tie · corrodedSHEAR TIE AT STATION 1197 BETWEEN STRINGERS 38 AND 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528041Shear Tie · corrodedSHEAR TIE AT STATION 1197 BETWEEN STRINGERS 37 AND 38 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528040Shear Tie · corrodedSHEARTIE AT STATION 1197 BETWEEN STRINGERS 36 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528034Shear Tie · corrodedSHEAR TIE AT STATION 1351 BETWEEN STRINGERS 38 AND 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528033Shear Tie · corrodedSHEAR TIE AT STATION 1351 BETWEEN STRINGERS 38 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528032Shear Tie · corrodedSHEAR TIE AT STATION 1351 BETWEEN STRINGERS 36 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528031Shear Tie · corrodedSHEAR TIE AT STATION 1351 BETWEEN STRINGERS 36 AND 35 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528030Shear Tie · corrodedSHEAR TIE AT STATION 1351 BETWEEN STRINGERS 34 AND 35 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528029Shear Tie · corrodedSHEAR TIE AT STATION 1351 BETWEEN STRINGERS 33 AND 34 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528028Shear Tie · corrodedSHEAR TIE AT STATION 1329 AT STRINGERS 39 LEFT AND 39 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528027Shear Tie · corrodedSHEAR TIE AT STATION 1329 BETWEEN STRINGERS 38 AND 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528026Shear Tie · corrodedSHEAR TIE AT STATION 1329 BETWEEN STRINGERS 38 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528025Shear Tie · corrodedSHEAR TIE AT STATION 1329 BETWEEN STRINGERS 36 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528024Shear Tie · corrodedSHEAR TIE AT STATION 1329 BETWEEN STRINGERS 36 AND 35 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528023Shear Tie · corrodedSHEAR TIE AT STATION 1263 AT STRINGERS 39 RIGHT AND 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528022Shear Tie · corrodedSHEAR TIE AT STATION 1263 BETWEEN STRINGERS 38 AND 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528021Shear Tie · corrodedSHEAR TIE AT STATION 1263 BETWEEN STRINGERS 37 AND 38 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528020Shear Tie · corrodedSHEAR TIE AT STATION 1263 BETWEEN STRINGERS 36 AND 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120528019Shear Tie · corrodedSHEAR TIE AT STATION 1263 BETWEEN STRINGERS 36 AND 35 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 53-00-07.SDR AALA20120524021Shear Tie · corrodedSHEAR TIE AT STATION 1285 BETWEEN STRINGERS 38 TO 39 RIGHT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120524020Shear Tie · corrodedSHEAR TIE AT STATION 1285 BETWEEN STRINGERS 39 RIGHT TO 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120524019Shear Tie · corrodedSHEAR TIE AT STATION 1285 BETWEEN STRINGERS 38 TO 39 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120524017Shear Tie · corrodedSHEAR TIE AT STATION 1285 BETWEEN STRINGERS 38 TO 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA20120524016Shear Tie · corrodedSHEAR TIE AT STATION 1285 BETWEEN STRINGERS 36 TO 37 LEFT CORRODED. REPLACED SHEAR TIE PER SRM 51-10-02.
Back to Boeing 767-223