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 SWAA2019032130910Floor Panel · damagedAFT CABIN FLOOR PANEL 242RF DAMAGED UPPER SKIN PLIES. REPAIRED UPPER SKIN PLIES IAW SRM. (BETWEEN BS. 887 TO BS. 1016)SDR SWAA2019031230559Cover · unsecureRT EMERGENCY EXIT HANDLE COVER FELL OFF. R&R COVER IAW SIP.SDR SWAA2022030404533Cover · crackedDURING L/H AILERON BALANCE TAB REMOVAL FOUND # 5 HINGE INBOARD COVER CRACKED / REMOVED AND REPLACED L/H AILERON BALANCE TAB #5 HINGE COVER IAW AMM 27-11-21-400-801 3.E.(4)(D) 59143U 17MAR19SDR SWAA2022030404535Cover · crackedDURING R/H AILERON BALANCE TAB REMOVAL FOUND # 5 HINGE INBOARD COVER CRACKED / REPLACED CRACKED HINGE COVER ON R/H AILERON BALANCE TAB #S IAW AMM 27-11-21-400-801 59143U 16MAR19SDR SWAA2022022421514Flap · delaminatedLEFT WING OUTBOARD AFT FLAP IS DELAMINATED 2' FROM I/B SIDE ON TRAILING EDGE. DAMAGE MEASURES 10' IN LENGHT. MOD / DELAMINATION OF LEFT WING OUTBOARD AFT FLAP 2' FROM I/B SIDE ON TRAILING EDGE REPAIRED ON WORK ORDER #528648. CUSTOMER P.O.# 0270248-E4R. LEFT WISDR SWAA2019040931528Stiffener · crackedLOWER COMPOSITE BULKHEAD HORIZONTAL STIFFENER CRACKED AT BS. 663, LBL 10, BELOW CENTER TANK LOWER SKIN. / R&R STIFFENER IAW SRM AND DWG.SDR SWAA2019040231251Stiffener · crackedLOWER COMPOSITE BULKHEAD VERTICAL STIFFENER CRACKED AT BS 663, LBL 24. R&R STIFFENER IAW SRM & DWG.SDR SWAA2022030404531Panel · delaminatedL/W L/E PANEL 521RB CORNER IS DISBANDED. ( MARKED ) / DISBONDED CORNER ON L/E PANEL 521RB WAS REPAIRED IAW SRM 51-70-05-2R-6 59644U 4/4/19SDR SWAA2019041531694Floorbeam · crackedFLOORBEAM CRACKED AT BS. 328, RBL 56. REPAIRED FLOOR BEAM IAW EA & ER.SDR SWAA2019041531693Frame · crackedFRAME CRACKED AT BS. 294.5, RBL 55. REPAIRED FRAME IAW EA AND ER.SDR SWAA2019041531692Floorbeam · crackedFLOOR BEAM CRACKED AT BS. 294, RBL 52. REPAIRED FLOOR BEAM IAW EA.SDR SWAA2019040931497Attach Angle · crackedVAPOR BARRIER ATTACH ANGLE CRACKED AT BS. 663, LBL 8. / REPAIRED ANGLE IAW EA & ER.SDR SWAA2019032130909Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, RBL 31. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2019032130908Web · corrodedAFT CARGO BAY VERTICAL WEB BETWEEN CORRODED BS 927 TO BS 947, LBL 3. R&R WEB PER SRM AND DWG.SDR SWAA2019032130907Web · corrodedAFT CARGO BAY VERTICAL WEB CORRODED BETWEEN BS 787 TO BS 807, RBL 6. R&R WEB IAW SRM & DWG.SDR SWAA2019032030871Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, LBL 11. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2019032030870Door Sill · crackedL1 DOOR MOP SILL CRACKED AT BS 303, LBL 55. R&R MOPSILL IAW SRM AND DWG.SDR SWAA2019032030869Support Plate · corrodedAFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS 727 TO BS 767, RBL 23. R&R PLATE PER SRM.SDR SWAA2019032030868Support Plate · corrodedAFT CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS 727D TO BS 807, LBL 23. R&R SUPPORT IAW SRM AND DWG.SDR SWAA2019031930780Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 328 TO BS 344, LBL 45. R&R INTERCOSTAL IAW DWG & SRM.SDR SWAA2019031930779Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, LBL 45. R&R INTERCOSTAL IAW DWG AND SRM.SDR SWAA2019031930778Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 277 TO BS 294, RBL 1. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019031930777Cargo Track · crackedAFT CARGO BAY CARGO TIE DOWN TRACK CRACKED IN THE SADDLE AT BS 747, RBL 13. R&R TIE DOWN TRACK IAW SRM & DWG.SDR SWAA2019040931496Pressure Deck · crackedBEADED HORIZONTAL PRESSURE DECK CRACKED BETWEEN BS. 663 TO BS. 675, BETWEEN RBL 30 TO RBL 41. / R&R WEB IAW SRM.SDR SWAA2019040231258Gusset · crackedFORWARD CARGO BAY GUSSET CRACKED AT BS 500D, STR 19L. R&R GUSSET PER SRM & DWG.SDR SWAA2019032531032Pressure Deck · crackedBEADED HORIZONTAL PRESSURE DECK CRACKED BETWEEN BS 663 TO BS 675, BETWEEN LBL 30 TO LBL 60. REPAIRED WEB IAW SRM.SDR SWAA2019032030867Gusset · crackedFORWARD CARGO BAY GUSSET CRACKED AT BS 500D, STR 19R. R&R GUSSET PER SRM & DWG.SDR SWAA2019031930776Fitting · crackedFORWARD CARGO BAY BAFFLE CLIP CRACKED ON THE FORWARD SIDE OF BS 500B, RBL 23. R&R BAFFLE CLIP PER SRM & DWG.SDR SWAA2019040931495Housing · brokenAFT ENTRY CENTER LINE EMERGENCY EXIT LIGHT BROKEN. / R&R LIGHT HOUSING PER SOPM AND AMM.SDR SWAA2019031930775Former · crackedFAIRING FORMER CRACKED AT BS 500D, JUST ABOVE STR 19L. R&R FORMER PER SRM AND DWG.SDR SWAA2022030416147Skin · crackedLEADING EDGE SLAT #8; CRACKED AT 2 EA FASTENER LOCATIONS 2.5' AND 3.5' I/B OF SLAT ACTUATOR ATTACH POINT AT FWD FASTENER ROWS. / LT WING #8 SLAT 2EA CRACKS LOCATIONS 2.5' AND 3.5' I/B OF SLAT ACTUATOR ATTACH POINT AT FWD FASTENER ROW WILL BE REPLACED ON CUST. SDR SWAA2019041231659Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M1673. / R&R BATTERY PACK PER AMM.SDR SWAA2019041231644Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK AT M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019041231643Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M1672. / R&R BATTERY PACK PER AMM.SDR SWAA2019040931512Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1674 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM..SDR SWAA2019040931494Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1675 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM..SDR SWAA2019040931493Skin · crackedEXTERNAL POWER DOOR LOWER CUTOUT CRACKED COMMON TO LOWER LATCH PAD. / REPAIRED CUTOUT PER SRM.SDR SWAA2019022830111Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 1088, STR 15R. R&R STRINGER CLIP IAW SRM.SDR SWAA2019022830151Doubler · crackedLT WHEEL WELL THE CENTER WING REAR SPAR SEAL ASSEMBLY CRACKED AT LBL 15.54. R&R DOUBLER ASSEMBLY PER EA.SDR SWAA2019022630036Slide · low pressureL1 DOOR SLIDE INDICATED IN THE RED, LOW PRESSURE. R&R SLIDE PER MT.SDR SWAA2019022730094Pin · damagedLT MAIN LANDING GEAR SUPPORT BEAM HANGAR LINK LOWER ATTACH PIN DAMAGED. R&R PIN IAW AMM.SDR SWAA2019022730087Lug · corrodedLT WING FORWARD MAIN LANDING GEAR TRUNNION FITTING, UPPER OUTBOARD OUTER LUG FACE CORRODED. REPAIRED LUG PER EA.SDR SWAA2019022730086Lug · corrodedRT WING FORWARD MAIN LANDING GEAR TRUNNION FITTING LOWER INBOARD LUG FACE CORRODED. REPAIRED LUG PER EA.SDR SWAA2022030317132Bracket · crackedL/H WING UPPER PANEL SUPPORT FWD I/B 'Z' ATTACH BRAKET IS CRACKED / REMOVED AND REPLACED 2 ATTACH SUPPORT BRACKET OF L/H WING UPPER PANEL SUPPORT IAW SRM 51-40-02.SDR SWAA2019021829668Battery · dischargedFORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2019021329551Slide · out of positionL1 DOOR GIRT BAR FLAP OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2019012428881Limit Switch · faultyAIR TURNBACK/DECLARED EMERGENCY, ON CLIMBOUT THE NOSE STARTED TO PITCH UP WITHOUT A/P ENGAGED, TRIED NOSE DOWN TRIM AND WOULD NOT WORK. MANUALLY TRIMMED A/C - NO C/B'S POPPED. R&R NOSE DOWN LIMIT SWITCH IAW AMM.SDR SWAA2019012428863Light · inoperativeLT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019012328822Light · inoperativeLT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019012128673Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK PER AMM.
Back to Boeing 737-7Q8