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 SWAA2015052640010Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 21R - 22RL. REPAIRED FRAME IAW EA.SDR SWAA2015052640009Frame · crackedFRAME CRACKED AT BS 1006, STRINGER 21L+5. REPAIRED FRAME IAW EO & EA.SDR SWAA2015052640017Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 947.5, LBL 53.50. REPAIRED CHORD IAW EO & EA.SDR SWAA2015051939818Frame · crackedFRAME CRACKED AT BS 380, STRINGER 23L. REPAIRED FRAME IAW EO & EA.SDR SWAA2015051839791Frame · crackedLEFT FRAME WEB CRACKED AT BS 235.8, BETWEEN WL 220 - WL 230. REPAIRED WEB IAW EA.SDR SWAA2015051439656Structure · crackedOUTBOARD CHORD CRACKED AT BS 188 RT SIDE AT LEVEL OF FLOOR FLIGHT CREW COMPARTMENT. REPAIRED CHORD IAW SRM.SDR SWAA2015051439655Structure · crackedOUTBOARD CHORD CRACKED AT BS 188, LT SIDE AT LEVEL OF THE FLOOR FLIGHT CREW COMPARTMENT. REPAIRED CHORD IAW SRM.SDR SWAA2015050439264Fitting · crackedAFT CARGO COMPARTMENT CLIP CRACKED AT BS 947.5, STRINGER 22R. R & R CLIP IAW SRM & DWG.SDR SWAA2015042038667Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 26L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015040738185Skin · delaminatedRIGHT WING INBD GND SPOILER DELAMINATED ON UPPER SKIN. R & R SPOILER ASSEMBLY IAW AMM.SDR SWAA2015040638109Window · arcedR1 WINDOW ARCED DURING FLIGHT. R & R R1 WINDOW IAW AMM.SDR SWAA2015040238086Window · arcedR1 WINDOW ARCED. R & R R1 WINDOW IAW AMM.SDR SWAA2015040238072Cover · unsecureL1 DOOR EXIT SIGN COVER FELL OFF. SECURED COVER IAW MM,SDR SWAA2015040238069Lens · missingR1 DOOR LOWER FWD SIDE EMER EXIT LIGHT LENS MISSING. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015052239937Skin · crackedFORWARD SERVICE DOOR LOWER HINGE CUT OUT CRACKED AT BS 291.5, STRINGER 13R. REPAIRED CUT OUT IAW EA.SDR SWAA2015051139522Angle · crackedANGLE CRACKED BETWEEN BS 927 - 947.5, BETWEEN STRINGER 14R - 15R. R & R ANGLE IAW SRM.SDR SWAA2015050639337Fitting · crackedFORWARD CARGO COMPARTMENT CLIP CRACKED AT BS 540, BETWEEN STRINGER 28R - 28L. R & R CLIP IAW SRM.SDR SWAA2015050439281Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 500B, STRINGER 26L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042939108Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540, STRINGER 24L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042038666Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 22R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015041438483Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 22R. R & R TIE CLIP IAW SRM.SDR SWAA2015040738206Battery · brokenM1675 EMER EXIT LIGHT POWER SUPPLY BATTERY LATCH BROKEN. R & R BATTERY IAW AMM.SDR SWAA2015040138055Lens · looseRIGHT OVERWING EXIT ROW LIGHT LENS LOOSE. R & R LENS IAW MM.SDR SWAA2015040138038Battery Pack · dischargedRIGHT EMER EXIT LIGHT INOPERATIVE AT ROW 1. R & R BATTERY PACK ASSEMBLY IAW MM.SDR SWAA2015040138035Blower · failedDIVERSION, DECLARED EMER. DURING CRUISE WE SMELLED FUMES IN THE COCKPIT & IN THE CABIN. NO ABNORMAL ENG OR ELEC INDICATIONS WERE NOTED. AIR CONDITIONING SYS SEEMED NORMAL. FOUND NORMAL EQUIP COOLING FAN BLOWER FAILED & CAUSE OF ELEC SMELL. R & R NORMAL EQSDR SWAA2015033138009Charger · inoperativeLEFT OVERHEAD EMER LIGHT INOPERATIVE AT ROW 10. R & R CHARGER ASSEMBLY IAW MM.SDR SWAA2015052640008Frame · crackedFRAME CRACKED AT BS 360, STRINGER 14R. REPAIRED FRAME IAW SRM.SDR SWAA2015052239936Flap Track · corrodedRIGHT WING INBD FLAP, INBD TRACK AFT ATTACHMENT LUG CORRODED. REPAIRED FLAP TRACK IAW EA.SDR SWAA2015052239935Flap Track · corrodedLEFT WING INBD FLAP, INBD FLAP TRACK AFT ATTACHMENT, OTBD LUG CORRODED. REPAIRED FLAP TRACK IAW EA.SDR SWAA2015051839790Frame · crackedFRAME CRACKED AT BS 380, STRINGER 23L. REPAIRED FRAME IAW EA.SDR SWAA2015051339630Shear Web · corrodedCREASE BEAM SHEAR WEB CORRODED BETWEEN BS 420 - 440, STRINGER 17L. REPAIRED WEB IAW EO & EA.SDR SWAA2015051139521Channel · crackedCHANNEL CRACKED BETWEEN BS 294.5 - 312, BETWEEN STRINGER 27L - 26L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015050839459Web · crackedAFT CARGO COMPARTMENT WEB CRACKED AT BS 794.3, BETWEEN STRINGER 24R - 25R. R & R WEB IAW SRM & DWG.SDR SWAA2015050639336Web · corrodedWEB CORRODED BETWEEN BS 460 - 480, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015050639335Web · crackedAFT CARGO COMPARTMENT WEB CRACKED AT BS 847, BETWEEN STRINGER 24R - 25R. R & R WEB IAW SRM & DWG.SDR SWAA2015050539302Web · crackedWEB CRACKED BETWEEN BS 787 - 807, RBL 17.5. R & R WEB IAW SRM.SDR SWAA2015050139206Angle · crackedVERTICAL STIFFENER ANGLE CRACKED BS 727, BETWEEN LBL 45 TO LBL 52. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042839062Web · crackedWEB CRACKED BETWEEN BS 188 - 196.5, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2015042738981Stanchion · crackedSTANCHION CRACKED AT BS 294.5+5, STRINGER 27R. R & R STANCHION IAW SRM & DWG.SDR SWAA2015042138734Shear Tie · crackedWEB SHEAR TIE CRACKED BETWEEN BS 188 - 196.5, STRINGER 17L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015042038665Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 15R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015042038664Fitting · crackedCLIP CRACKED AT BS 807, STRINGER 25R. R & R CLIP IAW SRM & DWG.SDR SWAA2015042038662Web · crackedWEB CRACKED AT BS 727, BETWEEN RBL 38 - 45. R & R WEB IAW SRM & DWG.SDR SWAA2015041638592Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 380, STRINGER 20L. R & R BRACKET IAW SRM & DWG.SDR SWAA2015041338394Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 727, STRINGER 23R. R & R SPLICE IAW SRM & EA.SDR SWAA2015041338393Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 16R. R & R TIE CLIP IAW SRM.SDR SWAA2015041338392Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STRINGER 16R. R & R TIE CLIP IAW SRM.SDR SWAA2015041338453Stringer · corrodedSTRINGER CORRODED AT BS 807, STRINGER 27L. REPAIRED STRINGER IAW EA.SDR SWAA2015040638136Stringer · crackedAFT CARGO COMPARTMENT STRINGER CHANNEL CRACKED AT BS 727, STRINGER 23L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015040638129Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 19L. R & R TIE CLIP IAW SRM & DWG.
Back to Boeing 737-3H4