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 SWAA2014032726551Skin · crackedSKIN CRACKED AT BS 291.5+6, STRINGER 7R+2. REPAIRED SKIN IAW EA.SDR SWAA2014032626518Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, STRINGER 27L. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426475Spindle · delaminatedLEFT WING OTBD FLAP NR 2 CARRIAGE SPINDLE DELAMINATED. R & R SPINDLE IAW MT.SDR SWAA2014032426469Frame · corrodedAFT CARGO COMPARTMENT FRAME SHEAR TIE CORRODED AT BS 807, BETWEEN STRINGER 26L TO STRINGER 27L. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426468Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, BETWEEN STRINGER 26R TO STRINGER 27R. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426467Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, BETWEEN STRINGER 26L TO STRINGER 27L. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426466Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, BETWEEN STRINGER 27L TO STRINGER 27R. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426446Skin · crackedRIGHT BS 767+10 UPPER AFT WINDOW SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014032426465Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, STRINGER 27L. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426451Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 807, BETWEEN STRINGER 25L TO STRINGER 26L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014032426380Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 663.75+1.0, RBL 24.5+14.5. REPAIRED DECK IAW SRM.SDR SWAA2014032426361Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+1, LBL 24.5+6. REPAIRED WEB IAW EA.SDR SWAA2014032426360Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+0.5, BL 0.0+5. REPAIRED WEB IAW EA.SDR SWAA2014032426359Frame · crackedFRAME CRACKED AT BS 312, STRINGER 6L. REPAIRED FRAME IAW EA.SDR SWAA2014032426358Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 18R. REPAIRED DOME CAP WEB IAW EA.SDR SWAA2014032426357Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 23R. REPAIRED DOME CAP WEB IAW SRM.SDR SWAA2014032126302Skin · crackedFUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUT OUT BETWEEN STATION 945 & STATION 956, STRINGER 7R. REPAIRED SKIN IAW SRM.SDR SWAA2014032026266Web · corrodedAFT CARGO BAY SUB THRESHOLD WEB CORRODED. R & R WEB IAW SRM & DWG.SDR SWAA2014031926234Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 847, STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2014031826174Skin · crackedLT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014031726152Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348, STRINGER 16L. R & R ANGLE IAW SRM.SDR SWAA2014031726103Web · crackedWEB CRACKED AT BS 1016, BL 0. R & R WEB IAW SRM & DWG.SDR SWAA2014031726102Angle · crackedANGLE CHORD CRACKED AT BS 348, BETWEEN STRINGER 8L TO STRINGER 9L. R & R CHORD IAW SRM & DWG.SDR SWAA2014031726072Skin · crackedRT BS 787+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014031726146Skin · crackedRT BS 847+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB & TASK CARD.SDR SWAA2014031726145Skin · crackedRT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB & TC.SDR SWAA2014031726144Skin · crackedRT BS 787+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW TASK CARD.SDR SWAA2014031726135Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 927 TO BS 947, RBL 3. R & R INTERCOSTAL IAW SRM.SDR SWAA2014031426060Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT STATION 328, LBL 30. REPAIRED BEAM IAW SRM.SDR SWAA2014031426059Web · crackedFUSELAGE WEB CRACKED AT STATION 294.5 TO STATION 303.9, STRINGER 8L. REPAIRED WEB IAW SRM.SDR SWAA2014031426058Support Angle · crackedSUPPORT ANGLE CRACKED AT STATION 277 TO STATION 291.5, STRINGER 10 TO STRINGER 11R. R & R ANGLE IAW SRM.SDR SWAA2014031426057Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 294.5, STRINGER 11L. R & R CLIP IAW SRM.SDR SWAA2014031426040Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 817, LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426039Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 787, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426038Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 787, LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426037Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 817, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426036Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 787, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031326024Floorbeam · corrodedFLOORBEAM CORRODED AT UPPER FACE, BS 328, RBL 24.5. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014031326023Flap · debondedRT WING INBD FORE FLAP DIS BONDED AT INBD EDGE. REPAIRED FLAP IAW SRM.SDR SWAA2014031326011Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 827+10, LOWER FWD CORNER OF WINDOW CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014031326010Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 887+10, UPPER AFT CORNER OF WINDOW CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014031225990Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 986 TO BS 996, STRINGER 21L. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014031225976Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2 AT STRINGER 15L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014031225975Skin · delaminatedRIGHT WING FORE FLAP SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014031225974Tie Clip · crackedTIE CLIP CRACKED AT BS 348.20, STRINGER 15L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014031125958Forging · crackedLT BS 727A+10 WINDOW FORGING UPPER AFT CORNER CUTOUT CRACKED. R & R FORGING IAW DRAWING.SDR SWAA2014031125957Skin · crackedLT BS 887+10 LOWER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014031125956Skin · crackedLT BS 867+10 LOWER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014031025892Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 665, LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014031025889Strap · crackedSTRAP CRACKED AT BS 348.20, STRINGER 16L. R & R STRAP IAW SRM & DRAWING.
Back to Boeing 737-3H4