Boeing 737-3Q8
Service difficulty reports · 4,188
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 = '7373Q8' 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 = '7373Q8' 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 SWAA012911Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BETWEEN STR'S 28L & 28R. REPAIRED SHEAR TIE PER SRM & BFG ER 01-0911.SDR SWAA012904Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, BETWEEN STR 8R & 9R. REPAIRED FRAME PER BFG ER 01-0885.SDR SWAA012898Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012897Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR VERTICAL EMERGENCY EXIT LIGHT INOP. RELAMPED EXIT LIGHT PER MM.SDR SWAA012896Lens · missingDURING SCHEDULED C4 CHECK, FOUND LH OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA012907Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. R&R SHEAR TIE PER BFG ER 01-0908.SDR SWAA012906Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 987, RBL 21 TO RBL 44, WL 208. REPAIRED FLOORBEAM PER BFG ER 01-0891.SDR SWAA012883Keelbeam · corrodedDURING SCHEDULED D-CHECK, FOUND RT KEEL BEAM CORRODED AT BS 540. REPAIRED KEEL BEAM PER BFG ER 01-0905.SDR SWAA012882Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1018, RBL 1 & WL 191. REPAIRED FRAME PER SRM.SDR SWAA012881Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 847, RBL 2 & WL156. R&R SHEAR TIE PER SRM.SDR SWAA012834Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED ( 2 EA ) AT BS 727E, STR 22R & 23R. REPAIRED SKIN PER SRM.SDR SWAA012856Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 7 EA ) BETWEEN STR 8L & 9L, BS 807, 827, 847, 867, 907, 887 & 480. REPAIRED FRAMES PER BFG ER.SDR SWAA012855Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 4 EA ) BETWEEN STR 8R & 9R, BS 440, 480, 827 & 887. REPAIRED FRAMES PER BFG ER.SDR SWAA012835Slat · crackedDURING SCHEDULED C1 CHECK, FOUND # 1 L/E SLAT CRACKED 3/8 INCH LONG AT AFT ROW OF FASTENERS, LOWER SKIN. REPAIRED # 1 L/E SLAT PER SWA RA 1-357-1118.SDR SWAA012833Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1018, LBL 1 & WL 191. REPAIRED FRAME PER SRM.SDR SWAA012820Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (4 EA) AT BS 597, STR 7L & STR 8R, BS 767, STR 10L, BS 706, STR 10L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA012819Landing Gear · malfunctionedDURING CLIMB WHEN MOVING GEAR HANDLE FROM UP TO OFF, GEAR STARTED TO EXTEND. RECYCLED HANDLE TO UP. ON APPROACH MOVED HANDLE FROM UP TO OFF AND GEAR REMAINED UP. INSPECTED LANDING GEAR SELECTOR VALVE. LANDING GEAR EXTENSION AND RETRACTION SYSTEM CHECKS NORSDR SWAA012812Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 987, RBL 51 & WL 199. R&R SHEAR TIE PER SRM.SDR SWAA012810Skin · crackedDURING WALK AROUND INSPECTION FOUND FUSELAGE SKIN CRACKED 1.0 INCH LONG AT BS 727D + 6, BETWEEN STR 19L & 20L. REPAIRED SKIN PER SRM & SWA RA 1-353-2678.SDR SWAA012793Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 637, STR 17R. R&R WEB SECTION PER SRM.SDR SWAA012795Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 967, LBL 2 & WL 171. REPAIRED FRAME PER SRM.SDR SWAA012788Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA012786Web · corrodedDURING SCHEDULED D CHECK, FOUND WEB CORRODED AT BS 296, RBL 50 & WL 208. REPAIRED WEB PER MM.SDR SWAA012778Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 637, STR 17L. R&R WEB PER SRM.SDR SWAA012787Splice · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER SPLICE AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA012765Slat · crackedDURING SCHEDULED C4 CHECK, FOUND # 2 L/E SLAT CRACKED .75 INCH LONG AT INBD LOWER T/E. REPAIRED # 2 SLAT PER SWA RA 1-357-1114.SDR SWAA012767Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACK (2 EA) AT BS 727E, STR 18R & BS 747, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA012777Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1006, LBL 9 & WL 208. REPAIRED FLOORBEAM PER SRM.SDR SWAA012530Cable · frayedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. R&R CABLE PER MM.SDR SWAA012419Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND RH WING OUTBD AFT T/E FLAP DELAMINATED AT LOWER SURFACE NEAR OUTBD END. R&R FLAP ASSY PER MM.SDR SWAA012241Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012236Frame · crackedDURING SCHEDULED D CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT BS 492, RBL 36 & WL 159. REPAIRED FRAME PER BFG ER.SDR SWAA012224Beam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL BEAM CRACKED AT BS 727B, RBL 45 & WL 208. REPAIRED BEAM PER BFG ER.SDR SWAA012220Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 324, STR 17R. REPAIRED SKIN PER BFG ER.SDR F3LA200100097Tire · separatedAIR TURN BACK. FLIGHT CREW REPORTED LOSS OF "A" SYSTEM HYDRAULICS. AN EMERGENCY WAS DECLARED AND AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE PERFORMED AN OVERWEIGHT INSPECTION. FOUND NO. 2 MLG TIRE LOST CAP ON TAKEOFF, DAMAGING INBD. FORE FLAP, MID FLAP SDR SWAA012225Web · crackedDURING SCHEDULED D CHECK, FOUND LOGITUDINAL BEAM WEB CRACKED AT BS 706-708, BL 0 & LBL 25, WL 203. REPAIRED WEB PER BFG ER.SDR AUS20010822Tire · separated(AUS) LT MAIN LANDING GEAR OUTBOARD TIRE (NR 1) TREAD SEPARATED. SECONDARY DAMAGE CAUSED TO TRAILING EDGE FLAPS, WING TRAILING EDGE PANELS AND LT UNDERCARRIAGE DOOR WHICH WAS PARTIALLY MISSING. AIRCRAFT WAS OPERATED BY AIR VANUATU AND WAS REGISTEREDYJAV18.SDR SWAA012207Light · brokenDURING SCHEDULED D-CHECK, FOUND EMERGENCY EXIT LIGHTS BROKEN AT AFT ENTRY DOOR AND FWD SVC DOOR. REMOVED AND REPLACED EXIT LIGHTS PER MM.SDR SWAA012199Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND AFT CABIN FLOORBEAM CRACKED AT BS 665, BBL 0. REPAIRED FLOORBEAM PER SRM.SDR SWAA012137Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA012198Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FRAME SHEAR TIE CORRODED AT BS 480, LBL 10 & WL149. R&R SHEAR TIE PER SRM.SDR SWAA012150Web · crackedDURING SCHEDULED D CHECK, FOUND PRESS WEB CRACKED AT BS 664, LBL 33 & WL 202. REPAIRED WEB PER SWA T1-353-046.SDR SWAA012159Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CABIN FLOORBEAM CRACKED AT BS 727B, RT OUTBOARD. REPAIRED FLOORBEAM PER DLF XEA & SRM.SDR SWAA012152Skin · corrodedDURING SCHEDULED D CHECK, FOUND BILGE INTERNAL SKIN CORRODED AT BS 500C+19, RBL 5. REPAIRED SKIN PER SRM.SDR SWAA012208Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED IN FWD CABIN AT BS 294.5, LBL 11. REPAIRED FLOORBEAM PER SRM.SDR SWAA012114Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 Z-FRAMES CRACKED, STR 9R, BS 807 AND BS 887. REPAIRED FRAMES PER SRM.SDR SWAA012113Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 867 FUSELAGE FRAME CRACKED BETWEEN STRS 8R-9R. REPAIRED FRAME PER SRM.SDR SWAA012105Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 66. REPAIRED FRAME PER BFG T1-153-018.SDR SWAA012104Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 312, BETWEEN LBL 12 & RBL 12. REPAIRED FLOORBEAM PER SRM.SDR SWAA012103Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13L. REPAIRED SHEAR TIE PER SRM.
Back to Boeing 737-3Q8