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 SWAA2015021936716Trim Panel · corrodedR1 DOOR FWD CUT OUT FRAME LOWER TRIM CORRODED. REPAIRED CUT OUT IAW SRM & DWG.SDR SWAA2015021836704Door Sill · corrodedRIGHT AFT MOP SILL INNER CHORD CORRODED. R & R CHORD IAW SRM & DWG.SDR SWAA2015021736666Floorbeam · corrodedFLOORBEAM CORRODED AT BS 312, RBL 35. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015021736641Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, RBL 25. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015020236243Lug · brokenRIGHT WING NR 5 GND SPOILER OTBD LUG BROKEN. R & R NR 5 GND SPOILER IAW AMM.SDR SWAA2015021236562Skin · crackedSKIN CRACKED BETWEEN BS 960 TO 963, STRINGER 5R. REPAIRED SKIN IAW SRM.SDR SWAA2015021136522Pressure Deck · crackedMAIN WW PRESS DECK CRACKED BETWEEN BS 664 TO 675, LBL 34.50. REPAIRED DECK IAW SRM.SDR SWAA2015013036231Cable · misroutedR2 DOOR EMER EVAC SLIDE CABLE MISROUTED. REROUTED CABLE IAW MM.SDR SWAA2015013036221Lens · missingFORWARD PAX DOOR LOWER EXIT LIGHT LENS COVER MISSING. R & R COVER IAW AMM.SDR SWAA2015013036220Lens · brokenRIGHT OVERWING EMER EXIT LIGHT AT THE LOWER FWD CORNER OF THE DOOR LENS BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015012936183Flap Track · looseLEFT WING MID FLAP INBD AFT FLAP TRACK LOOSE. REPAIRED FLAP TRACK IAW AMM.SDR SWAA2015012936182Angle · crackedLEFT WING AILERON BALANCE BAY VERTICAL ANGLE CRACKED AT RSS 544. R & R ANGLE IAW SRM.SDR SWAA2015013036233Light · damagedG1 GALLEY EXIT LIGHT DAMAGED. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015012936181Bracket · crackedRIGHT WING AILERON COVE BRACKET CRACKED IN LOWER RADIUS. R & R BRACKET IAW SRM.SDR SWAA2015012936180Flap · delaminatedRIGHT WING INBD AFT FLAP DELAMINATED AT LOWER TE. R & R AFT FLAP IAW AMM.SDR SWAA2015012936173Lens · brokenFORWARD ENTRY FLOOR EMER EXIT LIGHT LENS BROKEN. R & R LENS IAW MM.SDR SWAA2015012836142Light · inoperativeRIGHT EMER EXIT LIGHT INOPERATIVE AT ROW 5. RELAMPED LIGHT IAW AMM.SDR SWAA2015012836141Light · inoperativeFORWARD RT OVERWING DOOR EMER EXIT LIGHT ASSEMBLY INOPERATIVE. RELAMPED LIGHT ASSEMBLY IAW AMM.SDR SWAA2015032737928Frame · crackedLEFT FUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A. REPAIRED SEAT TRACK IAW EA.SDR SWAA2015032737927Frame · crackedRIGHT FUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A. REPAIRED SEAT TRACK IAW EA.SDR SWAA2015031137333Bulkhead · corrodedBULKHEAD WEB CORRODED AT BS 1016, LBL 1. REPAIRED WEB IAW EA.SDR SWAA2015030937200Skin · crackedRIGHT WING NR 5 SLAT SKIN CRACKED AT LOWER SIDE AFT ROW FASTENERS AT INBD AUXILIARY TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2015030237025Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 787 TO 807 ON TOP SIDE. R & R WEB IAW SRM.SDR SWAA2015021336609Skin · crackedSKIN CRACKED AT BS 360, STRINGER 3R. REPAIRED SKIN IAW SRM.SDR SWAA2015021036502Strap · crackedSTRAP CRACKED AT BS 727, BETWEEN STRINGER 22 TO 27. R & R STRAP IAW SRM.SDR SWAA2015012836140Light · inoperativeLEFT OVERWING EMER EXIT SIDE WALL LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015021736643Skin · crackedSKIN CRACKED AT BS 500B+2, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2015012836139Light · inoperativeLEFT EMER EXIT SIDEWALL LIGHT ASSEMBLY INOPERATIVE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015012736119Skin · crackedFUSELAGE SKIN CRACKED AT BS 727D+14.5, BETWEEN STRINGER 27L TO 27R. REPAIRED SKIN IAW EA.SDR SWAA2015012636103Actuator · faultyDIVERSION, LT MAIN RED LIGHT REMAINS ILLUMINATED AFTER GEAR WAS RAISED TO UP. R & R LT MLG UPLOCK ACTUATOR IAW MM.SDR SWAA2015012636071Slide · out of adjustR2 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015012636026Battery · dischargedAFT GALLEY FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2015012636025Sign · looseRIGHT EMER EXIT SIGN ABOVE OVERWING DOOR LOOSE. SECURED SIGN IAW SIP.SDR SWAA2015030537147Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947.5, BETWEEN STRINGER 23L TO 24L. R & R SHEAR TIE IAW SRM.SDR SWAA2015030237024Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 827 TO 807 ON TOP SIDE. R & R WEB IAW SRM.SDR SWAA2015030237023Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO 400. REPAIRED WEB IAW SRM.SDR SWAA2015030237022Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500B TO 500C ON BOTTOM SIDE. REPAIRED WEB IAW SRM.SDR SWAA2015022336809Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 847 - 827 ON TOP SIDE. R & R WEB IAW SRM.SDR SWAA2015022036771Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 360 - 380. R & R WEB IAW SRM.SDR SWAA2015021136524Skin · crackedFUSELAGE SKIN CRACKED AT BS 500A+15, STRINGER 8R. REPAIRED SKIN IAW EA.SDR SWAA2015021136523Skin · crackedFUSELAGE SKIN CRACKED AT BS 500C+16, STRINGER 8R. REPAIRED SKIN IAW EA.SDR SWAA2015021036450Shear Tie · crackedSHEAR TIE CRACKED AT BS 320, STRINGER 20L. R & R SHEAR TIE IAW SRM.SDR SWAA2015020336299Shear Tie · crackedSHEAR TIE CRACKED AT BS 328, STRINGER 20L. R & R SHEAR TIE IAW SRM.SDR SWAA2015012936179Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4R. R & R SPLICE IAW SRM & DWG.SDR SWAA2015012636027Attach Angle · crackedRIGHT WING AILERON AFT BALANCE BAY OTBD ATTACH ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015021736667Skin · crackedSKIN CRACKED AT BS 400+15, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015021236563Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+12, STRINGER 26L. REPAIRED SKIN IAW EA.SDR SWAA2015020936423Skin · crackedSKIN CRACKED AT BS 948+15, STRINGER 5R. REPAIRED SKIN IAW SRM.SDR SWAA2015020936422Skin · crackedSKIN CRACKED AT BS 500C+1, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2015020936421Skin · crackedSKIN CRACKED AT BS 727C+13, STRINGER 2R. REPAIRED SKIN IAW SRM.
Back to Boeing 737-3H4