Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2012072406144Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STR 8R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012072306105Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071905984Pressure Panel · crackedRIGHT WHEEL WELL BEADED WEB CRACKED AT BS 663. REPAIRED WEB IAW SRM & EA.SDR SWAA2012071605855Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED SLIDE IAW MT.SDR SWAA2012071605853Skin · crackedSKIN CRACKED AT BS 747+11, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2012071605836Flap · delaminatedLEFT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP IAW AMM.SDR SWAA2012082707068Floorbeam · corrodedFLOORBEAM CORRODED AT BS 967, RBL 27. REPAIRED CHORD IAW EO AND EA.SDR SWAA2012082206888Frame · crackedSTUB FRAME CRACKED AT BS 296.5, STR 7R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012081306659Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012080706568Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012080306452Angle · corrodedZ-ANGLE CORRODED BETWEEN BS 291.5 TO BS 360, STR 17R. REMOVED AND REPLACED Z-ANGLE IAW SRM AND DWG.SDR SWAA2012080106400Web · crackedWEB CRACKED AT BS 294.5+3, RBL 55. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012073006308Floorbeam · crackedFLOORBEAM CRACKED BS 328, BETWEEN LBL 35.0 AND LBL 49.0. REPAIRED BEAM IAW SRM.SDR SWAA2012072706249Fitting · crackedCLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012072606170Structure · corrodedLOWER CHORD CORRODED AT BS 227. REPAIRED CHORD PER ER AND EA.SDR SWAA2012072306104Fitting · crackedFITTING CRACKED AT BS 332.1, STR 8R. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR SWAA2012072306103Tie Clip · crackedTIE CLIP CRACKED AT BS 727E, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM & DWG.SDR SWAA2012072306102Angle · crackedFLOORBEAM ANGLE CRACKED AT BS 328, RBL 58. REMOVED AND REPLACED ANGLE IAW DWG AND SRM.SDR SWAA2012072306101Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, RBL 31. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012071605858Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW AMM.SDR SWAA2012071205716Engine · failedINFLIGHT SHUTDOWN/DECLARED EMERGENCY. NR 2 ENGINE ROLLED BACK TO 18 PERCENT N1 AT 34K FLT. NO RESTART ATTEMPT MADE DUE TO SUSPECTED SMOKE REPORTED BY PAX. REMOVED AND REPLACED NR 2 ENGINE PER MM.SDR SWAA2012082406931Skin · crackedSKIN CRACKED AT BS 947.5 +11, STR 17R. REPAIRED SKIN IAW EO AND EA.SDR SWAA2012082206887Skin · crackedLEFT FLIGHT COMPARTMENT WINDOW C-D POST SKIN CRACKED AT BS 219. 8, STR 9L. REPAIRED SKIN IAW EO AND EA.SDR SWAA2012080706573Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012073006349Frame · crackedFRAME CRACKED AT BS 727E, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR SWAA2012073006339Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012071305798Skin · crackedFUSELAGE SKIN CRACKED AT BS 372, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA2012071305784Sign · looseR1 DOOR EMERGENCY EXIT SIGN LOOSE. REMOVED & REPLACED SIGN ASSY PER MM.SDR SWAA2012071305781Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA2012071205763Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE FELL IN ADVERTANTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE PER MT.SDR SWAA2012071205745Skin · crackedSKIN CRACKED AT BS 372, STR 19R. REPAIRED SKIN IAW SRM.SDR SWAA2012082707064Floorbeam · crackedFLOORBEAM CRACKED AT BS 669, LBL 24.5. REPAIRED CHORD IAW EO AND EA.SDR SWAA2012082406930Web · crackedWEB CRACKED AT BS 709, LBL 24.5. REPAIRED WEB IAW EO AND EA.SDR SWAA2012082206891Web · crackedWEB CRACKED AT BS 709, BBL 0.07. REPAIRED WEB IAW EA AND EO.SDR SWAA2012082006839Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2012080306456Structure · crackedRIGHT HORIZONTAL STABILIZER L/E CRACKED AT STA 111.10. REPAIRED STABILIZER IAW SRM.SDR SWAA2012080306449Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080106406Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080106399Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012080106398Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA AND REO.SDR SWAA2012080106397Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA AND REO.SDR SWAA2012080106396Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080106395Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080106394Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2012080106393Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012073006336Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW TC.SDR SWAA2012073006335Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA AND REO.SDR SWAA2012073006334Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012072606201Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606200Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.
Back to Boeing 737-3H4