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 DALA13045183760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 727B, STR 8R FRAME CRACKED. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV 1 AND FINAL ERA 517821-14AD, REV ORIGINAL.SDR DALA13045173760Frame · crackedDURING INSPECTION, FOUND CABIN BS 480, STR 8R FRAME CRACKED. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV 1 AND FINAL ERA 517821-14AD, REV ORIGINAL.SDR DALA13045163760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 400, STR 8R FRAME CRACKED. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV 1 AND FINAL ERA 517821-14, REV ORIGINAL.SDR DALA13045153760Frame · crackedDURING INSP, FOUND CABIN BS 480, STRINGER 8L FRAME CRACKED. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV 1 AND FINAL ERA 517821-14AD, REV ORIGINAL.SDR DALA13045143760Frame · crackedDURING INSPECTION, FOUND CABIN BS 500A, STRINGER 8R, FRAME CRACKED. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV 1 AND FINAL ERA 517821-14AD REV ORIGINAL.SDR DALA13045133760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 440, STR 8R, FRAME CRACKED. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV 1 AND FINAL ERA 517821-14AD, REV ORIGINAL.SDR DALA13045313760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 727B, STRINGER 8L, FRAME CRACKED. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV 1 AND FINAL ERA 517821-14, REV ORIGINAL.SDR DALA13044593760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN STA 480 FRAME CRACKED, STRINGER 8L. REPAIRED FRAME IAW PRI ERA 517821-14AD REV ORIGINAL AND FINAL ERA 517821-14AD REV ORIGINAL.SDR DALA13044583760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 440 FRAME CRACKED, STRINGER 8L. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV ORIGINAL AND FINAL ERA 517821-14AD REV ORIGINAL.SDR DALA13044573760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 727B FRAME CRACKED, STRINGER 8R. MX REPAIRED FRAME IAW PRI ERA 517821-14AD REV ORIGINAL AND FINAL ERA 517821-14AD REV ORIGINAL.SDR DALA13044563760Frame · crackedDURING INSPECTION FOUND PASSENGER CABIN BS 480 FRAME CRACKED, STRINGER 8R. MX REPAIRED FRAME IAW PRI ERA 517821-14AD REV ORIGINAL AND FINAL ERA 517821-14AD REV ORIGINAL.SDR DALA13044553760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 500A FRAME CRACKED, STRINGER 8R. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV ORIGINAL AND FINAL ERA 517821-14AD, REV ORIGINAL.SDR DALA13044543760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 440 FRAME CRACKED STRINGER 8R. MX REPAIRED FRAME IAW PRI ERA 517821-14AD, REV ORIGINAL AND FINAL ERA 517821-14AD, REV ORIGINAL.SDR DALA13044533760Frame · crackedDURING INSPECTION, FOUND CABIN BS 400, FRAME CRACKED STRINGER 8R. MX REPAIRED FRAME IAW PRI ERA 517821-14AD REV ORIGINAL AND FINAL ERA 517821-14, REV ORIGINAL.SDR DALA13044523760Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 727B FRAME CRACKED STRINGER 8L. MX REPAIRED FRAME IAW ERA 517821-14AD, REV ORIGINAL AND FINAL ERA 517821-14, REV ORIGINAL.SDR FDEA201309142228Frame · dentedBULK CARGO BAY BS 1480 FRAME IS DENTED ABOVE S26L. REPAIRED IAW EA F-5310-T0303262 P1. CATEGORY 'B' MAJOR REPAIR.SDR FDEA201309142227Frame · dentedAFT CARGO BAY, BS 1340 S26R FRAME INBD FLANGE DENTED. DENT WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG. 101. REPAIRED IAW EA F-5310-T0303259. CATEGORY B MAJOR REPAIR.SDR SWAA2013100320728Frame · crackedFRAME CRACKED AT BS 947.5 STRINGER 18R. R & R FRAME IAW DRAWING & SRM.SDR SWAA2013093020573Frame · crackedFRAME CRACKED AT BS 500B STRINGER 20R. REPAIRED FRAME IAW SRM.SDR SWAA2013093020561Frame · crackedFRAME CRACKED AT BS 947.5 STRINGER 18L. R & R FRAME IAW SRM & DRAWING.SDR CALA2013091891280Frame · dentedAFT PIT FRAME DENT REPAIR AT BS 1420 & STRINGER 26L-27L. DAMAGE FOUND OUT OF SRM LIMIT WAS TRIMMED OUT & NDT OF CUT-OUT & HOLES ACP IAW NTM 51-00-16 & 51-00-19. NO CRACKS. FABRICATED & INSTALLED J SECTION REPAIR IAW SRM53-00-07 REPAIR 5 FIG 201.SDR FDEA201309142226Frame · dentedBULK CARGO BAY BS 1500 FRAME IS DENTED S25-26L. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07 FIG 101. REPAIRED IAW EA F-5310-T0302979.SDR SWAA2013112522749Frame · corrodedFUSELAGE FRAME CORRODED AT BS 427, BETWEEN LONGERONS 25R & 26R. REPAIRED LONGERON IAW SRM.SDR SWAA2013100720864Frame · corrodedFRAME CORRODED AT BS 747 BETWEEN STRINGER 27L TO STRINGER 27R. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013100320727Frame · crackedFRAME CRACKED BS 907 BETWEEN STRINGER 25R TO STRINGER 26R. REPAIRED FRAME IAW SRM.SDR CALA2013091600660Frame · crackedCABIN, DURING INSPECTION, MID-FEC, FOUND CRACK INDICATION AT FRAME STATION 500A L, BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING EXTRUSION SUPPORT ATTACHMENT TO FS FRAME, MARKED. IAW EA 5310-04716 REV E OPT 1 REPAIRED FS FRAME STATION 500L IAW EA 5310-04716 REVSDR AALA20130913007Frame · corrodedCORROSION AT STATION 1322 & LONGERON 30. ACCOMPLISHED DOUBLER REPAIR.SDR FOTR2013102500025Frame · corrodedAFT CARGO BAY BS 727D, STR 25-26R FRAME CORRODED. REPAIRED.SDR FDEA201309122194Frame · chafedBS 1100, S8-9L, FRAME INNER FLANGE CHAFED. CHAFE REMOVED IAW SRM 51-10-02 REV 109. FOUND OUT OF LIMITS IAW SRM 53-00-07 FIG 101 REV 109. REPAIRED IAW SRM 53-00-07 REPAIR 3 FIG 201 REV 109. REPAIR CLASSIFIED AS MAJOR.SDR SCNA20131002149Frame · chafedFUSELAGE LT FRAME BS 727A HAS A CHAFED SPOT, APPROXIMATELY 2 INCHES ABOVE FLOOR. BLENDED FRAME AND FOUND TO BE OUT OF LIMITS. REPAIRED IAW EA 15339.SDR FDEA201309122187Frame · dentedFRAME FOUND DENTED AT BS 1641, LONGERON 12 RIGHT. REPAIRED IAW SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 53. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 117.SDR SWAA2013100921027Frame · crackedFS FRAME CRACKED AT BS 907 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013100921026Frame · crackedFS FRAME CRACKED AT BS 907 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013100320734Frame · crackedFUSELAGE FRAME CRACKED AT BS 727D STRINGER 8L. REPAIRED FRAME IAW ER & EA.SDR SWAA2013100320733Frame · crackedFS FRAME CRACKED AT BS 360 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SIMA20130911012Frame · gougedFRAME 70 BETWEEN STR 12-13R GOUGED. REPAIRED IAW AEA EO EM-53MR-2193.SDR SWAA2013093020566Frame · crackedFUSELAGE FRAME CRACKED AT BS 827 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013092520480Frame · crackedFUSELAGE FRAME CRACKED AT BS 727D STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013092420448Frame · crackedFUSELAGE FRAME CRACKED AT BS 787 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013092420447Frame · crackedFUSELAGE FRAME CRACKED AT BS 727A STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013092320351Frame · crackedFS FRAME CRACKED AT BS 867 STRINGER 8L. REPAIRED FRAME IAW SW EA.SDR SWAA2013092320350Frame · crackedFS FRAME CRACKED AT BS 827 STRINGER 8L. REPAIRED FRAME IAW SW EA.SDR SWAA2013092320349Frame · crackedFS FRAME CRACKED AT BS 747 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013092320348Frame · crackedFS FRAME CRACKED AT BS 500C STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013092320347Frame · crackedFS FRAME CRACKED AT BS 500A STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013092320346Frame · crackedFS FRAME CRACKED AT BS 867 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013092320345Frame · crackedFS FRAME CRACKED AT BS 440 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013092320344Frame · crackedFS FRAME CRACKED AT BS 400 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013091920296Frame · crackedFS FRAME CRACKED AT BS 380 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013091820223Frame · crackedFRAME CRACKED AT BS 520, STRINGER 8L. REPAIRED FRAME IAW EA.
Back to JASC 5311