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 SWAA2016060652326Retaining Clip · brokenR2 DOOR ESCAPE SLIDE AFT GIRT BAR RETAINING CLIP BROKEN. R & R CLIP IAW AMM.SDR SWAA2016060652346Support Angle · corrodedRIGHT FLOOR TO SIDEWALL SUPPORT ANGLE CORRODED BETWEEN BS 767 - 727. R & R SUPPORT IAW SRM.SDR SWAA2016060652325Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652324Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652323Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652322Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652321Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016061552901Skin · crackedRIGHT SIDE LOWER BULKHEAD CHORD SKIN CRACKED AT BS 540, 2ND LOWER AFT HOLE. REPAIRED SKIN IAW ER AND EA.SDR SWAA2016061452852Skin · crackedLOWER BULKHEAD CHORD CRACKED AT BS 540, STR 22L, 2ND LOWER AFT HOLE. REPAIRED SKIN IAW ER AND EA.SDR SWAA2016061452851Attach Angle · crackedRIGHT WING UPPER T/E PANEL SUPPORT BEAM FORWARD SPAR ATTACHMENT ANGLE CRACKED AT RSS. 70.5. R & R ANGLE IAW SRM.SDR SWAA2016061452850Support Angle · crackedRIGHT WING UPPER T/E PANEL SUPPORT ANGLE CRACKED ABOVE NR 2 PYLON AFT TIP. R & R ANGLE IAW SOPM.SDR SWAA2016060652349Web · crackedRIGHT WING TRANSVERSE WEB CRACKED JUST INBD OF MAIN FLAP PROGRAM ROLLER SUPPORT ARM. R & R WEB IAW SRM.SDR SWAA2016060652345Plate · crackedRIGHT WING LOWER TE WAFFLE PLATE CRACKED JUST INBD OF NR 2 PYLON AFT TIP. R & R PLATE ASSEMBLY IAW SRM.SDR SWAA2016060652448Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652436Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652435Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016061152434Frame · crackedFRAME CRACKED AT BS 380, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652320Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652319Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652318Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652317Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652316Frame · crackedFRAME CRACKED AT BS 727B, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652315Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652314Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652313Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016060652312Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016061652912Window Frame · crackedLEFT 1 FLIGHT DECK WINDOW OTBD VERTICAL FRAME CRACKED FROM UPPER HORIZONTAL FRAME. REPAIRED FRAME.SDR SWAA2016060652311Support Channel · corrodedAFT CARGO BAY SIDEWALL SUPPORT CHANNEL CORRODED AT BS 727D, BETWEEN STRINGER 24L - 25L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2016042551275Cover · brokenR1 FWD DOOR EMER EXIT LIGHT COVER BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016060652447Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 - 360, LBL 1. R & R INTERCOSTAL IAW SRM.SDR SWAA2016060652446Frame · crackedLOWER STUB FRAME CRACKED AT BS 294.5, RBL 54. R & R FRAME IAW SRM & DWG.SDR SWAA2016060652433Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 - 360, LBL 7. R & R INTERCOSTAL IAW SRM.SDR SWAA2016060652432Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 328 - 344, LBL 47. R & R INTERCOSTAL IAW SRM.SDR SWAA2016060652431Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 - 328, LBL 47. R & R INTERCOSTAL IAW SRM.SDR SWAA2016060652430Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 277 - 294, RBL 2. R & R INTERCOSTAL IAW SRM.SDR SWAA2016060652429Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 - 328, RBL 34. R & R INTERCOSTAL IAW SRM.SDR SWAA2016060652445Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652444Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652443Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652442Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652441Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016060652310Floor Support · crackedLONGITUDINAL FLOORBEAM FLANGE CRACKED AT BS 727B, RBL 45.5. REPAIRED FLANGE IAW SRM.SDR SWAA2016060652309Floor Support · crackedLONGITUDINAL FLOORBEAM FLANGE CRACKED AT BS 727B, RBL 24.75. REPAIRED FLANGE IAW SRM.SDR SWAA2016060652308Floor Support · crackedLONGITUDINAL FLOORBEAM FLANGE CRACKED AT BS 727B, LBL 24.75. REPAIRED FLANGE IAW SRM.SDR SWAA2016060652307Floor Support · crackedLONGITUDINAL FLOORBEAM FLANGE CRACKED AT BS 727B, LBL 45.5. REPAIRED FLANGE IAW SRM.SDR SWAA2016061552900Plate · corrodedAFT CARGO BAY ANTENNA BASE PLATE CORRODED AT BS 727D+11, BETWEEN STR 27L TO STR 27R.
R & R PLATE IAW DWG AND SRM.SDR SWAA2016060652440Window Frame · crackedRIGHT NR 1 WINDOW FRAME UPPER AFT CORNER, INTERIOR SURFACE CRACKED. REPAIRED CORNER IAW ACO.SDR SWAA2016060652439Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED AT BS 441, LBL 23. R & R SUPPORT IAW SRM.SDR SWAA2016060652438Attach Bracket · crackedAFT CARGO BAY FRAME ATTACH BRACKET CRACKED AT BS 727D, STRINGER 24R. R & R BRACKET IAW SRM & DWG.SDR SWAA2016060652437Threshold · corrodedFORWARD CARGO BAY THRESHOLD WEB CORRODED BETWEEN BS 440 - 492, BETWEEN RBL 23 - 30.5. REPAIRED WEB IAW SRM.
Back to Boeing 737-7Q8