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 SWAA2014021325109Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014021125047Bracket · brokenRT WING INBD MIDFLAP BRACKET BROKEN. R & R BRACKET ASSEMBLY IAW CMM.SDR SWAA2014021125003Skin · crackedR2 DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014021024974Fitting · crackedLT WING TE NR 3 FAIRING INTERNAL AREA FITTING CRACKED. R & R FITTING IAW SRM & DRAWING.SDR SWAA2014021024964Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 352. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014020524885Cover · brokenFWD ENTRY DOOR EMERGENCY EXIT SIGN COVER BROKEN. R & R SIGN ASSEMBLY IAW SIP.SDR SWAA2014020524861Cover · missingRT LOWER EMERGENCY EXIT SIGN COVER MISSING AT ROW 12. INSTALLED COVER IAW MM.SDR SWAA2014020524877Sign · brokenL1 DOOR EMERGENCY EXIT SIGN BROKEN. R & R SIGN ASSEMBLY IAW MM.SDR SWAA2014030325683Skin · crackedSKIN CRACKED AT BS 360, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2014030325682Skin · crackedSKIN CRACKED AT BS 362, STRINGER 1R. REPAIRED SKIN IAW EA.SDR SWAA2014022725605Skin · crackedR1 DOOR UPPER HINGE CUTOUT SKIN CRACKED AT BS 947.5, STRINGER 11R. REPAIRED SKIN IAW SRM.SDR SWAA2014022425468Doubler · crackedLT MLG WW FWD SIDE BS 727 BULKHEAD, LBL 51, BELOW STRINGER 21L, BONDED DOUBLER CRACKED. REPAIRED DOUBLER IAW SWA EA.SDR SWAA2014021925321Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, BL 0. REPAIRED WEB IAW SRM.SDR SWAA2014021925302Support Angle · crackedRT WING SUPPORT ANGLE CRACKED BETWEEN RSS 517 TO RSS 534. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014020524858Gasper Fan · failedSTRONG ODOR REPORTED FROM CABIN. R & R GASPER FAN IAW MM.SDR SWAA2014020424826Light · looseRT FWD EEPLS LOOSE. SECURED EEPLS IAW MM.SDR SWAA2014022425467Skin · crackedR2 DOOR CUT OUT LOWER FWD CORNER CRACKED. REPAIRED CUT OUT IAW SRM & EA.SDR SWAA2014022425434Structure · crackedLT MAIN WW CHORD CRACKED AT BS 680.75. R & R CHORD IAW SRM & DRAWING.SDR SWAA2014021725192Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+1, BETWEEN RBL 45.5 TO RBL 24.5. REPAIRED DECK IAW SRM.SDR SWAA2014021325111Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R SPLICE IAW SRM & DRAWING.SDR SWAA2014021225083Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STRINGER 8L. R & R CLIP IAW DRAWING.SDR SWAA2014021225082Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STRINGER 8L. R & R CLIP IAW DRAWING.SDR SWAA2014020324765Light · inoperativeR2 DOOR EMERGENCY EXIT SLIDE LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2014022725604Frame · crackedLT SIDE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A. REPAIRED CHORD IAW EA.SDR SWAA2014022725603Frame · crackedRT SIDE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A. REPAIRED CHORD IAW EA.SDR SWAA2014022625560Fairing · delaminatedLT WING FAIRING ATTACHED TO CTR FAIRING DELAMINATED. REPAIRED FAIRING IAW EO & EA.SDR SWAA2014022025344Door Frame · crackedR2 DOOR FWD LOWER CORNER STUD FRAME CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014021925325Skin · crackedLT WING LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2014031826195Bulkhead · corrodedAFT BULKHEAD CORRODED AT BS 1016, BL 0. REPAIRED BULKHEAD IAW EA.SDR SWAA2014022525519Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947.5 & BETWEEN STRINGER 24L TO STRINGER 26L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2014022425466Skin · crackedR1 DOOR UPPER FWD CORNER CUT OUT CRACKED AT BS 296, STRINGER 7R. R & R CUT OUT IAW DRAWING & SRM.SDR SWAA2014022425454Angle · crackedCLIP ANGLE CRACKED AT BS 947.5, STRINGER 25L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022425453Angle · crackedANGLE CRACKED AT BS 947.5, STRINGER 24R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022125377Angle · crackedVERTICAL ANGLE CRACKED AT BS 328, STRINGER 27R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021825276Tie Clip · crackedTIE CLIP CRACKED AT BS 294.5, STRINGER 23L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014021725240Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 297, RBL 15. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725239Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 19L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014021725238Frame · corrodedFRAME CORRODED AT BS 328, STRINGER 27R. R & R FRAME IAW SRM & DRAWING.SDR SWAA2014021425145Angle · crackedCLIP ANGLE CRACKED AT BS 947.5, STRINGER 22L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021425144Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 351.2, LBL 13. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021425143Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 22L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014021325124Stringer · corrodedSTRINGER CORRODED BETWEEN BS 967 TO BS 987, STRINGER 25L. REPAIRED STRINGER IAW SRM.SDR SWAA2014021225090Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME INBD FLANGE CRACKED AT INNER RADIUS ADJACENT TO INBD LOWER CORNER OF BOTTOM STOP FITTING. R & R FRAME IAW ACO.SDR SWAA2014021125007Support Angle · crackedCREASE BEAM SUPPORT ANGLE CRACKED BETWEEN BS 962 TO BS 984. R & R BEAM IAW SRM & DRAWING.SDR SWAA2014021125006Angle · crackedFWD ENTRY DOOR CUTOUT STRUCTURE ANGLE CRACKED BETWEEN BS 354 TO BS 356, STRINGER 8L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021125005Angle · crackedFWD ENTRY DOOR CUTOUT STRUCTURE ANGLE CRACKED AT BS 348, STRINGER 15L. REPAIRED ANGLE IAW SRM & DRAWING.SDR SWAA2014021024982Angle · crackedANGLE CRACKED AT BS 321, STRINGER 28L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021024963Stiffener · crackedLT WING NR 3 FLAP TRACK STIFFENER CRACKED. LOCATED ON INTERNAL AREA AFT LOWER CT POSITION. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2014021024943Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 908, STRINGER 4L. R & R CHANNEL IAW DRAWING & SRM.SDR SWAA2014021024942Bracket · crackedLT WING AIL TE STRUCTURE ANGLE BRACKET CRACKED. R & R BRACKET IAW SRM.
Back to Boeing 737-3H4