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 SWAA2019012128672Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM.SDR SWAA2019012128671Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM.SDR SWAA2019012128670Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER AMM.SDR SWAA2019012128669Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER AMM.SDR SWAA2019012128668Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01674. R&R BATTERY PACK PER AMM.SDR SWAA2019012128657Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR SWAA2019012128637Slide · out of positionR1 DOOR ESCAPE SLIDE FLAP OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2019011728603Fitting · looseR2 DOOR AFT GIRT BAR LATCH LOOSE. R&R FITTING PER AMM.SDR SWAA2022030215433Support Angle · crackedQC - VERTICAL SUPPORT ANGLE IN LH MLG BAY CRACKED AT LOWER END; BS 663; LBL 28; WL 152. / REMOVED & REPLACED VERTICAL SUPPORT ANGLE FROM L/H MLG BAY BS. 663; LBL 28 WL 152 IAW DWG 111A1000 REV. F 59191U 12JAN19SDR SWAA2019011628541Gusset · corrodedGUSSET CORRODED BETWEEN BS 847 TO BS 855, RBL 25. R&R GUSSET PER SRM AND DWG.SDR SWAA2022030120971Fairing · delaminatedPANEL 193 B IS DELAMINATED AT FWD L/H CORNER. DAMAGE MEASURES 4' X 5' MOD / REMOVED & INSTALLED NEW 193B PANEL REF AMM 53-51-21SDR SWAA2019010928345Sensor · faultyDIVERSION, "LE FLAPS TRANSIT" INDICATION WITH FLAPS EXTENDED. R&R NR 4 RETRACT SENSOR PER AMM.SDR SWAA2019011528436Lens · looseRT EMERGENCY LIGHT ASSEMBLY LENS LOOSE AT ROW 8. SECURED LENS IAW AMM.SDR SWAA2019011528435Lens · looseRT EMERGENCY LIGHT ASSEMBLY LENS LOOSE BETWEEN AT ROW. SECURED LENS IAW AMM.SDR SWAA2019011528430Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500C, LBL 21. R&R CLIP PER DWG AND SRM.SDR SCNA20190102002Fence · crackedNR 2 ENG PRIMARY EXHAUST NOZZLE HAS CRACKED FENCE THAT IS OUT OF LIMITS. REMOVED AND REPLACED NR 2 ENGINE LT PRIMARY EXHAUST NOZZLE FENCE.SDR SWAA2019010328173Hook · out of adjustR1 DOOR EVAC SLIDE GIRT BAR AFT HOOK OUT OF ADJUST. ADJUSTED HOOK PER MM.SDR SWAA2019010328104Hook · out of adjustR1 DOOR EVAC SLIDE GIRT BAR FWD HOOK OUT OF ADJUST. ADJUSTED HOOK PER MM.SDR SWAA2019010328172Battery · failedEMERGENCY EXIT LIGHT BATTERY M1675 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328022Battery · failedEMERGENCY EXIT LIGHT BATTERY M1670 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019011528280Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 318, LBL 47. R&R SUPPORT PER SRM AND DWG.SDR SWAA2022030120486Balance Weight · corroded8 EACH BALANCE WEIGHT HAVE SURFACE CORROSION; WEIGHTS ARE INSTALLED ON ELEVATOR BAY #5 BALANCE PANEL. / R&R L/H ELEVATOR AS PER AMM 27-31-11 ON N/R D184394 POS: L/H TAG: 489261 PN/OFF: 002A0016-31 S/N OFF; 001131 PN/ON: 183A0103-11 S/N ON; 001713SDR SWAA2018121427690Trim Motor · faultyAIR TURNBACK/DECLARED EMERGENCY, ON CLIMB WE GOT THE "STAB OUT OF TRIM" RAN THE QRH AND LANDED NORMAL. R&R STAB TRIM MOTOR PER MM.SDR SWAA2022022415416Floor Panel · delaminatedMAIN CABIN FLOOR PANEL 231XF UPPER SURFACE DELAMINATED. / DUE TO EXTENT OF DAMAGE; FABRICATED A REPLACEMENT PANEL FOR MAIN CABIN FLOOR PANEL 231XF FROM BMS 4-23 TYPE II LOT# 1368331-1; INSTALLED ALL INSERTS WITH RESIN BMS5-107 LOT# AK8EP4363K; AND PART MARKED SDR SWAA2022022415417Floor Panel · delaminatedMAIN CABIN FLOOR PANEL 241AF UPPER SURFACE DELAMINATED. / DUE TO EXTENT OF DAMAGE; OPTED TO FABRICATED A NEW PANEL; AND ROUGH-CUT NEW PANEL PER DWG 144A5810-8 IAW SRM 53-00-50-2R-0 PARA 1A-NOTE'. 59198U 12.14.18 10524C 12/14/18 FINISHED FABRICATION IAW SRM 53-SDR SWAA2019011528210Vapor Barrier · deterioratedVAPOR BARRIER DETERIORATED AT BS 663, RBL 10.845. REPAIRED BARRIER IAW SRM.SDR SWAA2019011528163Vapor Barrier · deterioratedLT WHEEL WELL VAPOR BARRIER DETERIORATED AT BS 663, LBL 25. REPAIRED BARRIER IAW SRM.SDR SWAA2019010928316Structure · corrodedLT HORIZONTAL STABILIZER CORRODED BETWEEN BS 265 TO APPROXIMATELY BS 245. R&R STABILIZER PER AMM.SDR SWAA2019010927898Stabilizer · corrodedLT HORIZONTAL STABILIZER CORRODED BETWEEN BS 265 TO APPROXIMATELY BS 245. R&R LEADING EDGE STABILIZER PER AMM.SDR SWAA2022022815414Tail Cone · debondedTAILCONE DISBONDED AT STA 1163.5; LBL 12. / REPAIRED DAMAGE ON TAILCONE AT STA 1163.5; LBL 12 IAW SRM 51-70-04-2R-2. 56749U 31DEC18SDR SWAA2022022515404None · crackedFWD CARGO BAY INTERCOSTAL CLIP AT BS 400 LBL 21 W/L 156 IS CRACKED / REMOVED & REPLACED FWD CARGO BAY INSTERCOSTAL CLIP AT BS400; LBL21; WL156 IAW SRM 51-40-02-0G-0 STEP 4 AND 7.D. 56790U 07JAN19SDR SWAA2019011528429Fitting · crackedFORWARD CARGO BAY INTERCOSTAL CLIP CRACKED AT BS 500C, LBL 21. R&R CLIP PER DWG & AND SRM.SDR SWAA2019010928315Spar · corrodedRT HORIZONTAL STABILIZER AFT SPAR UPPER CHORD CORRODED BETWEEN 24 AND 36 INCHES FROM OUTBOARD END. R&R LEADING EDGE STABILIZER PER AMM.SDR SWAA2019010927899Spar · corrodedRT HORIZONTAL STABILIZER AFT SPAR UPPER CHORD CORRODED BETWEEN 24 AND 36 INCHES FROM OUTBOARD END. R&R STABILIZER PER AMM.SDR SWAA2022022215409Plate · brokenL/W T/E WIGGLE PLATE JUST I/B OF #1 PYLON IS BROKEN / REMOVED BROKEN WIGGLE PLATE FROM L/W T/E JUST I/B OF #1 PYLON. INSTALLED NEW WIGGLE PLATE IAW SRM 51-40-02-0G-0 PARA 4. & IPC 57-50-00-30.SDR SCNA20181209132Light · inoperative21ABC EMERGENCY LIGHT INOP. R&R LAMP 21ABC EMERGENCY LIGHT. OPS CHECK OK.SDR SWAA2022022815387Panel · elongatedR/W T/E PANEL 671BB HAS A ELONGATED HOLE. ( MARKED ) / REPAIRED ELONGATED HOLE ON R/W T/E PANEL 671BB IAW SRM 51-70-05-2R-6 59278U 12/17/18SDR SWAA2019011528431Stiffener · crackedVAPOR BARRIER FOUND A TEE STIFFENER CRACKED AT BS 663, LBL 25. R&R STIFFENER IAW DWG.SDR SWAA2019011528117Rib · crackedLT HORIZONTAL STABILIZER REMOVABLE LEADING EDGE 5TH RIB FROM INBOARD END CRACKED. REPAIRED RIB IAW SRM & DWG.SDR SWAA2019011528116Rib · crackedRT HORIZONTAL STABILIZER REMOVABLE LEADING EDGE 3RD RIB FROM INBOARD END CRACKED. R&R RIB IAW SRM & DWG.SDR SWAA2022022815370Strap · corroded***CORROSION*** ON TENSION STRAP AT AFT CABIN BS1016+10 RBL17 WL208.1. MARKED / REPAIRED THE TENSION STRAP AT BS 1016-110 RBL 17 WL 208.1 IAW ER 18-05986 REV IR AND SWA EA 1-753-33918 REV IR.SDR SWAA2022022815371Strap · corroded***CORROSION*** ON TENSION STRAP AT AFT CABIN BS1016+2 LBL3 WL208.1.MARKED / REPAIRED THE TENSION STRAP AT AFT CABIN B.S 1016+2 LBL 3; WL 208.1 IAW ER 18-05986 REV IR AND SWA EA 1-753-33918 REV IRSDR SWAA2022022815372Web · corroded***CORROSION*** ON 1016 WEB STA1016 LBL13 WL208.1. MARKED / REPAIRED THE WEB AT BS 1016 LBL 13; WL 208.1 IAW ER 18-05986 REV IR AND SWA 1-753-33918 REV IR.SDR SWAA2022022815373Web · corroded***CORROSION*** ON 1016 WEB STA1016 LBL28 WL208.1. MARKED / REPAIRED THE WEB AT STA 1016 LBL 28; WL 208.1 IAW ER 18-05986 REV IR AND SWA EA 1-753-33918 REV IR.SDR SWAA2022022515369Scuff Plate · crackedFWD CARGO BAY AFT SCUFF PLATE IS CRACKED / REPAIRED FWD CARGO BAY AFT SCUFF PLATE IAW SWA EA 1-A53-2076 REV 11SDR SWAA2019011528428Cargo Track · corrodedAFT CARGO BAY FLOOR TRACK CORRODED AT BS 787+16, RBL 14. R&R TRACK PER SRM AND DWG.SDR SWAA2018121027562Battery · failedL1 DOOR EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018121027495Battery · failedR2 DOOR EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018121027494Charger · failedL1 DOOR EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY CHARGER PER AMM.SDR SWAA2022022815362Support · corroded***CORROSION*** ON AFT ENTRY DOORWAY SURROUND SUPPORT STRUCTURE AT UPPER FWD CORNER; INBD SURFACE BS957; STR7; LBL46 / REMOVED AND REPLACED AFT ENTRY DOORWAY SURROUND STRUCTURE UPPER ASSY -167 PER DWG 411A2229-167 13457C JAN3 19 INSP 24 3JAN19 SURROUND STRUCTU
Back to Boeing 737-7Q8