JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, newest first.
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 jasc_code = '5311' 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 jasc_code = '5311' 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 USAA2012091000025Frame · crackedQ6 CHECK - CRACK ON FUSELAGE FRAME AT BS 747 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 747 BETWEEN S8R TO S9R IAW TYPICAL REPAIR TR737-5310-10-0287.SDR AALA20120906025Frame · damagedSTATION 750, LONGERON 6 RIGHT, GOUGE IN FRAME LOWER LIP. INSTALLED J-ANGLE REPAIR PER AARD 53-10-00-17.SDR CALA2012090600574Frame · crackedRT FRAME BS 727A SHOW CRACK IND. INBD FASTENER. REPAIRED IAW EA 5310-04716 REV C FOR WORK ACCOMPLISHED.SDR CALA2012090600573Frame · crackedLT FRAME BS 559 SHOWS CRACK IND MFEC INBD FASTENER FRAME. REPAIRED LT STA 559 IAW EA 5310-04716, REV C.SDR CALA2012090600572Frame · crackedLT FRAME STA 400 SHOWS CRACK INDICATION, MFEC INBD FASTNER. REPAIRED LT FRAME AT STA 400 IAW EA 5310-04716, REV C 44.0008 FROM FOR WORK PERFROMED.SDR SWAA2012101008412Frame · crackedFRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME IAW ACO AND EA.SDR SWAA2012100408261Frame · crackedFRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME IAW AAR EA AND EA.SDR SWAA2012092608036Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092507965Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092507964Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092507963Frame · crackedFRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092507962Frame · crackedFRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092507961Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012092107865Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092107864Frame · crackedFRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092107863Frame · crackedFRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092107862Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012092107861Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012091907750Frame · crackedFRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA NO.SDR SWAA2012091907749Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012091907748Frame · crackedFRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012091707659Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR QXEA2012090500990Frame · corrodedFRAME 196 HAS CORROSION BETWEEN STR 31-29P. CLEANED IAW SRM 51-26-00-02-01. REMOVED FASTENERS FOM AND BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .035", FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344. CONFIRMED AFFECTED AREA CRACK FREE REF NTSDR CALA2012090600571Frame · crackedSUPPORT TASK LT FRAME BS 747 SHOWS CRACK IND MFEC INBD FASTENER ACCOMPLISHED PERMANENT REPAIR ON LT FRAME IAW ECRA 5310-04 716.SDR AALA20120905007Frame · crackedLEFT FRAME 480 IS CRACKED AT AIR CONDITION RAIL SUPPORT BRACKET. ACCOMPLISHED NESTED ANGLE REPAIR PER PER EA B737-53-025864.SDR AALA20120905005Frame · crackedFRAME CRACKED AT AIR CONDITION RAIL SUPPORT BRACKET, STATION 559 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER EA B737-53-025864.SDR AALA20120905004Frame · crackedFRAME CRACKED AT AIR CONDITION RAIL SUPPORT BRACKET, STATION 559 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER EA B737-53-025864.SDR AALA20120905002Frame · damagedELONGATED HOLE UNDER DOOR GUIDE AT STATION 1212 FROM LONGERONS 25 TO 24 RIGHT. INSTALLED REPAIR DOUBLER ON FRAME STATION 1212 PER EA MD80-53-025872.SDR CALA2012090500565Frame · crackedLT FRAME BS 500A SHOWS CRACK INDICATION. INSTALLED FRAME REPAIR IAW EA 5310-04716, REV C.SDR CALA2012090500569Frame · crackedRT FRAME BS 500C SHOWS CRACK INDICATION. REPAIRED FRAME IAW EA 5310-04716, REV C, FIG 3.SDR CALA2012090500568Frame · crackedLT FRAME BS 787 SHOW CRACK INDICATION, REPAIRED FRAME IAW EA 5310-04716, REV C.SDR CALA2012090500567Frame · crackedRT FRAME BS 500A SHOWS CRACK INDICATION, INSTALLED REPAIR DOUBLER IAW EA 5310-04716.SDR CALA2012090500566Frame · crackedLT FRAME BS 597 SHOWS CRACK INDICATIOIN. INSTALLED REPAIR FRAME DOUBLERS IAW EA 5310-0471 6, REV C.SDR SWAA2012100908334Frame · dentedFUSELAGE FRAME DENTED AT BS 767, BETWEEN STR 24R - 25R. REPAIRED FRAME PER EA.SDR SWAA2012100908333Frame · dentedFUSELAGE FRAME DENTED AT BS 747, BETWEEN STR 24R - 25R. REPAIRED FRAME PER EA.SDR ASOA2012092602294Frame · corrodedFOUND SIGNS OF CORROSION ON FWD FACE OF FRAME BS 319 BETWEEN STR 26-27L. REMOVED CORROSION IAW SRM 51-21-06-001-001 A01. FOUND BLEND AREA TO BE OUT OF LIMITS AT 12 PERCENT OF MATERIAL THICKNESS IAW SRM 53-21-06-101-002-A01. REO 670-53-21-887 --SDR R61A201209040504Splice · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT MID FRAME 89 CORRODED. MAINTENANCE REMOVED AND REPLACED FRAME SPLICE IAW EMB 170 SRM 51-43-01, AND 51-40-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR CALA2012090500564Frame · crackedLT FRAME BS 500C SHOW CRACK INDICATION. REPAIRED DAMAGE FRAME IAW EA5310-04716, REV C.SDR CALA2012090500563Frame · crackedRT FRAME BS 787 SHOWS CRACK INDICATION. REPAIRED DAMAGE FRAME IAW EA5310-04716, REV C.SDR CALA2012090500562Frame · crackedRT FRAME BS 520 SHOWS CRACK INDICATION. REPAIRED DAMAGE FRAME IAW EA 5310-04716, REV C.SDR FDEA201209043216Frame · chafedCABIN, FRAME AT BS 1289 HAS CHAFED AT STR 15L TO 16L. REPAIRED IAW EA F-5310-163116, PART 1. REPAIR IS MAJOR.SDR SWAA2012101108436Frame · crackedFRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME IAW EA.SDR QXEA2012090301002Frame · corrodedFRAME 19.4 HAS CORROSION BETWEEN STR 32-30S. CLEANED AREA IAW SRM 51-26-00-02-01. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .030" CONFIRMED AREA CRACK FREE REF 51-00-04-910-801 PT 1 ASDR FDEA201209033213Frame · crackedCRACK INDICATION ON FR40 RT WING ROOT REPAIR CARRIED OUT IAW EA6-5315-162966 AND SB A300-57-6052.SDR ASAA2012092092963Frame · crackedFRAME AT BS 500B HAS A CRACK AT 1.04 WIRE PENETRATION HOLE 900 POS AS VIEWED LOOKING AFT EXTENDING INWARD APROX .1250 LONG. ACFT GROUNDED. REPAIRED FRAME IAW SRM 53-00-07, REP 13.SDR ASAA2012092092962Frame · crackedFRAME AT BS 500 RT HAS AT 1.04 WIRE PENETRATION HOLE 300, POS AS VIEWED LOOKING AFT EXTENDING INWARD APPROX .2500 LONG. ACFT GROUNDED. REPAIRED FRAME IAW SRM 53-00-07, REPAIR 13.SDR SIMA20120829007Frame · chafedDURING INSPECTION QC DISCOVERED A CHAFE ON FRAME 65 BETWEEN STRINGERS 12R AND 13R. THE AIRCRAFT WAS REMOVED FROM SERVICE. DOUBLER INSTALLED IAW EO EM-53MR-2020. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR QXEA2012090200948Frame · corrodedFRAME 71.0 HAS CORROSION BTWN STR 30-29S. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. POLISHED SURFACE OF FRAME FLANGE REF RD 8/4-53-2344. MIN REMAINING THICKNESS .039", CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910SDR ASAA2012092492795Frame · crackedFRAME BS 500C HAS A CRACK .25 LONG EXTENDING I/B FROM EDGE OF THE 1.04 WIRE PENETRATION HOLE. FRAME REPAIRED IAW SRM 53-00-07.SDR SWAA2012100108153Frame · corrodedFRAME CORRODED AT BS 344, STR 27R. REPAIRED FRAME WEB IAW EO AND EA.
Back to JASC 5311