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 SWAA2016062853316Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT STA 92.70, 3RD VERTICAL STIFFENER IN LOWER AREA. REPAIRED RIB IAW SRM.SDR SWAA2016072054088Window Frame · crackedR3 WINDOW FRAME CRACKED ON THE E-F POST. REPAIRED THE WINDOW FRAME IAW SRM.SDR SWAA2016062953347Strap · corrodedAFT CARGO BAY FLOOR PANEL SUPPORT STRAP CORRODED AT BS 771, BETWEEN RBL 21 TO LBL 21. R&R STRAP IAW SRM.SDR SWAA2016062853319Cargo Track · corrodedAFT CARGO BAY FLOOR SUPPORT CARGO TRACK CORRODED AT BS 771, LBL 17.25. REPAIRED CARGO TRACK IAW SRM & EA.SDR SWAA2016062853315Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 771, LBL 12.50. REPAIRED SUPPORT IAW EA.SDR SWAA2016062853314Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 771, LBL 8.10. REPAIRED SUPPORT IAW EA.SDR SWAA2016062853313Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 771, RBL 8.10. REPAIRED SUPPORT IAW EA.SDR SWAA2016062853312Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 771, LBL 3. REPAIRED SUPPORT IAW EA.SDR SWAA2016062853311Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT RAIL CORRODED AT BS 771, RBL 3. R & R SUPPORT IAW EA.SDR SWAA2016062853310Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO BS 847, LBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016062753267Cargo Track · corrodedAFT CARGO BAY FLOOR SUPPORT CARGO TRACK CORRODED BETWEEN BS 770 TO BS 847, RBL 13.84. R & R TRACK IAW SRM.SDR SWAA2016062753266Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 867 TO BS 890, RBL 21. R & R SUPPORT IAW SRM.SDR SWAA2016062753265Threshold · corrodedAFT CARGO BAY DOOR THRESHOLD WEB CORRODED BETWEEN BS 807 TO BS 847. R & R WEB IAW SRM.SDR SWAA2016062753264Plate · corrodedFORWARD CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS 396 TO BS 420, RBL 23. R & R PLATE IAW SRM.SDR SWAA2016062853309Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, BL 0. R & R INTERCOSTAL IAW SRM.SDR SWAA2016062053035Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 328 TO BS 344, LBL 46. R & R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2016062053034Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, LBL 46. R & R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2016062053033Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, RBL 31. R & R INTERCOSTAL IAW SRM.SDR SWAA2016062053032Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, RBL 31. R & R INTERCOSTAL IAW SRM.SDR SWAA2016062053031Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 294.5 TO BS 312, BL 0. R & R INTERCOSTAL IAW DWG.SDR SWAA2016062053030Plate · corrodedGIRT BAR FITTING SUPPORT PLATE CORRODED AT BS 344, LBL 61. R & R PLATE IAW SRM.SDR SWAA2016062053029Plate · corrodedGIRT BAR FITTING SUPPORT PLATE CORRODED AT BS 312, LBL 54. R & R PLATE IAW SRM.SDR SWAA2016070553530Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STRINGER 17R. R & R STUB FRAME IAW SRM & DWG.SDR SWAA2016070553529Collar · crackedR2 DOOR EMERGENCY SLIDE AFT GIRT BAR COLLAR CRACKED. R & R THE COLLAR IAW AMM.SDR SWAA2016070553528Girt Bar · dirtyR2 DOOR EMERGENCY SLIDE GIRT BAR DIRTY. CLEANED THE GIRT BAR IAW AMM.SDR SWAA2016062853308Collar · damagedL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR COLLAR DAMAGED. R & R COLLAR IAW MAINTENANCE.SDR SWAA2016062853307Frame · crackedFRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016062853306Frame · crackedFRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016062053028Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016062053027Frame · crackedFRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016062053026Girt Bar · dirtyL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIRTY. CLEANED GIRT BAR IAW AMM.SDR SWAA2016062053058Frame · crackedFRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016062053057Frame · crackedFRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME IAW EA 8L.SDR SWAA2016062053025Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652335Hook · corrodedRIGHT EMERGENCY EXIT HATCH ESCAPE STRAP HOOK CORRODED. R & R ROPE IAW AMM.SDR SWAA2016060652334Strap · stuckLEFT EMERGENCY EXIT HATCH ESCAPE STRAP HOOK GATE STUCK. R & R STRAP IAW AMM.SDR SWAA2016060952693Stringer · corrodedSTRINGER CORRODED AT BS 962, STRINGER 25L. REPAIRED STRINGER IAW ER & EA.SDR SWAA2016060652331Rib · crackedLEFT HORIZONTAL STABILIZER RIB CRACKED AT STATION 129.50 AT 2ND VERTICAL STIFFENER IN LOWER AREA. REPAIRED RIB IAW SRM.SDR SWAA2016051051693Light · inoperativeLEFT EMER LIGHTS FAILED EMER TEST BETWEEN ROW 14 - 24. R & R LIGHT IAW AMM.SDR SWAA2016051051692Light · inoperativeLEFT BIN EMER EXIT LIGHT INOPERATIVE AT ROW 11. RELAMPED LAMP IAW AMM.SDR SWAA2016050951626Guard · missingAFT ATTENDANT PANEL EMER EXIT SWITCH GUARD MISSING. INSTALLED SWITCH ASSEMBLY IAW MM.SDR SWAA2016060652330Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT STATION 120.3, 1ST STIFFENER FROM LE AT LOWER END. REPAIRED RIB IAW SRM.SDR SWAA2016060652329Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT STATION 93, 3RD STIFFENER FROM LE AT LOWER END. REPAIRED RIB IAW SRM.SDR SWAA2016060652328Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT STATION 93, 2ND STIFFENER FROM LE AT LOWER END. REPAIRED RIB IAW SRM.SDR SWAA2016060652333Support Angle · crackedLEFT WING UPPER TE PANEL SUPPORT ANGLE CRACKED ABOVE NR 1 PYLON AFT TIP. R & R ANGLE IAW SOPM.SDR SWAA2016060252219Fitting · corrodedRIGHT OVERWING EMERGENCY EXIT ESCAPE STRAP ANCHOR FITTING ASSEMBLY CORRODED. R & R FITTING ASSEMBLY IAW MM.SDR SWAA2016060252218Fitting · corrodedLEFT OVERWING EMERGENCY EXIT ESCAPE STRAP ANCHOR FITTING ASSEMBLY CORRODED. R & R FITTING ASSEMBLY IAW MM.SDR SWAA2016060652350Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652347Retaining Ring · brokenL2 DOOR SLIDE GIRT BAR AFT QUICK DISCONNECT RETAINER RING BROKEN. R & R RING IAW AMM.SDR SWAA2016060652327Fastener · looseR1 DOOR ESCAPE SLIDE FWD RETAINER CLIP FASTENER LOOSE. R & R FASTENER IAW SRM.
Back to Boeing 737-7Q8