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 ASAA12411607Frame · crackedBS 616 STUB BEAM LOWER INNER CHORD CRACKED COMMON TO THE LOWEST 2 FASTENER HOLES. ACFT GROUNDED. REPAIRED INNER CHORD IAW T/C AD 20102506-400-53-7.SDR ASAA12411606Frame · crackedRT BS 616 STUB BEAM LOWER INNER CHORD CRACKED, COMMON TO THE LOWEST 2 FASTENER HOLES. ACFT GROUNDED. REPAIRED INNER CHORD IAW T/C AD 20102506-400-53-8.SDR AALA20120525006Frame · crackedTHE 1418 CANT FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER AND STRAP REPAIR PER SRM 53-03-00.SDR FDEA201205251967Frame · dentedFRAME AT BS 660, BETWEEN S24R AND S25R HAS DENT IN UPPER FLANGE, FOUND TO BE OUT OF LIMITS IAW SRM 53-30-07, FIG 101, SH 1. REMOVED AND INSTALLED NEW FRAME IAW SRM 51-40-02 AND DWG 143N1024. MAJOR REPAIR.SDR SWAA2012061504981Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012061504980Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012061404919Frame · corrodedFRAME CORRODED AT BS 500D, BETWEEN STR 23L TO STR 24L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012061404918Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012061404881Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012061404880Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012060704744Frame · corrodedCORROSION ON FRAME AT BS 787, BETWEEN STR 26R & STR 27R. REPAIRED FRAME PER SRM.SDR SWAA2012060604710Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STR 22R AND STR 23R. REPAIRED FRAME IAW SRM.SDR SWAA2012052904442Fastener · missingFRAME FASTENERS MISSING AT BS 420, STR 26R. INSTALLED FASTENERS IAW SRM AND DRAWING.SDR DALA12000546305Frame · crackedDURING INSPECTION CRACK WAS FOUND AT RIGHT TENSION TIE BS 1120 ON TOP FASTENER ROW, 8TH FASTENER HOLE FROM OUTBOARD LOOKING FORWARD. MAINTENANCE REPAIRED PER SRM 53-40-30, REPAIR 1 FIG 201.SDR DALA12000526305Frame · crackedDURING INSPECTION FOUND CABIN UPPER LOBE TENSION TIES AREA BS 1140 STRINGER-10R. FOUND FRAME WEB AT STRINGER CUTOUT CRACKED. MAINTENANCE REPAIR CARRIED OUT AS PER SRM 53-40-07 REPAIR 2 FIG 201.SDR AALA20120523014Beltframe · damagedBELLFRAME IS CUT AT STATION 1681 AFT OF RIGHT NUMBER 4 DOOR AT TOP OF 1681 FLOORBEAM. INSTALLED BELLFRAME DOUBLER REPAIR PER EA B757-53-023825 AND SRM 51-70-11-OG.SDR KCSA201205231098Frame · crackedBS 420 FUSELAGE FRAME WEB CRACKED ABOVE STR 14R.SDR FDEA201205221919Frame · misrepairedFRAME MISREPAIRED BS 535 LONGERON 24R. REPAIRED IAW SRM 53-20-07, FIG 201, REPAIR 1, REV 49. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR FDEA201205221918Frame · misrepairedFRAME MISREPAIRED BS 535. REPAIRED IAW SRM 53-20-07, FIG 201 REPAIR 1, REV 49. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR FDEA201205221917Frame · misrepairedFRAME MISREPAIRED BS 535. REPAIRED AS PER SRM 53-20-07 FIGURE 202 REPAIR 1 REVISION 49. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 114.SDR FDEA201205221916Frame · misrepairedFRAME MISREPAIRED. REPAIRED IAW SRM 53-20-07, FIG 202, REPAIR 1, REV 49. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR USAA2012052500012Frame · crackedQ4 CHECK - CRACK ON FUSELAGE FRAME AT BS 787, S9R. REPAIRED FUSELAGE FRAME AT BS 787, S9R IAW TYPICAL REPAIR TR737-5310-10-287.SDR AALA20120522023Frame · crackedSTATION 727B LEFT FRAME CRACKED AT BIN ATTACH BRACKET FAST HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0006.SDR AALA20120522022Frame · crackedSTATION 400 LEFT FRAME CRACKED AT BIN ATTACH BRACKET FAST HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0006.SDR AALA20120522019Frame · crackedSTATION 887 LEFT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522018Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONER BRACKET AT STATION 500A LEFT. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522017Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONER DUCT BRACKET AT STATION 500D LEFT. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522016Frame · crackedSTATION 727B RIGHT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522015Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONING DUCT BRACKET AT STATION 827 R. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522014Frame · crackedSTATION 440 LEFT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120522013Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONING DUCT BRACKET AT STATION 380L. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522012Frame · crackedSTATION 500A RIGHT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522010Frame · crackedSTATION 480 RIGHT FRAME CRACKED AT BIN ATTACH FASTENER HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522009Frame · crackedSTATION 440 RIGHT FRAME CRACKED AT BIN ATTACH FASTENER HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522007Frame · crackedSTATION 400 RIGHT FRAME CRACKED AT BIN BRACKET ATTACH HOLE. INSTALLED DOUBLER PER ECO J1159AD CARD 0007.SDR ALGA2012052212Frame · crackedFRAME CRACKED BEYOND REPAIRABLE LIMITS.SDR DALA1239890679Frame · damagedAFT CARGO FRAME CORRODED BS 1460 STR 26L-25R. REMOVED SHEAR TIES FOR ACCESS, FOUND SHEAR TIES CRACKED AND CORRODED, COMPLIED WITH ERA 504608-14 REV ORIGINAL.SDR VGCA20120521002Frame · corrodedCORROSION ON FRAME BS 228 RBL 4 - LBL 4 INSIDE FWD ACCESS FOUND BEYOND LIMITS.SDR DALA1233020671Frame · dentedAFT CARGO BAY FRAME DENTED, BS 1320, S26R. REPAIRED IAW SRM 53-00-07.SDR SWAA2012061504965Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW ER & EA.SDR AALA20120613010Frame · corrodedCARGO FLOOR INNER J-FRAME CORRODED. INSTALLED STRAP.SDR SWAA2012060104548Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012060104547Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012052504332Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012052504331Frame · crackedFRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME IAW EA.SDR S9BA201205200001Frame · corrodedINNER FUSELAGE BS 143.95 HAS CORROSION ON SIDE FRAME RIB AND HORIZONTAL STIFFENER. REMOVED CORROSION AND REPAIRED FRAME AND STINGER IAW SRM 53-10-21 AND RD 657-093.SDR SWAA2012052404315Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012052404314Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012060404656Frame · crackedFRAME CRACKED AT BS 312, BETWEEN STR 5L TO STR 6L. REPAIRED FRAME IAW SRM.SDR SWAA2012053104486Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.
Back to JASC 5311