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 SWAA2015101244806Fitting · crackedLOWER NOSE COMPARTMENT INTERNAL STRUCTURE, ANGLE CLIP CRACKED AT BS 294.5, STRINGER 23L. R & R CLIP IAW DWG & SRM.SDR SWAA2015101244823Skin · delaminatedLEFT WING NR 0 GND SPOILER, DELAMINATED UPPER SURFACE. REPAIRED GND SPOILER IAW SRM.SDR SWAA2015100944742Fitting · crackedCLIP CRACKED AT BS 336, STRINGER 21L. R & R CLIP IAW SRM & DWG.SDR SWAA2015100944741Angle · crackedCLIP ANGLE CRACKED AT BS 328, STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015100744665Intercostal · crackedWEB INTERCOSTAL CRACKED, BETWEEN BS 312 - 324, BETWEEN STRINGER 28L - 28R. R & R WEB IAW SRM & DWG.SDR SWAA2015100744664Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015100744663Intercostal · crackedWEB INTERCOSTAL CRACKED, BETWEEN BS 294.5 - 312, BETWEEN STRINGER 28L - 27R. R & R WEB IAW DWG.SDR SWAA2015100644614Fitting · crackedINTERCOSTAL CLIP CRACKED AT BS 695, LBL 0.5. R & R CLIP SRM & DWG.SDR SWAA2015100644613Fitting · crackedINTERCOSTAL CLIP CRACKED AT BS 695, RBL 0.5. R & R CLIP IAW SRM & DWG.SDR SWAA2015092344229Skin · crackedRIGHT WING UPPER SKIN CRACKED, AFT SPAR AFT FASTENER STATION 175. REPAIRED SKIN IAW SRM.SDR SWAA2015092244179Hinge Fitting · brokenRIGHT WING NR 5 GND SPOILER HINGE FITTING BROKEN. R & R SPOILER IAW MM.SDR SWAA2015092144072Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015110545774Skin · crackedLEFT WING TE, UPPER SKIN CRACKED ON WBL 182. REPAIRED SKIN IAW EO & EA.SDR SWAA2015110345680Support Fitting · crackedLEFT WING REAR SPAR, AFT SUPPORT FITTING, CRACKED AT FASTENER HOLE, BETWEEN RSS 215.97 - 224.14. R & R FITTING IAW EO & EA.SDR SWAA2015110345679Spar · crackedLEFT WING REAR SPAR WEB, CRACKED ON FASTENER HOLE, BETWEEN RSS 215.97 - 224.14. REPAIRED WEB IAW EO & EA.SDR SWAA2015110345678Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED, BETWEEN RSS 215.97 - 224.14. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015110245649Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 21L TO 22L. REPAIRED FRAME IAW EA.SDR SWAA2015110245648Spar · crackedLEFT WING REAR SPAR, UPPER CHORD UPPER FASTENER HOLE CRACKED AT RSS 223.14. REPAIRED CHORD IAW EA.SDR SWAA2015110245541Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD CRACKED, BETWEEN RSS 215.97 - RSS 224.14, AT 7 O CLOCK. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015102845436Skin · crackedFUSELAGE SKIN CRACKED, BETWEEN BS 294.5 - 312, BETWEEN STRINGER 12L - 15L. REPAIRED SKIN IAW SRM.SDR SWAA2015102345274Skin · crackedR1 DOOR BEAR STRAP SKIN LOWER HINGE CUT OUT CRACKED, BETWEEN BS 294.5 - 312, BETWEEN STRINGER 12L - 15L. REPAIRED SKIN IAW SRM.SDR SWAA2015102345278Skin · crackedL1 DOOR LOWER HINGE SKIN CUT OUT CRACKED AT BS 303.9, STRINGER 13L. REPAIRED SKIN IAW ER.SDR SWAA2015102245242Stiffener · crackedRIGHT LONGITUDINAL FLOORBEAM STIFFENER CRACKED AT BS 663. REPAIRED STIFFENER IAW EA.SDR SWAA2015102245221Skin · crackedR1 DOOR EXTERNAL FUSELAGE SKIN LOWER HINGE CUT OUT ON BEAR STRAP CRACKED, BETWEEN BS 294.5 - 312, BETWEEN STRINGER 12L - 15L. R & R SKIN IAW SRM.SDR SWAA2015101945046Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 435, RBL 69. R & R WEB IAW SRM & DWG.SDR SWAA2015101945045Floor Support · crackedLONGITUDINAL FLOORBEAM, UPPER CHORD CRACKED AT BS 671, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2015101544930Support Fitting · corrodedLEFT WING NR 2 FLAP TRACK SUPPORT FITTING CORRODED. R & R FITTING IAW DWG & SRM.SDR SWAA2015101344863Angle · crackedFORWARD CARGO COMPARTMENT, ANGLE CRACKED AT BS 400, STRINGER 26R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015101244805Intercostal · crackedWEB INTERCOSTAL CRACKED, BETWEEN BS 500B - 500C, STRINGER 26R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015100844715Flap Track · corrodedLEFT WING NR 2 FLAP TRACK UPPER AFT MOUNT PAD CORRODED. R & R NR 2 FLAP TRACK IAW AMM.SDR SWAA2015100744662Tie Clip · crackedFORWARD CARGO COMPARTMENT TIE CLIP, CRACKED AT BS 500D, STRINGER 19R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015100744661Channel · crackedFORWARD CARGO COMPARTMENT CHANNEL CRACKED, BETWEEN BS 420 - 440, STRINGER 26R. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015100744660Angle · crackedFORWARD CARGO COMPARTMENT ANGLE, CRACKED AT BS 380, STRINGER 26R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015100544580Support · crackedINTERCOSTAL SUPPORT CRACKED AT BS 291.5, STRINGER 10R. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015100144462Support · crackedINTERCOSTAL SUPPORT STRUCTURE OUTER LOWER CHORD CRACKED, BETWEEN STRINGER 10R - 11R. R & R CHORD IAW SRM.SDR SWAA2015092944360Bulkhead · crackedWEB CRACKED AT BS 178, RBL 17.0. REPAIRED WEB IAW SRM.SDR SWAA2015092544283Bulkhead · crackedWEB CRACKED AT BS 178, RBL 17. REPAIRED WEB IAW SRM.SDR SWAA2015110445744Skin · crackedAFT CARGO DOOR FUSELAGE SKIN CUT OUT CRACKED AT BS 807-10, BETWEEN STRINGER 23R - 26R. REPAIRED SKIN IAW EA.SDR SWAA2015110345698Skin · crackedFUSELAGE SKIN CRACKED, BETWEEN BS 777 - 818, BETWEEN STRINGER 22R - 26R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015110245655Support Fitting · crackedRIGHT WING REAR SPAR AFT MLG SUPPORT FITTING CRACKED. R & R FITTING IAW EA.SDR SWAA2015110245654Spar · crackedRIGHT WING REAR SPAR WEB, CRACKED AT UPPER CHORD AT MLG FWD SUPPORT FITTING. REPAIRED SPAR WEB IAW ER & EA.SDR SWAA2015110245647Support Fitting · crackedRIGHT WING REAR SPAR AT AFT SUPPORT FITTING CRACKED, BETWEEN RSS 215.97 TO 224.14. R & R FITTING IAW EA.SDR SWAA2015112045646Spar · crackedRIGHT WING REAR SPAR WEB FASTENER HOLE CRACKED, BETWEEN RSS 215.97 TO 224.14. REPAIRED SPAR WEB IAW EA.SDR SWAA2015110245645Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD FASTENER HOLE CRACKED, BETWEEN RSS 215.97 TO 224.14. REPAIRED CHORD IAW EA.SDR SWAA2015102745396Frame · crackedFRAME WEB CRACKED AT BS 639 AROUND FASTENER, ABOVE FLOOR LEVEL. REPAIRED WEB IAW EA.SDR SWAA2015102645319Intercostal · crackedINTERCOSTAL WEB CRACKED, BETWEEN BS 277 TO BS 277, STRINGER 14R. R & R WEB IAW EA.SDR SWAA2015102645356Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, RBL 17. REPAIRED WEB IAW SRM.SDR SWAA2015102345277Skin · crackedR1 DOOR BEAR STRAP CUT OUT LOWER FWD CORNER CRACKED, BETWEEN BS 282 - 286, BETWEEN STRINGER 16R - 17R. REPAIRED SKIN IAW EA.SDR SWAA2015102245222Skin · crackedL1 DOOR THRESHOLD AFT SUPPORT COMMON TO THE FUSELAGE SKIN CRACKED. R & R SKIN IAW SRM.SDR SWAA2015101945071Strap · crackedRIGHT WING, NR 6 FAIRING FLAP TRACK STRAP CRACKED. R & R STRAP IAW DWG.
Back to Boeing 737-3H4