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 SWAA2012080706534Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706533Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706532Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706531Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706530Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706529Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706528Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 747+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706527Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727E+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706526Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706525Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706524Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727D+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706523Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727C+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706522Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706521Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080306445Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306444Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306443Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306442Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306441Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306440Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306439Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306438Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306437Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306436Skin · crackedRIGHT FUSESLAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012080306412Floorbeam · crackedLONGITUDINAL FLOORBEAM O/B WEB CRACKED AT BS 713, BBL 0.07. REPAIRED WEB IAW SRM AND SI.SDR SWAA2012080306410Floorbeam · crackedLONGITUDINAL FLOORBEAM O/B WEB CRACKED AT BS 707, RBL 24.5. REPAIRED WEB IAW EA.SDR SWAA2012073006354Hydraulic Line · failedLOSS OF ALL A-HYDRAULIC QUANTITY UPON LOWERING LANDING GEAR. FOUND NLG TRUNNION BEAM CRACKED. R&R NLG ACTUATOR LINE PER MM.SDR SWAA2012080106375Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, RBL 24.5. REPAIRED WEB PER EA.SDR SWAA2012080106374Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, RBL 24.5. REPAIRED WEB PER EA.SDR SWAA2012073006337Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED & REPLACED CLIP IAW BAC DWG & SRM.SDR SWAA2012073006270Lens · looseLEFT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. REPAIRED LENS PER EA.SDR SWAA2012073006269Sign · unsecureLEFT OVERWING EMERGENCY EXIT SIGN FELL OFF. REPAIRED SIGN PER EA.SDR SWAA2012073006268Skin · crackedFUSELAGE SKIN CRACKED AT BS 727C+14, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2012080806596Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW MT.SDR SWAA2012080706566Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012080706542Skin · crackedSKIN CRACKED BETWEEN BS 727B+14 TO BS 727B+15.5, STR 2R. REPAIRED SKIN PER EA.SDR SWAA2012080706489Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 485 TO BS 486, STR 1R. REPAIRED SKIN IAW SRM.SDR SWAA2012080306411Skin · crackedFUSELAGE SKIN CRACKED AT L2 DOOR FWD LOWER CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA2012073006338Lens · looseFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA2012073006307Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW MT.SDR SWAA2012073006282Slide · low pressureL2 DOOR EMERGENCY EXIT SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA2012072706247Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2012072706245Skin · crackedR1 DOOR FUSELAGE SKIN CRACKED AT UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA2012082406955Flap · delaminatedLEFT WING AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM AND AMM.SDR SWAA2012081306651Skin · delaminatedRIGHT WING NR 6 SLAT SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2012073006306Skin · puncturedRIGHT WING OUTBOARD FORE FLAP LOWER SURFACE PUNCTURED FROM OUTBOARD EDGE. REPAIRED FORE FLAP IAW SRM & AMM.SDR SWAA2012073006293Skin · crackedLEFT HORIZONTAL STABILIZER CRACKED ON LOWER SKIN. REPAIRED SKIN PER EA.SDR SWAA2012073006292Flap · delaminatedRIGHT WING O/B AFT FLAP DELAMINATED AT I/B SIDE. REMOVED AND REPLACED AFT FLAP IAW M/M.SDR SWAA2012072706246Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA2012072706244Tie Clip · crackedTIE CLIP CRACKED AT BS 420, STR 27L. REMOVED AND REPLACED CLIP IAW DWG & SRM.
Back to Boeing 737-3H4