Boeing 737-76N
Service difficulty reports · 4,807
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 = '73776N' 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 = '73776N' 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 SWAA2016110709472Structure · corrodedELECTRONIC AND EQUIPMENT COMPARTMENT OUTER CHORD CORRODED AT BS 336, BETWEEN STR 22L TO STR 23L. R&R CHORD PER ER AND EA.SDR SWAA2016110709471Structure · corrodedELECTRONIC AND EQUIPMENT COMPARTMENT OUTER CHORD CORRODED AT BS 320, BETWEEN STR 22L TO STR 23L. R&R CHORD PER ER AND EA.SDR SWAA2016110109270Frame · corrodedFRAME CORRODED AT BS 336, BETWEEN STR 22L TO STR 23L. R&R FRAME IAW SRM AND DWG.SDR SWAA2016101708874Attach Fitting · corrodedELECTRONICS AND EQUIPMENT COMPARTMENT ATTACH FITTING CORRODED AT BS 336, STRINGER 23L. R & R THE ATTACH FITTING IAW SRM.SDR SWAA2016101708873Attach Fitting · corrodedELECTRONICS AND EQUIPMENT COMPARTMENT ATTACH FITTING CORRODED AT BS 320, STRINGER 23L. R & R THE ATTACH FITTING IAW SRM.SDR SWAA2016101708872Frame · corrodedELECTRONICS AND EQUIPMENT COMPARTMENT FRAME CORRODED AT BS 320, BETWEEN STRINGERS 22 - 23L. R & R FRAME IAW SRM.SDR SWAA2016101708871Attach Fitting · corrodedELECTRONICS EQUIPMENT COMPARTMENT ATTACH FITTING CORRODED AT BS 300, STRINGER 23L. R & R THE ATTACH FITTING IAW SRM.SDR SWAA2016110409395Skin · crackedCENTER WING BOX UPPER SKIN PANEL CRACKED AT BS 540+7, RBL 15.04. REPAIRED SKIN IAW ER AND EA.SDR SWAA2016110709470Web · corrodedAIR STAIR LOWER AUXILIARY SILL WEB CORRODED BETWEEN BS 294.5 TO BS 351.2, BETWEEN STR 23L TO STR 24L. R&R WEB IAW SRM AND DWG.SDR SWAA2016110409394Skate Angle · corrodedVERTICAL FIN RT SKATE ANGLE CORRODED AT BS 1121. R&R SKATE ANGLE IAW SRM.SDR SWAA2016102809153Stringer · corrodedSTRINGER CORRODED AT BS 380, STR 24L. R&R STRINGER IAW SRM.SDR SWAA2016102809152Door Frame · crackedR1 DOOR FORWARD STUB FRAME LOWER HOLE CRACKED AT BS 295. REPAIRED FRAME IAW ER AND EA.SDR SWAA2016100608510Seat Track · corrodedSEAT TRACK CORRODED BETWEEN BS 706 TO 722, RBL 45. REPAIRED THE SEAT TRACK IAW SRM.SDR SWAA2016100508473Seat Track · corrodedPASSENGER CABIN SEAT TRACK CORRODED BETWEEN BS 663 TO 727B, LBL 45. REPAIRED THE SEAT TRACK IAW SRM.SDR SWAA2016110709469Stiffener · crackedRT HORIZONTAL STABILIZER RIB VERTICAL STIFFENER CRACKED AT STA 92.70, 3RD VERTICAL STIFFENER AT LOWER END. REPAIRED STIFFENER IAW SRM.SDR SWAA2016110709468Stiffener · crackedRT HORIZONTAL STABILIZER RIB VERTICAL STIFFENER CRACKED AT STA 92.70, 2ND FROM FORWARD SPAR AT LOWER END. REPAIRED STIFFENER IAW SRM.SDR SWAA2016110109280Rib · crackedLT HORIZONTAL STABILIZER RIB CRACKED AT STA 92.70, SECOND FROM FORWARD VERTICAL STIFFENER AT LOWER END. REPAIRED RIB IAW SRM.SDR SWAA2016101108646Crease Beam · corrodedCREASE BEAM INNER STRUCTURE CORRODED AT BS 616, RBL 63. REPAIRED THE CREASE BEAM IAW EA.SDR SWAA2016100508472Fitting · crackedR1 DOOR FORWARD CUTOUT UPPER DOOR HINGE ARM ATTACH FITTING CRACKED AT BS 297.5. R & R THE FITTING IAW DWG AND SRM.SDR SWAA2016100308390Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016093008322Crease Beam · corrodedMAIN CABIN FLOOR STRUCTURE CREASE BEAM CORRODED BETWEEN BS 685 TO BS 706, LBL 63. REPAIRED CREASE BEAM IAW EA.SDR SWAA2016092908270Crease Beam · corrodedMAIN CABIN FLOOR STRUCTURE CREASE BEAM INNER CHORD CORRODED BETWEEN BS 685 TO 727, RBL 63. REPAIRED IAW EA.SDR SWAA2016092808245Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 294.5 TO 312, BL 0. R & R THE FLOOR SUPPORT IAW SRM & DWG.SDR SWAA2016092608131Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016092608130Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016092608129Frame · crackedFRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016092608128Frame · crackedFRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016092608127Frame · crackedFRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016092608126Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016092608125Mount · corrodedL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR MOUNT CORRODED ON TOP SURFACE. R & R MOUNT IAW SRM AND DWG.SDR SWAA2016092608124Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016092608123Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016092608122Frame · crackedFRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016092608121Frame · crackedFRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016092608120Frame · crackedFRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016092608119Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016092608118Frame · crackedFRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016092108019Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO BS 320, LBL 47.50. R & R INTERCOSTAL IAW DWG AND SRM.SDR SWAA2016091907953Light · inoperativeL2 DOOR OVERHEAD EMERGENCY EXIT SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2016110709467Bulkhead · crackedPRESSURE DOME WEB CRACKED AT BS 1016, RBL 10. REPAIRED WEB IAW ER AND EA.SDR SWAA2016110709466Bulkhead · canningAFT PRESSURE BULKHEAD SKIN OIL CANNING AT BS 1016, BETWEEN STR 2R TO STR 3R. REPAIRED SKIN IAW ER AND EA.SDR SWAA2016101108645Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT CORRODED AT BS 887, LBL 2.5. REPAIRED THE FLOOR SUPPORT IAW SRM.SDR SWAA2016101108643Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT CORRODED AT BS 887, RBL 2.5. REPAIRED THE FLOOR SUPPORT IAW SRM.SDR SWAA2016100608509Angle · corrodedAFT CARGO BAY, FLOOR STRUCTURE Z ANGLE CORRODED BETWEEN BS 727+4 TO 767, RBL 22. R & R THE ANGLE IAW SRM.SDR SWAA2016100308387Floor Support · corrodedAFT COMPARTMENT FLOOR SUPPORT CORRODED BETWEEN BS 787 TO 847. R & R SUPPORT IAW SRM.SDR SWAA2016093008323Shield · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE SHIELD Z-ANGLE CORRODED BETWEEN BS 767 TO BS 794, RBL 22. R&R SHIELD IAW DWG AND SRM.SDR SWAA2016093008321Angle · corrodedAFT COMPARTMENT Z CHANNEL CORRODED BETWEEN BS 727E TO BS 770, STR 25L. R&R Z ANGLE IAW SRM AND DWG.SDR SWAA2016092808244Web · corrodedAFT CARGO DOOR SURROUND STRUCTURE SILL WEB CORRODED BETWEEN BS 787 TO 847. R & R WEB IAW SRM & DWG.SDR SWAA2016091907952Lens · looseAFT GALLEY RT OVERHEAD EXIT DOOR LENS LIGHT ASSEMBLY LOOSE. SECURED LIGHT ASSEMBLY IAW AMM.SDR SWAA2016091907951Cover · out of adjustAFT EMERGENCY EXIT LIGHT BUTTON COVER SPRING OUT OF ADJUST. ADJUSTED COVER IAW AMM.
Back to Boeing 737-76N