Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA052965Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052948Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 817, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA052932Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA052931Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 348, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA052907Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA052930Skin · wornDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN WORN AT BS 865, UNDER DORSAL FIN BLADE SEAL. REPAIRED SKIN PER SRM.SDR SWAA052889Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RT EXTERIOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052888Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, LT & RT SIDE, WL 208. REPAIRED FLOOR WEB PER SRM.SDR SWAA052887Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAMES CRACKED AT BS 188, LT & RT SIDE, WL 208. REPAIRED STUB FRAMES PER SRM.SDR SWAA052878Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 482B + 3, ABOVE STR 7L. REPAIRED SKIN PER SRM.SDR SWAA052849Lens · missingEMERGENCY EXIT BULLNOSE LIGHT LENS MISSING AT ROW 3 ABC. INSTALLED LENS PER MM.SDR SWAA052847Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB CRACKED A LBL 17.1, WL 236. REPAIRED WEB PER SRM.SDR SWAA052819Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052820Lens · looseRIGHT OVERWING EXIT SIGN LENS LOOSE. SECURED LENS PER MM.SDR SWAA052804Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 900, BETWEEN STR 24R TO STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA052818Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE BULKHEAD WEB CRACKED AT BS 179, LBL 17.1, WL 236. REPAIRED WEB PER SRM.SDR SWAA052754Skin · delaminatedDURING SCHEDULED RON CHECK, FOUND RT WING INBOARD T/E AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SWA EA & SRM.SDR SWAA052753Skin · delaminatedDURING SCHEDULED RON CHECK, FOUND RT WING INBOARD T/E AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SWA EA & SRM.SDR SWAA052752Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER & SRM.SDR SWAA052710Sign · separatedDURING SCHEDULED A1 CHECK, L1 DOOR EMERGENCY EXIT SIGN FELL OFF. REINSTALLED SIGN PER MM.SDR SWAA052709Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA052688Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA052687Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA052686Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND COCKPIT FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, LBL 29 TO RBL 29, WL 208. REPAIRED WEB PER SRM.SDR SWAA052685Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA052684Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 1 & NR 5 STOP FITTINGS. REPAIRED FRAME PER SRM.SDR SWAA052683Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAMES CRACKED AT BS 188, LT & RT SIDE, WL 208. REPAIRED STUB FRAMES PER SRM.SDR SWAA052639Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD CABIN EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA052624Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA052568Motor · faultyLOUD NOISE HEARD WHEN FLAPS ARE EXTENDED & RETRACTED. REMOVED AND REPLACED FLAP HYDRAULIC DRIVE MOTOR PER MM.SDR SWAA052567Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LT SIDE, WL 208. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA052569Switch · intermittentDURING SCHEDULED SERVICE CHECK, FOUND COCKPIT EMERGENCY EXIT LIGHTS INTERMITTANT. REMOVED AND REPLACED COCKPIT LIGHT SWITCH PER MM.SDR SWAA052553Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 747 TO BS 767, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA052566Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA052565Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND COCKPIT FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, LBL 29, WL 208. REPAIRED WEB PER SRM.SDR SWAA052508Slide · dislodgedDURING SCHEDULED SERVICE CHECK, R1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA052507Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 784, STR 19L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052604Coffeemaker · faultyELECTRICAL ODOR IN AFT GALLEY. REMOVED AND REPLACED BOTH AFT GALLEY COFFEEMAKERS PER MM.SDR SWAA052506Floor Panel · crackedDURING SCHEDULED SPECIAL VISIT, FOUND COCKPIT FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, RBL 29, WL 208. REPAIRED WEB PER SRM.SDR SWAA052505Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 208. REPAIRED STUB FRAME PER SRM.SDR SWAA052432Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 11R. REPAIRED SKIN PER SWA EA.SDR SWAA052430Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA052431Lens · brokenDURING SCHEDULED SPECIAL VISIT, FOUND L2 DOOR EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER SRM.SDR SWAA052398Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052370Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA052332Slide · out of limitsDURING SCHEDULED A1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE PRESSURE OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA052331Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA052311Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 L/E SLAT T/E WEDGE DELAMINATED. REPAIRED SLAT PER SWA EA.SDR SWAA052278Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 945, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA052279Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 924, STR 24L. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4