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 SWAA2015012636068Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 807 TO 827. R & R WEB IAW SRM.SDR SWAA2015012636067Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 787 TO 787+6. R & R WEB IAW SRM & DWG.SDR SWAA2015012636066Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 767 TO 787. R & R WEB IAW SRM.SDR SWAA2015012636065Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 460 TO 480. R & R WEB IAW SRM.SDR SWAA2015012636064Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500C TO 500D. R & R WEB IAW SRM.SDR SWAA2015012636063Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500A TO 500B. R & R WEB IAW SRM.SDR SWAA2015012636062Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 440 TO 460. R & R WEB IAW SRM & DWG.SDR SWAA2015012636061Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO 420. R & R WEB IAW SRM.SDR SWAA2015012636060Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 360 TO 380. R & R WEB IAW SRM.SDR SWAA2015012235977Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 380 - 400. R & R WEB IAW SRM & DWG.SDR SWAA2015012135929Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO 420. REPAIRED WEB IAW SRM.SDR SWAA2015012035918Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO 867. R & R WEB IAW SRM & DWG.SDR SWAA2015012035917Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO 400. R & R WEB IAW SRM & DWG.SDR SWAA2015012035916Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500B TO 500C. R & R WEB IAW SRM.SDR SWAA2015011335712Shear Tie · crackedFRAME SHEAR TIE CRACKED AT BS 967, STRINGER 27L+3. REPAIRED SHEAR TIE IAW EO & EA.SDR SWAA2015011235686Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2015010935615Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 747 TO 767. R & R WEB IAW DWG & SRM.SDR SWAA2015010935588Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO BS 747. R & R WEB IAW DWG & SRM.SDR SWAA2015010635503Skin · crackedLEFT BS 867+10 LOWER FWD WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2015010635502Skin · crackedLEFT BS 847+10 LOWER FWD WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2015010635501Skin · crackedLEFT BS 807+10 LOWER FWD WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2015010635500Skin · crackedLEFT BS 847+10 UPPER AFT WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2015010635499Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 727B TO BS 727C. R & R WEB IAW DWG & SRM.SDR SWAA2015010535478Skin · crackedLEFT FUSELAGE SKIN CRACKED AT STATION 807+10, UPPER AFT CORNER OF WINDOW CUT OUT. REPAIRED SKIN IAW SB.SDR SWAA2015010535477Skin · crackedLEFT FUSELAGE SKIN CRACKED AT STATION 787+10, UPPER AFT CORNER OF WINDOW CUT OUT. REPAIRED SKIN IAW SB.SDR SWAA2015010535476Skin · crackedLEFT FUSELAGE SKIN CRACKED AT STATION 767+10, UPPER AFT CORNER OF WINDOW CUT OUT. REPAIRED SKIN IAW SB.SDR SWAA2015010535461Intercostal · crackedFUSELAGE INTERCOSTAL CRACKED AT STATION 663 TO 685, BETWEEN STRINGER 8L & 9L. R & R INTERCOSTAL IAW SRM.SDR SWAA2015010235413Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 727A, STRINGER 9L. R & R CLIP IAW SRM.SDR SWAA2015010235410Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 727A, STRINGER 9R. R & R CLIP IAW SRM.SDR SWAA2014122335232Light · inoperativeRIGHT OVERWING EMER EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2014122335231Skin · crackedL1 DOOR INNER SKIN CRACKED AT LOWER HINGE AREA. REPAIRED SKIN IAW EA.SDR SWAA2014122235203Channel · crackedCRACK ON CHANNEL AT FUSELAGE STATION 328 TO 344, LBL 45.6. R & R CHANNEL IAW SRM.SDR SWAA2015011535787Panel · corrodedFUSELAGE KEEL BEAM LOWER WEB PANEL CORRODED, BETWEEN BS 570 TO 587. REPAIRED PANEL IAW EO & EA.SDR SWAA2015010735541Skin · delaminatedLEFT WING LOWER SURFACE OF INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015010735540Tab · delaminatedLEFT WING LOWER SURFACE AILERON TAB DELAMINATED. REPAIRED TAB IAW SRM.SDR SWAA2015010235423Skin · delaminatedRIGHT INBD AFT FLAP DELAMINATED AT LOWER SURFACE. REPAIRED FLAP IAW SRM.SDR SWAA2014121935147Angle · crackedRIGHT WING STIFFENER ANGLE CRACKED FWD OF INBD AILEON HINGE. R & R ANGLE IAW SRM.SDR SWAA2014121935140Stiffener · crackedRIGHT WING AILERON INBD STIFFENER ANGLE CRACKED. R & R STIFFENER IAW SRM.SDR SWAA2015012636059Floor Support · corrodedFLOORBOARD SUPPORT CORRODED BETWEEN BS 770 TO 775, LBL 8. REPAIRED SUPPORT IAW EA & SRM.SDR SWAA2015012636058Floor Support · corrodedFLOORBOARD SUPPORT CORRODED BETWEEN BS 770 TO 775, LBL 3. REPAIRED SUPPORT IAW EA & SRM.SDR SWAA2015012636057Floor Support · corrodedFLOORBOARD SUPPORT STRUCTURE CORRODED BETWEEN BS 770 TO 775, RBL 8. REPAIRED SUPPORT IAW EA.SDR SWAA2015012636056Floor Support · corrodedFLOORBOARD SUPPORT CORRODED BETWEEN BS 770 TO 775, RBL 3. REPAIRED SUPPORT IAW EA.SDR SWAA2015012636055Shear Tie · corrodedFRAME LOWER ANGLE SHEAR TIE CORRODED AT BS 520, BETWEEN STRINGER 28R & 28L. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2015010835567Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 947.5, STRINGER 25R. R & R BRACKET IAW SRM & DWG.SDR SWAA2015010235437Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 344, LBL 2. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014122235198Slide · unsecureL1 DOOR SLIDE FALLING OUT OF CONTAINER. SECURED SLIDE IAW MM.SDR SWAA2014121935149Sign · unsecureRIGHT OVERWING EXIT ROW SIGN FELL OFF. SECURED SIGN IAW MM.SDR SWAA2014121935148Slide · looseL1 DOOR SLIDE FALLING OUT OF CONTAINER. REPOSITIONED SLIDE IAW MM.SDR SWAA2015011535774Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 667 TO 671, RBL 24.8. REPAIRED BEAM IAW ER & EA.SDR SWAA2015011535786Skin · corrodedSKIN CORRODED AT BS 967, STRINGER 27L. REPAIRED SKIN IAW EO & EA.
Back to Boeing 737-3H4