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 ASAA0842730Frame · damagedDRILL MARKS ON FRAME IN CARGO PIT AT BS 747 RBL3 TO LBL3, REPAIRED WITH REPAIR PART.SDR ASAA0842729Frame · corrodedFOUND CORROSION ON FRAME IN AFT CARGO PIT AT BS 767 STR 26R TO STR 27R. REPAIRED WITH REPAIR PART.SDR ASAA0842728Frame · corrodedCORROSION ON FRAME IN AFT CARGO PIT AT BS 747 STR 26L TO STR 26R, REPAIRED WITH REPAIR PART.SDR 2008UALA01188Frame · gougedAFT PIT FRAME GOUGED 4 EA PLACES AT BS 1520 BETWEEN STR 23R AND 25R. MAJOR REPAIR ACCOMPLISHED AT GSO.SDR USAA920080559Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 727E, S9R. REPAIRED FRAME BS, 727E, S9R IAW USAIRWAYS EA 100286.SDR USAA920080556Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 400, S9L. REPAIRED FRAME BS, 400, S9L IAW USAIRWAYS EA 100286.SDR SWAA081210Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081179Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081180Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081181Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081182Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081183Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081209Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081178Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081211Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081212Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081205Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME INBOARD CHORD CRACKED AT BS 616, LBL 64. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA081175Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303, STR 4L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081203Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081194Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081195Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081204Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR DHL2008763522Frame · dentedFRAME DENTED AND GOUGED IN CARGO COMPT AT BS 660, ABOVE STR 17R. CUT OUT DAMAGE, FABRICATED FRAME REPAIR, AND INSTALLED PER B727 SRM 51-40-3 FIG 1, 53-10-2 FIG 3, AND 51-30-2.SDR DHL2008763521Frame · dentedFRAME DENTED AND GOUGED IN CARGO COMPT AT BS 640, ABOVE STR 17R. CUT OUT DAMAGE, FABRICATED FRAME REPAIR, AND INSTALLED PER B727 SRM 51-40-3 FIG 1, 53-10-2 FIG 3, AND 51-30-2.SDR DHL2008763520Frame · gougedFRAME GOUGED IN CARGO COMPT AT BS 600, ABOVE STR 17R. CUT OUT DAMAGE, FABRICATED FRAME REPAIR, AND INSTALLED PER B727 SRM 51-40-3 FIG 1, 53-10-2 FIG 3, AND 51-30-2.SDR F3LA200800105Frame · corrodedDURING C4/S1 C CHECK, INSPECTION REPORTED CORROSION WAS FOUND ON THE AFT CARGO COMPARTMENT FRAME PLATE AT FRAME 61. MAINTENANCE REMOVED AND REPLACED THE FRAME PLATE IN ACCORDANCE WITH THE REQUIREMENTS OF A319 SRM 51-42-11, PARAGRAPHS 5 AND 6. FOLLOWING COMPLSDR SWAA081142Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 295, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA081136Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME PER SRM.SDR DHL2008763519Frame · dentedFRAME DENTED IN CARGO COMPT AT BS 580, ABOVE STR 17R. CUT OUT DAMAGE, FABRICATED FRAME REPAIR, AND INSTALLED PER B727 SRM 51-40-3 FIG 1, 53-10-2 FIG 3, AND 51-30-2.SDR DHL2008763507Frame · dentedFRAME GOUGED AND DENTED AT BS 560, ABOVE STR 17R. CUT OUT DAMAGED AREA. FABRICATED AND INSTALLED FRAME REPAIR FROM 7075T6, .063 INCHES BY 7.25 INCHES BY 3.25 INCHES, PO NR 9006027, PER B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1.SDR DHL2008763506Frame · dentedFRAME GOUGED AND DENTED AT BS 540, ABOVE STR 17R. CUT OUT DAMAGED AREA. FABRICATED AND INSTALLED FRAME REPAIR FROM 7075T6, .063 INCH BY 7.25 INCH BY 3.25 INCH, PO NR 9006027, PER B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1.SDR DHL2008763505Frame · dentedFRAME GOUGED AND DENTED AT BS 520, ABOVE STR 17R. CUT OUT DAMAGED AREA. FABRICATED AND INSTALLED FRAME REPAIR FROM 7075T6, .063 INCH BY 7.25 INCH BY 3.25 INCH, PO NR 9006027, PER B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1.SDR DHL2008763504Frame · dentedFRAME GOUGED AND DENTED AT BS 500 ABOVE STR 17R. CUT OUT DAMAGED AREA. FABRICATED AND INSTALLED FRAME REPAIR FROM 7075T6, .063 INCH BY 7.25 INCH BY 3.25 INCH, PO NR 9006027, PER B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1.SDR DHL2008763503Frame · dentedFRAME GOUGED AND DENTED AT BS 480, ABOVE STR 17R. CUT OUT DAMAGED AREA. FABRICATED AND INSTALLED FRAME REPAIR FROM 7075T6, .063 INCHES BY 7.25 INCHES BY 3.25 INCHES, PO NR 9006027, PER B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1.SDR 2008UALA01138Frame · dentedAFT PIT FRAME DENTED STA 1440 AT STR 25L. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR 2008UALA01136Frame · dentedAFT PIT FRAME DENTED AT INBOARD FLANGE AT BS 1480 BETWEEN STR 25L AND STR 26L. MAJOR REPAIR ACCOMPLISHED AT GSO.SDR 2008UALA01135Frame · dentedAFT PIT FRAME DENTED ON INBOARD FLANGE AT BS 1540 AND STR 26. MAJOR REPAIR ACCOMPLISHED AT GSO.SDR 2008UALA01149Frame · corrodedAFT CARGO PIT AT BS 1197 +44 LBL 22 TO RBL 9 FRAME T-CAP HAS CORROSION UNDER NUT PLATE ATTACH FASTENER HOLES.SDR 2008UALA01148Frame · gougedAFT PIT FRAME WEB GOUGED, STA 1351, STR 24R - 25R.
SDR 2008UALA01137Frame · dentedAFT PIT FRAME INBOARD FLANGE DENTED AT BS 1560 BETWEEN STR 26L AND STR 27L.
SDR USAA920080535Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 767, S9L. REPAIRED FRAME BS, 767, S9L IAW USAIRWAYS EA 100286.SDR 2008UALA01097Frame · corrodedAFT CARGO PIT AT BS 1197 +22 LBL 38 TO LBL 44 FRAME T-CAP HAS CORROSION UNDER SIDE OF CAP. FOUND TO BE OUT OF LIMITS. REMOVED ENTIRE "T" CORD. INSTALLED NEW "T" CORD REF SRM 51-40-02.SDR USAA920080540Frame · crackedMCN - MAJOR REPAIR - CRACKED FRAME, BS 887, S9L AND S9R. REPAIRED FRAME BS 887, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080539Frame · crackedMCN - CRACKED FRAME, BS 500C, S9L. REPAIRED FRAME BS, 500C, S9L IAW USAIRWAYS EA 100286.SDR USAA920080537Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 480, S9L AND S9R. REPAIRED FRAME BS 480, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080536Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 747, S9L. REPAIRED FRAME BS, 747, S9L IAW USAIRWAYS EA 100286.SDR 2008UALA01104Frame · crackedFUSELAGE FRAME CRACKED BELOW CABIN FLOOR, OVER WING SECTION BS 616 RT SIDE. MAJOR REPAIR ACP'D. REMOVED DAMAGE AND VERIFIED WITH HFEC. INSTALLED A FILLER AND A REPAIR ANGLE PER MM 53-11-89-801.SDR 2008UALA01103Frame · crackedFUSELAGE FRAME IS CRACKED BELOW CABIN FLOOR AND OVERWING ON LT SIDE BS 616 (REFMM53-11-89-801) REF NR13410-2400-0007. MAJOR REPAIR ACP'D. REMOVED DAMAGE AND VERIFIED WITH HFEC. INSTALLED A FILLER AND A REPAIR ANGLE PER MM 53-11-89-801.SDR SWAA081123Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 294, RBL 53, WL 208. REMOVED AND REPLACED FRAME PER SRM.SDR WRNA20080027Frame · damagedDURING 'B' CHECK, FASTENERS WERE FOUND LOOSE AND MISSING RIGHT SIDE FRAME TO INTERCOSTAL AT STATION 2674 TO 2680 W/L 305. FABRICATED REPAIR DOUBLER ANGLES IAW SRM 51-40-03 FIGURE 01 AND INSTALLED IAW SRM 51-30-02.
Back to JASC 5311