Boeing 737-7Q8
Service difficulty reports · 3,964
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 = '7377Q8' 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 = '7377Q8' 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 SWAA2016060652344Support Strap · corrodedFLOOR PANEL SUPPORT STRAP CORRODED AT BS 767, BETWEEN LBL 21 - RBL 21. R & R STRAP IAW SRM & DWG.SDR SWAA2016060652343Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 767 - 795, RBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016060652342Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 - 767, RBL 21. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016060652296Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 727D+5, LBL 8. REPAIRED RAIL IAW EA.SDR SWAA2016060652295Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 727D+ 5, LBL 12. REPAIRED RAIL IAW EA.SDR SWAA2016060652294Support Strap · corrodedAFT CARGO BAY FLOOR PANEL SUPPORT STRAP CORRODED AT BS 727D+5, BETWEEN LBL 21 - RBL 21. REPAIRED STRAP IAW SRM & DWG.SDR SWAA2016060652293Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 757 - 787, LBL 21. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016060652292Floor Support · corrodedCARGO FLOOR PANEL SUPPORT RAIL CORRODED AT BS 767, RBL 13. R & R RAIL IAW SRM.SDR SWAA2016060652291Floor Support · corrodedCARGO FLOOR PANEL SUPPORT RAIL CORRODED AT BS 767, RBL 8. R & R RAIL IAW EA.SDR SWAA2016060652290Floor Support · corrodedCARGO FLOOR PANEL SUPPORT RAIL CORRODED AT BS 767, RBL 3. REPAIRED RAIL IAW EA.SDR SWAA2016060652289Floor Support · corrodedCARGO FLOOR PANEL SUPPORT RAIL CORRODED AT BS 767, LBL 3. REPAIRED RAIL IAW EA.SDR SWAA2016060652306Frame · corrodedAFT CARGO BAY FRAME UPPER SURFACE CORRODED AT BS 727D, BETWEEN RBL 20 - 30. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016060652305Support Strap · corrodedAFT CARGO BAY FLOOR PANEL SUPPORT STRAP CORRODED AT BS 887, BETWEEN LBL 8 - RBL 20. R & R STRAP IAW SRM & DWG.SDR SWAA2016060652304Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 867 - 887, RBL 22. REPAIRED SUPPORT IAW SRM & DWG.SDR SWAA2016060652303Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT WEB CORRODED BETWEEN BS 847 - 867, RBL 22. R & R WEB IAW SRM.SDR SWAA2016060652302Intercostal · corrodedAFT CARGO BAY INTERCOSTAL WEB CORRODED BETWEEN BS 727A - 727B, LBL 21. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016060652301Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727D - 747, LBL 21. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016060652300Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 727D+5, RBL 13. REPAIRED RAIL IAW SRM.SDR SWAA2016060652299Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 727D+ 5, RBL 8. REPAIRED RAIL IAW SRM & EA.SDR SWAA2016060652298Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 727D+5, RBL 3. REPAIRED RAIL IAW EA.SDR SWAA2016060652297Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 727D+5, LBL 3. REPAIRED RAIL IAW EA.SDR SWAA2016060652288Floor Support · corrodedCARGO FLOOR PANEL SUPPORT RAIL CORRODED AT BS 767, LBL 8. REPAIRED RAIL IAW EA.SDR SWAA2016060652287Floor Support · corrodedCARGO FLOOR PANEL SUPPORT RAIL CORRODED AT BS 767, LBL 12. R & R RAIL IAW EA.SDR SWAA2016060652286Floor Support · corrodedCARGO FLOOR PANEL SUPPORT RAIL CORRODED AT BS 767, LBL 17. REPAIRED RAIL IAW SRM.SDR SWAA2016060852638Intercostal · crackedINTERCOSTAL FLANGE CRACKED AT BS 349, RBL 5. REPAIRED FLANGE IAW SRM.SDR SWAA2016060652348Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 - 328, RBL 34. R & R INTERCOSTAL IAW SRM.SDR SWAA2016060652341Web · corrodedFORWARD CARGO COMPARTMENT DOOR, THRESHOLD SUB WEB CORRODED BETWEEN BS 440 - 500, BETWEEN RBL 21 - 25. R & R WEB IAW SRM.SDR SWAA2016060652340Support · corrodedFORWARD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 495 - 500A, RBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016060652339Support · corrodedFORWARD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 400 - 500D, LBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016060652338Door Frame · crackedR1 DOOR SURROUND STRUCTURE FWD FRAME CRACKED AT BS 294, RBL 54, LOWER INBD END. REPAIRED FRAME IAW ER & EA.SDR SWAA2016060652337Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 - 328, LBL 45. R & R INTERCOSTAL IAW SRM.SDR SWAA2016052051965Intercostal · crackedINTERCOSTAL CRACKED, BETWEEN BS 947 - 927, RBL 20. R & R INTERCOSTAL IAW SRM.SDR SWAA2016041150765Retaining Clip · out of adjustR1 DOOR EMER EVAC SLIDE GIRT BAR RETAINING CLIPS OUT OF ADJUSTMENT. ADJUSTED CLIP IAW SIP.SDR SWAA2016052051964Plate · crackedRIGHT WING LOWER TE WAFFLE PLATE CRACKED JUST INBD OF NR 2 PYLON AFT TIP. R & R WAFFLE PLATE IAW SRM.SDR SWAA2016052051963Plate · crackedLEFT WING LOWER TE WAFFLE PLATE CRACKED JUST INBD OF NR 1 PYLON AFT TIP. R & R WAFFLE PLATE IAW SRM.SDR SWAA2016051951920Angle · crackedLEFT WING TE COVE SEAL RETAINING ANGLE CRACKED ABOVE NR 1 PYLON AFT TIP. R & R ANGLE IAW SRM.SDR SWAA2016052051974Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22L. REPAIRED SKIN IAW ER & EA.SDR SWAA2016040450539Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT OF CASE, DID NOT DEPLOY STILL OPERATIONAL. REINSTALLED SLIDE IAW AMM & MT.SDR SWAA2016040850705Rib · crackedLEFT HORIZONTAL STABILIZER RIB AT STATION 92.70, THIRD STIFFENER FROM FWD END CRACKED. REPAIRED RIB IAW SRM.SDR SWAA2016040850704Rib · crackedLEFT HORIZONTAL STABILIZER RIB AT STATION 92.70, SECOND STIFFENER FROM FWD END CRACKED. REPAIRED RIB IAW SRM.SDR SWAA2016040850703Rib · crackedRIGHT HORIZONTAL STABILIZER RIB AT STATION 92.70, SECOND STIFFENER FROM FWD END CRACKED. REPAIRED RIB IAW SRM.SDR SWAA2016051351775Attach Angle · corrodedAFT CARGO BAY ON ATTACH ANGLE FOR FLOOR TO SIDEWALL SUPPORT PLATE TO INTERCOSTAL CORRODED, BETWEEN BS 767 - 787, RBL 21. R & R ANGLE IAW SRM.SDR SWAA2016051351774Frame Splice · corrodedAFT CARGO BAY ON FRAME SPLICE CAP CORRODED AT BS 747, BETWEEN STRINGER 24R - 25R. R & R SPLICE CAP IAW DWG & SRM.SDR SWAA2016051351773Support · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED, BETWEEN BS 887 - 947, RBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016051351772Support · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED, BETWEEN BS 727+4 - 847, LBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016051151699Support · corrodedFORWARD CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED, BETWEEN BS 500 - 500D, LBL 24. R & R SUPPORT IAW SRM.SDR SWAA2016042151163Support · corrodedFORWARD CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED, BETWEEN BS 492 - 500A, RBL 24. R & R PLATE IAW SRM.SDR SWAA2016042151175Support · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED, BETWEEN BS 867 - 887, RBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016042151174Support · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED, BETWEEN BS 847 - 867, RBL 21. R & R PLATE IAW SRM & DWG.SDR SWAA2016042151173Support · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED, BETWEEN BS 767 - 794, RBL 22. R & R PLATE IAW SRM.
Back to Boeing 737-7Q8