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 SWAA2016010447611Flap · delaminatedLEFT WING TE OTBD AFT FLAP DELAMINATED. R & R FLAP IAW MM.SDR SWAA2016020948821Skin · crackedLEFT WING REAR SPAR UPPER SKIN CRACKED, BETWEEN RSS 215 - 267.5. REPAIRED SKIN IAW EA.SDR SWAA2016020548731Spar · crackedLT WING REAR SPAR WEB CRACKED AT RSS 186. REPAIRED WEB IAW EA.SDR SWAA2016020248598Crease Beam · corrodedFORWARD SERVICE DOOR CREASE BEAM WEB CORRODED AT BS 332, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2016012748411Spar · crackedRIGHT WING AFT SPAR UPPER CHORD CRACKED IN NR 5 OPENED FASTENER HOLE. REPAIRED CHORD IAW EA. .SDR SWAA2016012748410Spar · crackedLEFT WING AFT SPAR, UPPER CHORD CRACKED IN NR 5 OPENED FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2016010447622Lens · crackedRIGHT MID CABIN EXIT LIGHT LENS CRACKED. R & R LENS IAW MM.SDR SWAA2016010447612Lens · looseL1 DOOR EXIT SIGN LENS LOOSE. INSTALLED LENS IAW MM.SDR SWAA2015123147573Lens · crackedRIGHT AFT OF OVERWING EXTERIOR EXIT LIGHT LENS CRACKED. R & R LENS IAW MM.SDR SWAA2016021649110Stringer · corrodedSTRINGER CORRODED, BETWEEN BS 1006 - 1016, STRINGER 26R. R & R STRINGER IAW SRM.SDR SWAA2016021649096Support Fitting · crackedRIGHT WING REAR SPAR, UPPER CHORD MLG SUPPORT FITTING CRACKED, AT RSS 222.5. REPAIRED CHORD ER & EA.SDR SWAA2016020548730Skin · crackedRT WING REAR SPAR UPPER SKIN CRACKED AT WSTA 196. REPAIRED SKIN IAW EA.SDR SWAA2016020548729Skin · crackedRT WING REAR SPAR UPPER SKIN CRACKED AT WSTA 186.5. REPAIRED SKIN IAW EA.SDR SWAA2015123147574Lens · brokenR2 DOOR EXIT LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015123047530Skin · delaminatedRIGHT WING NR 6 LE SLAT UPPER SKIN DELAMINATED. REPAIRED SLAT IAW SRM.SDR SWAA2016020248601Support Angle · crackedAFT CARGO COMPARTMENT, SUPPORT ANGLE CRACKED AT BS 947.5, STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2016013048462Skin · crackedLEFT WING UPPER SKIN COMMON TO TE NUTPLATE STRIP, 2 EACH FASTENER HOLES CRACKED, BETWEEN RSS 260 - 262. REPAIRED SKIN IAW EA.SDR SWAA2016011147864Skin · delaminatedLEFT WING FIXED LE, UPPER SKIN DELAMINATED AT LEVEL FSS 536. REPAIRED SKIN IAW SRM.SDR SWAA2016021649100Skin · crackedRIGHT WING UPPER SKIN, AT REAR SPAR HOLE CRACKED, AT RSS 232.5, FWD ROW. REPAIRED SKIN IAW EA.SDR SWAA2015122947475Lug · brokenLEFT WING NR 4 GND SPOILER HINGE LUG BROKEN. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2015122947473Door Frame · crackedR2 DOOR FWD FUSELAGE CUT OUT FRAME CRACKED. R & R FRAME IAW SRM.SDR SWAA2015122847439Lug · brokenLEFT WING INBD GND SPOILER LUG BROKEN. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2015122847432Lug · brokenNUMBER 4 GND SPOILER INBD LUG BROKEN. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2015122847431Slide · out of positionL1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2016040550611Bracket · crackedRIGHT WING FRONT SPAR LOWER FWD CAP FSS 240, SUPPORT ANGLE BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2016021849191Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD FASTENER HOLES CRACKED, BETWEEN RSS 222.5 - 228.5. REPAIRED IAW EA.SDR SWAA2016021849173Spar · crackedRIGHT WING REAR SPAR WEB FASTENER HOLES CRACKED, BETWEEN RSS 219.50 - 222.5. REPAIRED WEB IAW EA.SDR SWAA2016021649109Spar · crackedLEFT WING, REAR SPAR UPPER WEB FASTENER HOLES CRACKED, LOCATED BETWEEN RSS 219 - 222.5. REPAIRED WEB IAW EA.SDR SWAA2016021649108Spar · crackedLEFT WING REAR SPAR UPPER CHORD, ONE EACH FASTENER HOLE CRACKED, LOCATED AT RSS 222.5. REPAIRED CHORD IAW EA.SDR SWAA2016020148544Skin · crackedRIGHT WING UPPER SKIN CRACKED, AT FASTENER HOLES COMMON TO TE NUTPLATE STRIP, BETWEEN RSS 238 - 254. REPAIRED SKIN IAW ER & EA.SDR SWAA2016020148543Skin · crackedRIGHT WING UPPER SKIN CRACKED, AT FASTENER HOLE COMMON TO FWD MLG BEAM FITTING, FWD OTBD HOLE APPROX RSS 225. REPAIRED SKIN IAW ER & EA.SDR SWAA2015122847434Slat · delaminatedNUMBER 5 LE SLAT DELAMINATED. R & R SLAT ASSEMBLY IAW MM.SDR SWAA2016021649095Skin · corrodedSKIN CORRODED, BETWEEN BS 987 - 1006, STRINGER 27L. REPAIRED SKIN IAW EA.SDR SWAA2016020948778Shear Tie · corrodedSHEAR TIE CORRODED AT BS 967, STRINGER 27L. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2016011948165Fitting · crackedRIGHT WING AFT MLG BEAM FITTING CRACKED IN UPPER HOLE, AT RSS 222. R & R FITTING IAW EA.SDR SWAA2016011347978Shear Tie · corrodedSHEAR TIE CORRODED AT BS 1006, BETWEEN STRINGER 27L - 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016011347977Shear Tie · corrodedSHEAR TIE CORRODED AT BS 987, BETWEEN STRINGER 27L - 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015123047519Splice · crackedFUSELAGE SKIN BUTT SPLICE CRACKED AT STATION 908, STRINGER 4L. REPAIRED SPLICE IAW EA.SDR SWAA2015122847438Slat · delaminatedLEFT WING NR 2 LE SLAT DELAMINATED. R & R SLAT ASSEMBLY IAW MM.SDR SWAA2016020548727Support Fitting · crackedLT WING NR 4 SPOILER ACTUATOR SUPPORT FITTING CRACKED. R&R FITTING IAW SRM AND DWG.SDR SWAA2016012648383Skin · delaminatedLEFT WING EXTERNAL SKIN DELAMINATED ON INBD FLAP, OTBD TRACK FAIRING. REPAIRED SKIN IAW SRM.SDR SWAA2016012148258Carriage · corrodedRIGHT WING OTBD MID FLAP NR 7 FLAP TRACK CARRIAGE CORRODED ON LOWER SURFACE OF SPINDLE PORTION OF THE ROOT. R & R CARRIAGE IAW CMM.SDR SWAA2016012148253Angle · crackedLEFT WING ANGLE CRACKED ON INBD FLAP, OTBD TRACK FAIRING 3. R & R ANGLE IAW SRM & DWG.SDR SWAA2016012148252Doubler · crackedLEFT WING DOUBLER CRACKED ON INBD FLAP, OTBD TRACK FAIRING. R & R DOUBLER IAW SRM & DWG.SDR SWAA2016012148251Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED AT INTERNAL AREA OF INBD FLAP, OTBD TRACK FAIRING. R & R SUPPORT ANGLE IAW SRM & DWG.SDR SWAA2016012148250Support Angle · crackedRIGHT WING SUPPORT ANGLE CRACKED AT EXTERNAL AREA OF INBD FLAP, OTBD TRACK FAIRING. R & R SUPPORT ANGLE IAW SRM & DWG.SDR SWAA2016011948164Carriage · corrodedRIGHT WING OUT FLAP NR 8 FLAP TRACK CARRIAGE A-FRAME BOLT HOLES CORRODED. R & R CARRIAGE PER CMM.SDR SWAA2016010747776Support Fitting · crackedLEFT WING SUPPORT CLIP CRACKED AT INTERNAL AREA OF INBD FLAP, OTBD TRACK FAIRING. R & R CLIP IAW SRM & DWG.SDR SWAA2016010447637Skin · crackedFUSELAGE SKIN CRACKED AT STATION 915, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2016010447636Skin · crackedFUSELAGE SKIN CRACKED AT STATION 732, STRINGER 7R. REPAIRED SKIN IAW SRM.
Back to Boeing 737-3H4