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 SWAA2017032112600Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727D+10 - 847, LBL 25. R & R SUPPORT IAW SRM.SDR SWAA2017032112598Rib · crackedLEFT HORIZONTAL STABILIZER RIB CRACKED AT HSS 92.50. REPAIRED THE RIB IAW SRM.SDR SWAA2017030812408Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 887 TO 947, RBL 25. R & R THE SIDEWALL SUPPORT IAW SRM.SDR SWAA2017030812407Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO 767, RBL 25. R & R THE SIDEWALL SUPPORT IAW SRM.SDR SWAA2017030812406Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 767 TO 790, RBL 25. R & R THE SIDEWALL SUPPORT IAW SRM.SDR SWAA2017030612343Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 847 TO BS 867, RBL 25. R&R SUPPORT IAW SRM & DWG.SDR SWAA2017030212257Light · inoperativeRT EMERGENCY EXIT LIGHT INOP AT BS 1000, AFT OF TRAILING EDGE FLAP. R&R LIGHT IAW AMM.SDR SWAA2017022712131Frame · crackedLOWER FRAME CRACKED AT BS 727, WL 200. REPAIRED THE FRAME IAW EA.SDR SWAA2017040512963Skin · crackedFUSELAGE SKIN AT BS 540, BETWEEN STRINGERS 22 - 23L. REPAIRED THE SKIN IAW ER AND EA.SDR SWAA2017032112621Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 400+9 TO 420+5.5, LBL 25. R & R THE SUPPORT IAW SRM.SDR SWAA2017032112620Skin · crackedLEFT WING NR 1 SLAT SKIN CRACKED ON LOWER SURFACE NOSE SKIN AT ACTUATOR RIB ATTACH POINT. REPAIRED THE SLAT SKIN IAW SRM.SDR SWAA2017030112222Bulkhead Web · crackedMAIN WHEEL WELL SPAR VERTICAL PRESSURE WEB CRACKED AT BS 663, LBL 42. REPAIRED THE WEB IAW SRM.SDR SWAA2017032812740Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2017032112619Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STRINGERS 9R AND 8L. REPAIRED FRAME IAW EA.SDR SWAA2017032112618Frame · crackedFRAME CRACKED AT BS 947, BETWEEN STRINGER 9R TO 9L. REPAIRED THE FRAME IAW EA.SDR SWAA2017032112617Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2017032112616Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2017022712129Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STRINGERS 8 - 9L. REPAIRED THE FRAME IAW EA.SDR SWAA2017022712128Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2017022712127Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2017022712126Frame · crackedFRAME CRACKED AT BS 727A, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2017020611725Girt Bar · out of adjustR1 DOOR EMERGENCY SLIDE GIRT BAR OUT OF ADJUST. ADJUSTED GIRT BAR PER SIP.SDR SWAA2017011111101Light · looseAFT LEFT EMERGENCY LIGHT STRIP LOOSE. SECURED THE LIGHT IAW SIP.SDR SCNA20170103001Iru · malfunctionedIRS FAULT DURING APPROACH PHASE OF FLIGHT, BELOW 19,000 FT. R&R LEFT IRU. OPS CHECK NORMAL - NO FAULTS SHOWING.SDR SCNA20161231381Switch · out of adjustDURING DEPARTURE, GEAR LEVER UP GEAR WOULD NOT COME UP, 3 RED & 3 GREEN. REPEATERS 3 GREEN. PERFORMED PSEU BITE. NO FAULTS FOUND. FOUND MANUAL EXTENSION SYSTEM ACCESS DOOR SWITCH OUT OF ADJUSTMENT. REMOVED AND REPLACED DOOR SWITCH AND SWITCH ACTUATOR. PESDR SWAA2016120510197Latch · dirtyL1 DOOR EMERGENCY EVAC SLIDE LATCHES DIRTY. CLEANED LATCHES PER SIP.SDR SWAA2016111609734Slide · looseR2 DOOR EMERGENCY EXIT SLIDE LOOSE. SECURED SLIDE ASSEMBLY PER AMM.SDR SWAA2016120110100Wire · brokenEMERGENCY EXIT LIGHT WIRE BROKEN AT BS 747, RBL 25. REPAIRED WIRE PER AMM.SDR SWAA2016110409389Light · inoperativeEMERGENCY LIGHT INOP AT BS 896, LBL 28. REPAIRED LIGHT PER ER & EA.SDR SCNA20161101296Rivet · shearedRIGHT WING UPPER SURFACE FIXED LEADING EDGE JUST INBD OF PYLON HAS SEVERAL RIVETS WITH SHEARED HEADS. REPLACED THE FASTENERS.SDR SCNA20161101295Seal · wornLEFT HORIZONTAL STABILIZER, GAP COVER PANEL, 333AB, AFT METAL SLIDING SEAL WORN THROUGH. REMOVED AND REPLACED METAL SLIDER SEAL ON PANEL 333AB.SDR SCNA20161101294Seal · wornRIGHT HORIZONTAL STABILIZER, GAP COVER PANEL, 343AB, AFT METAL SLIDING SEAL WORN THROUGH. REMOVED AND REPLACED METAL SLIDER SEAL ON PANEL 343AB.SDR SCNA20161101293Attach Angle · corrodedVERTICAL STABLIZER FIN T/E, RIB ATTACH ANGLE RT SIDE CORRODED WL 147.09. REPAIRED THE VERITICAL STABLIZER FIN TE RIB ATTACH ANGLE.SDR SCNA20161101292Balance Arm · corrodedVERTICAL STABILIZER, RUDDER BALANCE WEIGHT ARM, LT AND RT LOWER AFT BLADE SEALS CORRODED. REPLACED THE LT & RT VERTICAL STABILIZER RUDDER BALANCE WEIGHT ARM LOWER AFT SEAL.SDR SCNA20161101291Bracket · crackedL1 DOOR UPPER SUPPORT BRACKET ASSY HAS A CRACK. DRILLED & TRIMMED NEW BRACKET. PRIMED, PAINTED, AND INSTALLED NEW BRACKET.SDR SCNA20161101290Insert · damagedFLOORBOARD 242AF HAS A DAMAGED INSERT. REPLACED THE FLOORBOARD INSERTS.SDR SCNA20161101289Deflector · damagedLEFT WING TE DEFLECTOR PANEL IS LOOSE AT SERRATED PLATES. REPAIRED THE DEFLECTOR PANEL.SDR SCNA20161101288Bolt · looseRIGHT WING OTBD FLAP INBD FIXED T/E SUPPORT RIB ATTACH BOLTS LOOSE AT SERRATED PLATES. REPAIRED THE WING OB FLAP IB FIXED T/E DEFLECTION CONTROL RIB.SDR SCNA20161101287Balance Weight · erodedRUDDER BALANCE ARM WEIGHT ON LEADING EDGE ERODED. REMOVED AND REPLACED RUDDER BALANCE ARM WEIGHT.SDR SCNA20161101286Handle · malfunctionedAFT CARGO DOOR HANDLE HARD TO PULL OUT AND PAN IS GOUGED. REMOVED AND REPLACED AFT CARGO DOOR HANDLE ASSY.SDR SCNA20161101285Fuse · burned outRIGHT OVERWING EXIT, FWD LOWER BATTERY POWER SUPPLY FOUND TO BE MISSING OUTPUT. REPLACED BURNED FUSES ON THE POWER SUPPLY. TEST PASSED.SDR SCNA20161101284Skin · puncturedWING TO BODY PANEL 193AR HAS THREE PUNCTURES TO EXTERIOR SKIN. REPAIRED THE PUNCTURES TO EXTERIOR SKIN ON PANEL 193AR.SDR SCNA20161101283Fairing · chafedWING TO BODY PANEL 193AR I/B EDGE BAND IS CHAFED AND GOUGED. REPAIRED PANEL 193AR I/B EDGEBAND.SDR SCNA20161101282Fairing · puncturedRIGHT MAIN WHEEL WELL WING TO BODY PANEL 193AR HAS COMPOSITE DAMAGE IN INTERIOR SIDE. REPAIRED THE PUNCTURES TO INTERIOR SIDE OF PANEL 193AR.SDR SCNA20161101281Support Bracket · crackedBS 360 FRAME SUPPORT BRACKET CRACKED BETWEEN STRINGERS 8 AND 9R. REMOVED AND REPLACED SUPPORT BRACKET.SDR SCNA20161101280Diffuser · crackedPSU RAIL DIFFUSER ASSY. CRACKED BS 727-727A. REMOVED AND INSTALLED A NEW PSU RAIL DIFFUSER ASSY.SDR SCNA20161101279Diffuser · crackedPSU RAIL DIFFUSER ASSY CRACKED BS 727B-727C. REMOVED AND INSTALLED A NEW PSU RAIL DIFFUSER ASSY.SDR SCNA20161101278Diffuser · crackedPSU RAIL DIFFUSER ASSY CRACKED BS 727D-727E. REMOVED AND INSTALLED A NEW PSU RAIL DIFFUSER ASSY.SDR SCNA20161101277Diffuser · crackedPSU RAIL DIFFUSER ASSY CRACKED BS 787-807. REMOVED AND INSTALLED PSU RAIL DIFFUSER ASSY.SDR SCNA20161101276Frame · crackedBS 907 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIR THE FRAME.
Back to Boeing 737-7Q8