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 SWAA2016112809962Web · corrodedR/H LOWER CREASE BEAM WEB CORRODED BETWEEN BS 706 TO 727. R & R THE WEB IAW SRM AND DWG.SDR SWAA2016112809961Web · corrodedRIGHT CREASE BEAM WEB LOWER SIDE CORRODED AT BS 685+13. R & R THE WEB IAW DWG AND SRM.SDR SWAA2016112809960Cargo Track · corrodedAFT CARGO BAY CARGO TRACK CORRODED BETWEEN BS 792 TO 847, RBL 12. R & R THE CARGO TRACK IAW SRM.SDR SWAA2016111809852Crease Beam · corrodedLEFT CREASE BEAM CORRODED AT BS 685 TO 727. REPAIRED THE CREASE BEAM IAW SRM.SDR SWAA2016111809851Crease Beam · corrodedLEFT CREASE BEAM CORRODED AT BS 706. REPAIRED THE CREASE BEAM IAW SRM.SDR SWAA2016111709804Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500D, STR 19R. R&R CLIP IAW SRM AND DWG.SDR SWAA2016111709803Crease Beam · corrodedRT CREASE BEAM CORRODED FORWARD AND AFT OF BS 706. R&R CREASE BEAM IAW SRM AND DWG.SDR SWAA2016111409648Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 260 TO BS 270, BL 0. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2016111409647Shield · corrodedAFT CARGO COMPARTMENT FLOOR WEB SHIELD CORRODED BETWEEN BS 847 TO BS 867, RBL 17. R&R SHIELD IAW SRM & DWG.SDR SWAA2016111409646Threshold · corrodedAFT CARGO COMPARTMENT LOWER DOOR CUTOUT FLOOR THRESHOLD WEB UPPER SURFACE CORRODED. REPAIRED WEB IAW SRM AND DWG.SDR SWAA2016111409645Attach Angle · corrodedAFT CARGO COMPARTMENT FLOOR WEB ATTACH ANGLE CORRODED BETWEEN BS 767 TO BS 792, RBL 22. R&R ANGLE IAW SRM AND DWG.SDR SWAA2016111409644Web · corrodedAFT CARGO COMPARTMENT WEB CORRODED BETWEEN BS 767 TO BS 792, RBL 21. R&R WEB IAW SRM AND DWG.SDR SWAA2016111409643Angle · corrodedAFT CARGO COMPARTMENT Z ANGLE CORRODED BETWEEN BS 727 TO BS 767, RBL 21. REPAIRED Z ANGLE IAW SRM.SDR SWAA2016111409639Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500D, STR 19L. R&R CLIP IAW SRM AND DWG.SDR SWAA2016111409638Angle · corrodedAFT CARGO COMPARTMENT Z ANGLE CORRODED AT RT BS 727D. R&R Z ANGLE IAW SRM AND DWG.SDR SWAA2016111009587Angle · corrodedAFT CARGO BAY ZEE ANGLE CORRODED BETWEEN BS 757 TO 847, LBL 21. R & R THE ANGLE IAW SRM.SDR SWAA2016111009586Angle · corrodedAFT CARGO BAY ZEE ANGLE CORRODED BETWEEN BS 727 TO 757, LBL 21. R & R THE ANGLE IAW SRM.SDR SWAA2016110209308Cover · missingRT OVERWING DOOR WALL MOUNTED EMERGENCY EXIT SIGN COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2016111709822Fitting · crackedFORWARD CARGO COMPARTMENT BAFFLE CLIP CRACKED AT BS 500B, STR 26L. R&R CLIP IAW SRM AND DWG.SDR SWAA2016111409642Angle · corrodedFORWARD CARGO COMPARTMENT FLOOR STRUCTURE RT SIDE SHIELD Z ANGLE CORRODED BETWEEN BS 490 TO BS 500A. R&R Z ANGLE IAW BAC DWG.SDR SWAA2016111409641Floorbeam · corrodedCABIN FLOOR SUPPORT CORRODED AT BS 270, BETWEEN LBL 9 TO RBL 7. REPAIRED SUPPORT IAW SRM AND EA.SDR SWAA2016110909544Support Angle · corrodedGIRT BAR FITTING SUPPORT ANGLE CORRODED AT BS 344, LBL 60. R & R THE SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2016110909543Floor Support · crackedCABIN FLOOR SUPPORT IS CRACKED BETWEEN BS 278 TO 294, BL 0. R & R THE FLOOR SUPPORT IAW DWG & SRM.SDR SWAA2016110709458Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, LBL 47. R&R INTERCOSTAL IAW DWG AND SRM.SDR SWAA2016110709457Pressure Panel · crackedRT WHEEL WELL VERTICAL PRESSURE BULKHEAD WEB CRACKED AT BS 663, RBL 33. REPAIRED WEB IAW SRM.SDR SWAA2016110709456Bracket · crackedLT WING TRAILING EDGE LOWER BULB SEAL BRACKET CRACKED ON FORWARD SIDE. R&R BRACKET IAW SRM AND DWG.SDR SWAA2016110709455Baffle · crackedFORWARD CARGO COMPARTMENT BAFFLE CRACKED BETWEEN BS 500C TO BS 500D, STR 25R. R&R BAFFLE IAW DWG AND SRM.SDR SWAA2016110409383Floor Support · crackedAFT CARGO FLOOR SUPPORT CRACKED AT BS 767, RBL 17. R&R SUPPORT IAW SRM.SDR SWAA2016110109254Support Angle · crackedAFT CARGO LT SIDEWALL STRUCTURE FLOOR SUPPORT ANGLE CRACKED AT BS 867, LBL 20. R&R ANGLE IAW DWG.SDR SWAA2016110109253Strap · corrodedAFT CARGO LOWER SURFACE OF SUPPORT STRAP CORRODED BETWEEN BS 792 TO BS 798, RBL 19. R&R STRAP IAW SRM & DWG.SDR SWAA2016110109244Angle · corrodedAFT CARGO LT Z ANGLE CORRODED BETWEEN BS 727 TO BS 847. REPAIRED Z ANGLE IAW SRM.SDR SWAA2016102609102Rib · crackedLT HORIZONTAL STABILIZER RIB CRACKED AT STA 129.50, 3RD STIFFENER FROM FORWARD EDGE. REPAIRED RIB IAW EA.SDR SWAA2016112910055Crease Beam · corrodedR2 DOOR CREASE BEAM CORRODED BETWEEN BS 947+6 TO BS 986+8. R&R CHORD IAW DWG & AMM.SDR SWAA2016110109243Seat Track · corrodedCABIN SEAT TRACK CORRODED BETWEEN BS 847 TO BS 867, RBL 45. REPAIRED SEAT TRACK IAW SRM.SDR SWAA2016102609109Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 360 TO BS 344, LBL 13. R&R INTERCOSTAL IAW DWG AND SRM.SDR SWAA2016102409050Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, RBL 33. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2016101908920Girt Bar · corrodedL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR MOUNT FITTING CORRODED AT BS 344. R&R AFT GIRT BAR IAW SRM.SDR SWAA2016101908919Intercostal · crackedINTERCOSTAL CRACKED AT BS 328, LBL 47. R&R INTERCOSTAL IAW DWG.SDR SWAA2016101808888Mount · corrodedL1 DOOR FORWARD GIRT BAR MOUNT FITTING CORRODED AT BS 312. R&R GIRT BAR MOUNT IAW SRM.SDR SWAA2016101708855Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2016102709140Intercostal · corrodedFLOOR BOARD SUPPORT INTERCOSTAL CORRODED AT BS 540, BETWEEN RBL 24 TO RBL 0. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2016110109252Bulkhead · crackedRT MAIN LANDING GEAR WHEEL WELL FORWARD PRESSURE BULKHEAD CRACKED AT BS 663, RBL 31. REPAIRED WEB IAW SRM.SDR SWAA2016102509078Intercostal · crackedAFT OF FORWARD PIT INTERCOSTAL CRACKED BETWEEN BS 500D TO BS 520, BL 0. R&R INTERCOSTAL IAW DWG AND SRM.SDR SWAA2016110709454Angle · corrodedFORWARD PIT FLOOR SHIELD Z ANGLE CORRODED BETWEEN BS 500B TO BS 500D, RBL 27. REPAIRED Z ANGLE IAW SRM.SDR SWAA2016110109251Angle · corrodedFORWARD PIT FLOOR SHIELD Z ANGLE CORRODED AT BS 500C+12, LBL 26. REPAIRED Z ANGLE IAW SRM.SDR SWAA2016110109250Bracket · crackedLT WING TRAILING EDGE CAVITY 10 INCHES INBOARD OF DEFLECTION CONTROL RIB APPROXIMATE WBL 191 LOWER BULB SEAL BRACKET CRACKED. R&R BRACKET IAW SRM & DWG.SDR SWAA2016110109249Bracket · crackedLT WING TRAILING EDGE CAVITY 10 INCHES INBOARD OF DEFLECTION CONTROL RIB APPROXIMATE WBL 191 UPPER BULB SEAL BRACKET CRACKED. R&R BRACKET IAW SRM & DWG.SDR SWAA2016101708801Turbine · leakingDIVERSION/DECLARED EMERGENCY, AT 6000FT NR 1 ENGINE LOW OIL INDICATION, FROM 14PSI - 0 PSI ENGINE OIL TEMPERATURE AMBER AT 143 DEGREES, TEMPERATURE NEVER ABOVE REDLINE. FOUND OIL LEAK FROM NR 4 BEARING HPT. R&R NR 1 ENGINE PER MT.SDR SWAA2016101108570Ballast · faultyELECTRICAL SMELL NEAR AFT GALLEY. R&R BALLAST PER AMM.SDR SWAA2016101908918Frame · crackedFRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME IAW EA.
Back to Boeing 737-76N