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 SWAA2015033037960Shear Tie · corrodedSHEAR TIE CORRODED AT BS 986.5, BETWEEN STRINGER 27L - 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015032337707Web · crackedWEB CRACKED BETWEEN BS 312 - 328, RBL 31.6. R & R WEB IAW SRM & DWG.SDR SWAA2015032337706Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 8R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015043039178Stiffener · crackedAFT FACE OF PRESS BULKHEAD STIFFENER CRACKED AT BS 727, RBL 6.3. REPLACED STIFFENER IAW SRM & DWG.SDR SWAA2015042738975Web · crackedWEB INTERNAL STRUCTURE LOWER FWD CORNER OF L1 DOOR CRACKED. R & R WEB IAW SRM & DWG.SDR SWAA2015042438905Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5, BETWEEN STRINGER 24R - 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042438882Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947.5, BETWEEN STRINGER 27L - 26R. R & R SHEAR TIE IAW SRM.SDR SWAA2015041338406Stringer · corrodedSTRINGER CORRODED BETWEEN BS 1006 - 1016, STRINGER 26R. R & R STRINGER IAW SRM.SDR SWAA2015041338445Shear Tie · corrodedAFT CARGO PIT SHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 26L - 26R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015041338444Intercostal · corrodedAFT CARGO PIT INTERCOSTAL CORRODED BETWEEN BS 727A - 727B, STRINGER 26L. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015040938317Shear Tie · corrodedAFT CARGO PIT SHEAR TIE CORRODED AT BS 807, BETWEEN STRINGER 26L - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015040938316Shear Tie · corrodedAFT CARGO PIT SHEAR TIE CORRODED AT BS 807, BETWEEN STRINGER 25L - 26L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015040738190Support Angle · crackedRIGHT WING NR 6 FLAP OTBD TRACK SUPPORT ANGLE CRACKED AT INBD CORNER. R & R ANGLE IAW SRM & DWG.SDR SWAA2015040638132Tie Clip · crackedTIE CLIP CRACKED AT BS 727D, STRINGER 25L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015040238083Shear Tie · corrodedSHEAR TIE CORRODED AT BS 907, BETWEEN STRINGER 27L - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015040138052Shear Tie · corrodedSHEAR TIE CORRODED AT BS 827 - 26R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015033037946Wedge · debondedRIGHT WING INBD MID FLAP SKIN LOWER SURFACE OF WEDGE PANEL DEBONDED. REPAIRED MID FLAP IAW SRM.SDR SWAA2015032337722Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STRINGER 28R - 27R. REPAIRED FRAME IAW SRM.SDR SWAA2015031637459Battery Pack · dischargedRIGHT EMER EXIT LIGHT INOPERATIVE AT ROW 9. R & R BATTERY PACK ASSEMBLY IAW AMM.SDR SWAA2015051439664Battery Pack · dischargedR2 DOOR EMER LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2015042438870Skin · crackedFUSELAGE SKIN CRACKED AT BS 967+12.5, STRINGER 21L. REPAIRED SKIN IAW EA.SDR SWAA2015042438867Skin · crackedFUSELAGE SKIN CRACKED AT BS 967+4.25, STRINGER 21L. REPAIRED SKIN IAW EA.SDR SWAA2015042438866Skin · crackedFUSELAGE SKIN CRACKED AT BS 927+7, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2015042438865Skin · crackedFUSELAGE SKIN CRACKED AT BS 907+14.5, STRINGER 25L. REPAIRED SKIN IAW EA.SDR SWAA2015041738636Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, STRINGER 17R, THE LOWEST FASTENER POSITION. REPAIRED CHORD IAW EA.SDR SWAA2015041538526Support · crackedRIGHT WING NR 7 FLAP TRACK AROUND SUPPORT STRUCTURE CRACKED. REPAIRED SUPPORT IAW EO & EA.SDR SWAA2015041338400Access Panel · crackedRIGHT PYLON NACELLE STRUT ACCESS PANEL 5864R CRACKED. REPAIRED PANEL IAW EO.SDR SWAA2015040638154Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED AT RSS 537.806 INTERNAL STRUCTURE TE. R & R ANGLE IAW SRM & DWG.SDR SWAA2015040638153Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED BETWEEN BS 927 - 947.5. R & R ANGLE IAW SRM & DWG.SDR SWAA2015032637858Flap Track · corrodedLEFT WING NR 4 FLAP TRACK CORRODED ON INBD HOLE AFT POSITION. REPAIRED FLAP TRACK IAW CMM.SDR SWAA2015032637857Flap Track · corrodedRIGHT WING NR 5 FLAP TRACK CORRODED ON INBD HOLE AFT POSITION. REPAIRED FLAP TRACK IAW CMM.SDR SWAA2015032337679Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 986 TO 1006, STRINGER 21R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015032337705Angle · crackedTIE CLIP ANGLE CRACKED AT BS 360, STRINGER 8L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015031937614Skin · crackedR2 DOOR FUSELAGE SKIN CUT OUT CRACKED AT FWD, LOWER RADIUS BS 844. REPAIRED SKIN CRACK IAW SRM.SDR SWAA2015031737476Angle · crackedLEFT WING AILERON BALANCE BAY ANGLE CRACKED AT NR 3 HINGE AREA. R & R ANGLE IAW SRM.SDR SWAA2015031637460Lens · brokenL1 DOOR EMER EXIT SIGN LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2015050439246Crossbeam · crackedAFT CARGO DOOR CROSSBEAM E T CHORD CRACKED INDICATION FOUND ON THE SURFACE. REPAIRED CROSSBEAM IAW EA & DWG.SDR SWAA2015042038699Frame · crackedFRAME CRACKED AT BS 947.5, STRINGER 19L. R & R FRAME IAW SRM & DWG.SDR SWAA2015042038676Frame · crackedFRAME INNER CHORD CRACKED BETWEEN BS 348.2 - 351.2, BETWEEN STRINGER 14L - 17L. REPAIRED FRAME IAW EA.SDR SWAA2015041738618Skin · crackedSKIN CRACKED AT BS 520+4.0, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2015041738617Skin · crackedSKIN CRACKED AT BS 500D+4.5, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2015041638596Skin · crackedFUSELAGE SKIN CRACKED AT BS 927+6.5, STRINGER 24R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015041638595Skin · crackedFUSELAGE SKIN CRACKED AT BS 927+13.750, STRINGER 23R. REPAIRED SKIN IAW EA.SDR SWAA2015041638594Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+14, STRINGER 8L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015041338399Tee Fitting · crackedAFT CARGO COMPARTMENT CROSS BEAM E T CHORD CRACKED AT BS 827+13. REPAIRED T CHORD IAW EA.SDR SWAA2015041038344Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+5, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2015040838272Panel · crackedNOSE LANDING GEAR WW SIDE PANEL CRACKED AT BS 243.7+3, WL 169.1 LT SIDE. REPAIRED PANEL IAW SRM.SDR SWAA2015040638141Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 277 - 291.5, STRINGER 14R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015033037954Slat · delaminatedLEFT WING NR 2 LE SLAT DELAMINATED AT OTBD UPPER TE. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2015032637856Angle · crackedANGLE CRACKED BETWEEN BS 277 - 291.5, STRINGER 10R. R & R ANGLE IAW SRM & DWG.
Back to Boeing 737-3H4