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 SWAA2013052416464Skin · crackedSKIN CRACKED AT BS 959, STR 17L. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2013052216330Attach Fitting · brokenLT WING NR 4 GROUND SPOILER ATTACH FITTING BROKEN. R & R SPOILER IAW MM.SDR SWAA2013052016212Lens · looseL1 DOOR EMERGENCY EXIT FLOOR SIGN LOOSE. SECURED LENS IAW MM.SDR SWAA2013051716194Regulator · faultyPACKS EXTREMELY TEMPERANTAL AND DIFFICULT TO MAINTAIN TEMP ON DESCENT. F/A REPORTS ODORS VARYING FROM FOUL TO AMMONIA TO SMOKEY. R & R CABIN TEMP REGULATOR IAW M/M.SDR SWAA2013061016994Web · crackedWEB CRACKED BETWEEN BS 188 TO BS 196.3, STR 17R. R & R WEB IAW SRM AND DWG.SDR SWAA2013052116294Skin · crackedSKIN ON VERTICAL CHEM-MILL CRACKED AT BS 360, STR 2L. REPAIRED SKIN IAW SRM.SDR SWAA2013052016213Cover · looseL1 DOOR EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER IAW MM.SDR SWAA2013052016232Stop · brokenRT WING NR 5 L/E SLAT INBD TRACK DOWNSTOP BROKEN. R & R DOWNSTOP IAW AMM.SDR SWAA2013052016231Stop · brokenRT WING NR 5 L/E SLAT OTBD TRACK DOWNSTOP BROKEN. R & R DOWNSTOP IAW AMM.SDR SWAA2013051716137Cowling · delaminatedNR 1 INBD FAN COWL DELAMINATED AT LOWER AFT CORNER. R & R COWL IAW SRM.SDR SWAA2013061917399Floorbeam · crackedFLOORBEAM LOWER CHORD CRACKED AT BS 664, LBL 45.5. R & R CHORD IAW SRM AND DWG.SDR SWAA2013060616838Bracket · crackedL1 DOOR FWD UPPER CORNER BRACKET CRACKED. R & R BRACKET IAW SRM AND DWG.SDR SWAA2013060616835Web · crackedWEB CRACKED AT BS 727, BETWEEN STR 17L TO STR 18L. REPAIRED WEB IAW SRM.SDR SWAA2013052016218Sign · missingR2 DOOR EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN IAW MM.SDR SWAA2013052016214Actuator · leakingRIGHT WING T/E INBD GROUND SPOILER OTBD SPOILER ACTUATOR LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2013051716133Battery · dischargedMID CABIN OVERHEAD EMERGENCY EXIT SIGN LIGHT INOP. R & R BATTERY IAW AMM.SDR SWAA2013051716132Lens · looseCAPTAINS SIDE OVERWING EMERGENCY EXIT LIGHT SIGN LOOSE. SECURED LENS IAW AMM.SDR SWAA2013051716155Charger · inoperativeMID CABIN OVERHEAD EMERGENCY EXIT SIGN LIGHT INOP. R & R CHARGER BASE IAW AMM.SDR SWAA2013051716154Skin · crackedRT WING NR 5 L/E SLAT LOWER SKIN LOWER FASTENER ROW AT OTBD END CRACKED. R & R NR 5 L/E SLAT ASSY IAW MM.SDR SWAA2013051716153Skin · crackedRIGHT WING INBD FIXED L/E SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2013051716152Sign · looseFWD ENTRY DOOR "EXIT" SIGN LOOSE ON LOWER THRESHOLD. R & R SIGN IAW MM.SDR SWAA2013051616089Light · inoperativeCAPTAINS SIDE EMERGENCY EXIT SIGN BULB INOP. RELAMPED PER AMM.SDR SWAA2013061016992Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 294.5, STR 23L. R & R BRACKET IAW SRM AND DWG.SDR SWAA2013060616834Fitting · crackedCLIP CRACKED AT BS 597, STR 11R. R & R CLIP IAW SRM AND DWG.SDR SWAA2013060516786Skin · delaminatedLEFT WING INBD FORE FLAP T/E SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013060416732Angle · crackedANGLE CRACKED AT BS 703, RBL 24.5. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013052816538Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STR 10L. R & R TIE CLIP IAW SRM AND DWG.SDR SWAA2013052816518Stringer Clip · crackedMAIN CABIN STRINGER CLIP CRACKED. R & R CLIP IAW SRM AND DWG.SDR SWAA2013051716151Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT STA 907, STR 4L. R & R CHANNEL IAW SRM AND DWG.SDR SWAA2013051616088Cleat · crackedUPPER CLEET CRACKED AT BS 727, RBL 19.5 BULKHEAD VERTICAL STIFFENER. REMOVED AND REPLACED CLEET PER SRM.SDR SWAA2013051516061Cover · looseFORWARD EMERGENCY EXIT LIGHT COVER LOOSE. REMOVED AND REPLACED COVER IAW M/M.SDR SWAA2013051516060Actuator · brokenLEFT WING INBOARD NR 4 GROUND SPOILER INBOARD ACTUATOR FWD ATTACH FITTING BROKEN. REMOVED AND REPLACED ACTUATOR PER M/M.SDR SWAA2013062417509Keelbeam · corrodedKEEL BEAM CORRODED BETWEEN BS 706 TO BS 727, RBL 6.50. REPAIRED KEEL BEAM IAW EO & EA.SDR SWAA2013062417508Keelbeam · corrodedKEEL BEAM CORRODED BETWEEN BS 706 TO BS 727, LBL 6.50. REPAIRED CHORD IAW EA.SDR SWAA2013061217119Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013061016991Web · corrodedWEB CORRODED BETWEEN BS 400 TO BS 420, STR 17L. R & R WEB IAW SRM AND DWG.SDR SWAA2013060516825Structure · crackedSUPPORT SENSOR BASE CRACKED AT BS 794.3, STR 23R. R & R CUTOUT IAW SRM.SDR SWAA2013060416731Support Angle · crackedR1 DOOR SUPPORT ANGLE CRACKED AT BS 294.5. R & R ANGLE IAW SRM.SDR SWAA2013060316678Door · delaminatedLEFT MAIN GEAR INNER DOOR AFT EDGE DELAMINATED. R & R DOOR IAW MM.SDR SWAA2013052816517Shear Tie · crackedSHEAR TIE CRACKED AT STA 967, BETWEEN STR 4L TO STR 5L. R & R SHEAR TIE IAW SRM.SDR SWAA2013052216386Bearing · looseLT WING INBD FLAP LOOSE ROD END BEARING ON INBD EXHAUST GATE. R & R BEARING IAW CMM.SDR SWAA2013052216373Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 3R. R & R TIE CLIP IAW SRM AND DWG.SDR SWAA2013052116325Bracket · crackedBRACKET CRACKED AT BS 351, BETWEEN STR 26L TO STR 27L. R & R BRACKET IAW SRM.SDR SWAA2013052016247Fitting · crackedLEFT ELEVATOR CLIP CRACKED AT ELEVATOR STA 63.93. R & R CLIP IAW SRM AND DWG.SDR SWAA2013051516055Light · looseRIGHT EEPLS LOOSE AT ROW 8. SECURED EEPLS PER MM.SDR SWAA2013051516036Lens · looseFORWARD OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER M/M.SDR SWAA2013062017445Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17R. R&R FRAME IAW SRM & DRAWING.SDR SWAA2013062017444Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17L. REPAIRED FRAME IAW SRM.SDR SWAA2013061817277Frame · corrodedFRAME LOWER FLANGE OF FRAME CORRODED AT BS 787, BETWEEN STRINGER 26L AND STR 27L. R & R FRAME IAW SRM AND DWG.SDR SWAA2013061217081Bracket · crackedFWD ENTRY DOOR FWD LOWER CORNER PLATE SEAL CRACKED. R & R BRACKET IAW SRM AND DWG.
Back to Boeing 737-3H4