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 SWAA2014060228569Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 480 TO BS 500, STRINGER 17R. REPAIRED WEB IAW EA.SDR SWAA2014060228568Web · corrodedWEB CORRODED BETWEEN BS 480 TO BS 500, STRINGER 17L. REPAIRED WEB IAW EO & EA.SDR SWAA2014053028518Angle · crackedAFT CARGO COMPARTMENT CLIP ANGLE CRACKED AT BS 947.5, STRINGER 25L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014053028517Web · crackedWEB CRACKED AT BS 927, STRINGER 25L. R & R WEB IAW SRM & DWG.SDR SWAA2014053028516Shear Tie · corrodedSHEAR TIE ANGLE CORRODED AT BS 887, STRINGER 25L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014052928454Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420, STRINGER 17R. REPAIRED WEB IAW EA.SDR SWAA2014052728335Angle · crackedANGLE CRACKED AT BS 947.5, BETWEEN STRINGER 25R TO STRINGER 24R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014052728329Fitting · crackedCLIP CRACKED AT BS 380, STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2014052328301Channel · crackedFORWARD CARGO COMPARTMENT FLOOR STRUCTURE SIDE PLATE CHANNEL CRACKED AT BS 500B+18, RBL 21.8. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014052328300Web · crackedWEB CRACKED BETWEEN BS 500B TO BS 500C, STRINGER 26R. R & R WEB IAW SRM & DWG.SDR SWAA2014052328298Web · corrodedWEB CORRODED BETWEEN BS 420 TO BS 440, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2014052328297Web · corrodedWEB CORRODED BETWEEN BS 360 TO BS 380, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2014052328296Web · corrodedWEB CORRODED BETWEEN BS 460 TO BS 480, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2014052328302Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014052228244Web · corrodedWEB CORRODED BETWEEN BS 380 TO BS 400, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2014052128210Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014051928133Stringer · crackedSTRINGER CRACKED AT BS 532, STRINGER 4R. REPAIRED STRINGER IAW SB.SDR SWAA2014060928842Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014060328647Structure · crackedLEFT SIDE CHORD CRACKED AT BS 178, WL 207. REPAIRED CHORD IAW EA.SDR SWAA2014060328646Structure · crackedRIGHT SIDE CHORD CRACKED AT BS 178, WL 20. REPAIRED CHORD IAW EA.SDR SWAA2014060328632Angle · crackedNR 1 ENG SUPPORT STRUT ACCESS 5757L ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014060328631Plate · crackedKEEL BEAM CORRUGATE PLATE CRACKED NEXT TO BS 727. R & R PLATE IAW SRM & DWG.SDR SWAA2014053028515Structure · crackedRIGHT WW LOWER CHORD CRACKED AT BS 679.67 AT LEVEL OF WL 172.18. R & R CHORD IAW SRM & DWG.SDR SWAA2014052728351Web · crackedRIGHT WING NOSE BEAM CHORD WEB CRACKED AT FSS 267 ABOVE NR 4 SLAT INBD MAIN TRACK. R & R CHORD IAW EA, SRM, & DWG.SDR SWAA2014051427992Fitting · brokenLEFT WING INBD GND SPOILER INBD ACTUATOR FITTING BROKEN AT LOWER ATTACH POINT. R & R FITTING IAW SRM.SDR SWAA2014051427991Hinge Fitting · brokenLEFT WING INBD GND SPOILER PANEL OTBD CTR HINGE FITTING BROKEN. R & R SPOILER IAW MM.SDR SWAA2014060628776Skin · canningFUSELAGE SKIN OIL CANNING BETWEEN BS 500D TO BS 520, BETWEEN STRINGER 6R TO STRINGER 7R UPPER LOBE. REPAIRED SKIN IAW EA & EO.SDR SWAA2014060528710Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 667, LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014053028535Rib · crackedRIGHT WING LOWER RIB CHORD CRACKED AT WBL 135.5, BETWEEN STRINGER 2 TO STRINGER 3. REPAIRED CHORD IAW EA.SDR SWAA2014052928460Skin · crackedFUSELAGE SKIN CRACKED AT UPPER CORNER OF WINDOW POST C - D RT SIDE BS 211.8+2, STRINGER 9R. REPAIRED SKIN IAW SRM.SDR SWAA2014052728357Skin · delaminatedRIGHT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2014052728332Stringer · corrodedSTRINGER CORRODED AT BS 1088+27, UPPER SIDE OF INLET AIR DUCT FLANGE TORQUE BOX RT SIDE. R & R STRINGER IAW SRM & DWG.SDR SWAA2014051327896Pressure Deck · crackedMLG WW PRESS DECK BEADED WEB CRACKED AT STATION 665, RBL 18. REPAIRED WEB IAW SRM.SDR SWAA2014051327895Skin · crackedFUSELAGE SKIN CRACKED AT STATION 480, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2014051327894Skin · crackedFUSELAGE SKIN CRACKED AT STATION 480, STRINGER 1. REPAIRED SKIN IAW SRM.SDR SWAA2014060628775Frame · crackedFRAME OTBD LT CHORD LOWER FWD FASTENER HOLE CRACKED AT BS 727, STRINGER 18L. REPAIRED CHORD IAW EA.SDR SWAA2014060628774Frame · crackedFRAME OTBD RT CHORD FWD LOWER FASTENER CRACKED AT BS 727, STRINGER 18R. REPAIRED CHORD IAW EA.SDR SWAA2014060428666Stiffener · corrodedPRESS WEB BULKHEAD CHANNEL STIFFENERS CORRODED AT BS 1016, STRINGER 23L TO STRINGER 23R. REPAIRED STIFFENER IAW EO & EA.SDR SWAA2014060428665Stiffener · corrodedAFT PRESS BULKHEAD WEB ANGLE STIFFENER CORRODED AT BS 1016, BETWEEN STRINGER 23L TO STRINGER 23R. REPAIRED STIFFENERS IAW EO & EA.SDR SWAA2014060428664Stiffener · corrodedBULKHEAD PRESS WEB STIFFENER CORRODED AT BS 1016, BETWEEN STRINGER 23L TO STRINGER 23R. REPAIRED STIFFENER IAW EO & EA.SDR SWAA2014060228590Skin · crackedLEFT WING LE SKIN CRACKED AT WBL 213. REPAIRED SKIN IAW EA.SDR SWAA2014053028557Flap · corrodedRIGHT WING NR 5 AFT FLAP CORRODED ON INBD AFT HOLE. REPAIRED AFT FLAP IAW CMM.SDR SWAA2014052728356Plate · crackedLEFT WING NR 1 SLAT PLATE CRACKED AT INBD MAIN TRACK. R & R PLATE IAW SRM & DWG.SDR SWAA2014051227867Slide · unsecureR2 DOOR SLIDE PARTIALLY FELL OUT OF CONTAINER. R & R SLIDE IAW MT.SDR SWAA2014060428681Bulkhead · corrodedAFT PRESS BULKHEAD PRESS CHORD CORRODED AT BS 1016, LBL 5. REPAIRED CHORD IAW SRM.SDR SWAA2014060428680Stiffener · corrodedAFT PRESS BULKHEAD ANGLE STIFFENER CORRODED AT BS 1016, BETWEEN RBL 6 TO LBL 10. REPAIRED STIFFENER IAW ER & EA.SDR SWAA2014060428679Stiffener · corrodedAFT PRESS BULKHEAD CHANNEL STIFFENER CORRODED AT BS 1017, RBL 1. REPAIRED STIFFENER IAW EA.SDR SWAA2014060428678Stiffener · corrodedAFT PRESS BULKHEAD CHANNEL STIFFENER CORRODED AT BS 1017, LBL 1. REPAIRED STIFFENER IAW ER & EA.SDR SWAA2014060428677Bulkhead · corrodedFORWARD SURFACE OF AFT PRESS BULKHEAD, PRESS WEB CORRODED AT BS 1017, BETWEEN LBL 4 TO RBL 4. REPAIRED WEB IAW ER & EA.SDR SWAA2014060328645Door Frame · crackedL1 DOOR FRAME OUTER CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED CHORD IAW EA.
Back to Boeing 737-3H4