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 SWAA2022012618433Fairing · crackedFAIRING 642BB INNER SKIN IS CRACKED 4' FWD OF THE 3RD TO LAST DRAIN HOLE / FAIRING 642BB WITH INNER SKIN CRACK 4' FWD OF THE 3RD TO LAST DRAIN HOLE WAS REPAIRED PER SWA EA #1-757-14095 REV IR DATED 25-JUL-2017 AND ATS ER #17-03232 REV IR DATED 25-JUL-2017.SDR SWAA2022012618437Beam · crackedFORWAD GALLEY DOOR HAS A CRACK ON UPPER CORNER OF THE #4 BEAM APPROX. WL 240. / REMOVED FWD GALLEY DOOR AND REPLACED THE #4 INTERNAL DOOR BEAM AT APPX WL 240.REINSTALLED FWD GALLEY DOOR ALL WORK ACCOMPLISHED PER WORK ORDER #0520055-84R; AMM 52-41-00-820-801;AMSDR SWAA2022012618439Retainer · cracked(RIGHT WING) COVE SEAL RETAINER IS CRACKED ABOVE #2 PYLON AFT TIP / REMOVED AND REPLACED RIGHT WING COVE SEAL RETAINER ABOVE #2 PYLON AFT TIP PER SRM 51-40-02-0G-0.SDR SWAA2022012618425Floor Panel · brokenFWD PASSENGER CABIN FLOOR PANEL 221BF AFT O/B CORNER IS BROKEN / REPAIRED BROKEN AFT O/B CORNER ON FWD PASSENGER CABIN FLOOR PANEL 221BF IAW SRM 53-00-50-2R-6. 57066U 07/07/17SDR SWAA2022012618424Floor Panel · brokenFWD PASSENGER CABIN FLOOR PANEL 221GF FWD O/B CORNER IS BROKEN / REPAIRED FWD O/B BROKEN CORNER ON FWD PASSENGER CABIN FLOOR PANEL 221GF IAW SRM 53-00-50-2R-6. 57066U 07/07/17SDR SWAA2017072515192Angle · crackedRIGHT WING TRANSVERSE WEB OTBD ATTACH ANGLE CRACKED AT MAIN FLAP DEFLECTION RIB ATTACH POINT. R & R THE ANGLE IAW SRM & DWG.SDR SWAA2017071815144Attach Angle · crackedLT WING RS STA 80 UPPER TRAILING EDGE PANEL SUPPORT BEAM FORWARD SPAR ATTACH ANGLE CRACKED. R&R ANGLE IAW SRM.SDR SWAA2017071014893Attach Angle · crackedRT WING RSS 80 UPPER TRAILING EDGE PANEL SUPPORT BEAM FORWARD ATTACH ANGLE CRACKED AT REAR SPAR ATTACH POINT. R & R THE ATTACH ANGLE IAW SRM.SDR SWAA2017070514795Fan · faultyELECTRICAL SMELL AND HAZE IN THE AFT GALLEY. TURNED RECIRCULATION SWITCH AND CABIN UTILIZATION OFF. SMELL AND HAZE DECREASED. R&R RECIRCULATION FAN PER AMM.SDR SWAA2017082215851Frame · crackedFRAME CRACKED AT BS 294, RBL 63. REPAIRED THE FRAME IAW ER AND EA.SDR SWAA2017071715084Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, RBL 30. R&R INTERCOSTAL PER SRM AND DWG.SDR SWAA2017071715047Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, LBL 11. R&R INTERCOSTAL PER SRM AND DWG.SDR SWAA2017071715046Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 328 TO BS 344, LBL 46. R&R INTERCOSTAL PER SRM AND DWG.SDR SWAA2017071715045Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, LBL 46. R&R INTERCOSTAL PER SRM AND DWG.SDR SWAA2017071715044Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 270 TO BS 294, BL 0. R&R INTERCOSTAL PER SRM AND DWG.SDR SWAA2017070514790Light · inoperativeRT OVERWING EXTERNAL EMERGENCY LIGHT INOP. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2022012818383Skin · damagedAIRCRAFT SKIN BENEATH #1 GPS ANTENNA STA 500A LBL5 IS DAMAGED / REPAIRED FUSELAGE SKIN BENEATH #1 GPS ANTENNA BS 500A LBL 5. PER ATS ER 17-03304 REV IR AND SWA EA 1-753-31545 REV IRSDR SWAA2017081615716Window · defectiveFIRST OFFICER NR 2 WINDOW EXTERNAL EMERGENCY RELEASE INOP. R&R WINDOW IAW AMM.SDR SWAA2022012818378Frame · damagedB.S 727C FRAME REQUIRES REPLACEMENT FROM STR 14L/H TO STR 14R/H FOR ROW 44 MOD / INSTALLED NEW FRAME AT B.S. 727C FROM STR 14 L/H - 14 R/H IAW SRM 51-40-02; BOEING DWG 146A1103 SHT 1SDR SWAA2022012818379Frame · damagedB.S 727D FRAME REQUIRES REPLACEMENT FROM STR 14L/H TO STR 14R/H FOR ROW 44 MOD / REPLACED THE B.S. 729D FRAME AS REQUIRED IAW EA 1-753-31491 REV IR AND ATS ER 17-03228 REV IR DATED 07-AUG-2017SDR SWAA2022012818380Frame · damagedB.S 747 FRAME REQUIRES REPLACEMENT FROM STR 14L/H TO STR 14R/H FOR ROW 44 MOD / ACCOMPLISHED EA 1-753-31490 IR AND ATS ER 17-03210 IRSDR SWAA2017082215850Frame · crackedFRAME CRACKED AT BS 520, STRINGER 8R. REPAIRED THE FRAME IAW ER AND EA.SDR SWAA2017081615715Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017081615714Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017072515212Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2017072515211Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2017072515191Frame · crackedFRAME CRACKED AT BS 520, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2017072515190Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2017072515189Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2017071715083Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017071715082Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017071715081Frame · crackedFRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017071715080Frame · crackedFRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017071715079Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017071715078Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017071715077Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017071715076Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017071715074Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017071715073Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017071715072Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017062614609Battery · inoperativeFORWARD CABIN FLASHLIGHT INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2017062214578Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY IAW AMM.SDR SWAA2017062214577Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY IAW AMM.SDR SWAA2017062214571Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY IAW AMM.SDR SWAA2017060714207Sign · looseR2 DOOR AFT GALLEY EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR SWAA2017060114108Battery · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY IAW MM.SDR SWAA2017060114101Battery · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY IAW MM.SDR SWAA2017053114086Slide · looseL1 DOOR SLIDE OUT OF ADJUST. SECURED THE SLIDE ASSY IAW MM.SDR SWAA2017050913658Hook · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF ADJUST. ADJUSTED GIRT BAR RETAINER HOOKS IAW AMM.SDR SWAA2017050413574Battery · dischargedRT OVERWING EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.
Back to Boeing 737-7Q8