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 SWAA2014032426363Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 663.75, LBL 6.15. R & R STIFFENER IAW ACO.SDR SWAA2014032426362Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 663.75, RBL 6.15. R & R STIFFENER IAW ACO.SDR SWAA2014031726155Structure · crackedRIGHT WING NR 8 CARRIAGE A FRAME CRACKED. R & R A FRAME IAW AMM.SDR SWAA2014030725854Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500A, STRINGER 2R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014030525785Bracket · damagedL2 DOOR EMERGENCY EVAC SLIDE FLOOR BRACKETS ASSEMBLY HARDWARE DAMAGED. R & R BRACKET ASSEMBLY IAW AMM.SDR SWAA2014030525784Bracket · damagedR2 DOOR EMERGENCY EVAC SLIDE FLOOR BRACKET ASSEMBLY HARDWARE DAMAGED. R & R BRACKET ASSEMBLY IAW AMM.SDR SWAA2014030425756Pump · faultyDIVERSION A HYD SYS FLUID QUANTITY WENT TO ZERO. R & R LT ENG HYD PUMP, PRESS RETURN & CASE DRAIN FILTERS IAW MM.SDR SWAA2014032426488Frame · crackedAFT CARGO COMPARTMENT FRAME SHEAR TIE CRACKED AT BS 747, BETWEEN STRINGER 25L TO STRINGER 26L. R & R FRAME IAW SRM.SDR SWAA2014032426419Tie Clip · crackedTIE CLIP CRACKED AT BS 727D, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014032426418Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2014031926229Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014031826189Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014031426034Power Supply · inoperativeFWD ENTRY EMERGENCY EXIT LIGHT INOPERATIVE. R & R POWER SUPPLY M1675 IAW MM.SDR SWAA2014031025904Angle · corrodedSHEAR TIE LOWER ANGLE CORRODED AT BS 500B, BETWEEN STRINGER 27R TO STRINGER 28R. R & R ANGLE IAW SRM.SDR SWAA2014031025903Angle · corrodedSHEAR TIE LOWER ANGLE CORRODED AT BS 500B, BETWEEN STRINGER 28L TO STRINGER 28R. R & R ANGLE IAW SRM.SDR SWAA2014031025902Angle · corrodedSHEAR TIE LOWER ANGLE CORRODED AT BS 500B, BETWEEN STRINGER 25L TO STRINGER 26L. REPAIRED ANGLE IAW SRM.SDR SWAA2014030425736Actuator · leakingLT WING NR 2 FLIGHT SPOILER LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2014030325718Cover · looseFWD EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2014032426417Plate · crackedRT HORIZONTAL STABILIZER ACCESS PANEL 9224R PLATE CRACKED. R & R PLATE IAW SRM & DWG.SDR SWAA2014032426416Angle · crackedFORWARD CARGO COMPARTMENT CLIP ANGLE CRACKED AT BS 500D & STRINGER 19R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426415Web · crackedVERTICAL STABILIZER TE WEB CRACKED AT FIN STATION 81.80. R & R WEB IAW SRM & DWG.SDR SWAA2014032126310Fitting · crackedINTERCOSTAL CLIP CRACKED AT STATION 947, STRINGER 25R. R & R CLIP IAW SRM.SDR SWAA2014031726118Access Panel · crackedRIGHT HORIZONTAL STABILIZER PLATE ACCESS PANEL 9226R CRACKED. R & R PANEL IAW SRM.SDR SWAA2014031726104Attach Angle · crackedRT HORIZONTAL STABILIZER CTR SECTION LOWER CHORD ATTACH ANGLE CRACKED AT BS 1121. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031426062Angle · crackedFWD CARGO ANGLE CRACKED AT STATION 380, STRINGER 26R. R & R ANGLE IAW SRM.SDR SWAA2014031426061Angle · crackedFWD CARGO ANGLE CRACKED AT STATION 500C, STRINGER 26R. R & R ANGLE IAW SRM.SDR SWAA2014031125952Tab · crackedLT WING AILERON TAB OTBD EDGE CRACKED. REPAIRED TAB IAW SRM.SDR SWAA2014031025893Channel · crackedFLOOR STRUCTURE FWD CARGO COMPARTMENT CHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. R & R CHANNEL IAW SRM.SDR SWAA2014030525764Support Angle · corrodedBULKHEAD LOWER SUPPORT ANGLE CORRODED AT BS 947, BETWEEN STRINGER 25L TO STRINGER 25R. R & R ANGLE IAW SRM.SDR SWAA2014030425754Actuator · faultyAIR TURN BACK RED LT GEAR LIGHT ILLUMINATED WITH GEAR HANDLE UP. WHEN HANDLE MOVED TO OFF GREEN LT GEAR LIGHT ILLUMINATES WITH ADDITIONAL WIND NOISE. R & R LT MLG RETRACT ACTUATOR IAW MM.SDR SWAA2014030325711Cover · brokenRT SIDE AFT GALLEY EMERGENCY EXIT LIGHT COVER BROKEN. R & R COVER IAW AMM.SDR SWAA2014030325688Battery Pack · dischargedLT EMERGENCY EXIT DOOR EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014030325687Lens · brokenL1 DOOR EMERGENCY EXIT LENS BROKEN. R & R LENS IAW SIP.SDR SWAA2014040126726Cusp Web · corrodedRIGHT CUSP WEB HAS CORRODED BETWEEN BS 380 - 400. REPAIRED CUSP WEB IAW SRM.SDR SWAA2014033126651Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 21L TO STRINGER 22L. REPAIRED FRAME IAW EA.SDR SWAA2014032826608Angle · corrodedFUSELAGE AFT BULKHEAD ANGLE CORRODED AT STATION 1016, RBL 2, WL 197. REPAIRED ANGLE IAW EA.SDR SWAA2014032426445Support Angle · crackedLEFT WING LOWER TE PANEL AFT SUPPORT ANGLE CRACKED. R & R ANGLE IAW EA.SDR SWAA2014032426463Structure · crackedLEFT CHORD CRACKED AT BS 727, STRINGER 18A. R & R CHORD IAW EA.SDR SWAA2014032426486Support Angle · crackedNR 1 ENG AFT STRUT ACCESS PANEL 5752L SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031726153Support Angle · crackedLEFT WING RSS 546 WIPER WEB SUPPORT ANGLE CRACKED AT INBD SIDE OF AILERON HINGE. R & R ANGLE IAW SRM.SDR SWAA2014031426043Skin · crackedFUSELAGE SKIN CRACKED AT STATION 365.5 TO STATION 368.5, STRINGER 16R. REPAIRED SKIN IAW SWA EA.SDR SWAA2014030525774Angle · crackedFLOOR STRUCTURE AREA FWD CABIN ANGLE CRACKED AT BS 328, RBL 34.5. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014030325710Lens · looseRT EMERGENCY EXIT LENS LOOSE. R & R LENS IAW MM.SDR SWAA2014030325693Fitting · corrodedFRAME FITTING CORRODED AT BS 1016, STRINGER 24R. R & R FITTING IAW SRM.SDR SWAA2014040726875Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 365.5 TO BS 368.5, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014033126650Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+1, LBL 24.5+15. REPAIRED WEB IAW EA.SDR SWAA2014033126649Pressure Panel · crackedVERTICAL PRESS WEB CRACKED AT BS 663, RBL 38. REPAIRED WEB IAW EA.SDR SWAA2014032826602Frame · crackedFUSELAGE FRAME CHORD CRACKED AT RT STATION 727, STRINGER 18A. REPAIRED CHORD IAW EA.SDR SWAA2014032826601Frame · crackedFUSELAGE FRAME CHORD CRACKED AT LT STATION 727, STRINGER 18A. REPAIRED CHORD IAW EA.SDR SWAA2014032726552Skin · crackedSKIN CRACKED AT BS 330, STRINGER 8R. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4