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 SWAA2014041427061Skin · crackedSKIN CRACKED AT THE TWO HOLES AT THE 2ND STOP FITTING FROM BOTTOM OF BS 348.2, STRINGER 15L. REPAIRED SKIN IAW EA.SDR SWAA2014041427060Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 972 TO BS 973, STRINGER 4R. REPAIRED SKIN IAW SRM.SDR SWAA2014041427059Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 972 TO BS 973, STRINGER 4R. REPAIRED SKIN IAW SRM.SDR SWAA2014041127029Light · inoperativeOVERHEAD INTERIOR EMERGENCY LIGHTS INOPERATIVE. RELAMPED LIGHTS IAW MM.SDR SWAA2014040926963Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, LBL 46. R & R WEB IAW SRM & DWG.SDR SWAA2014050227614Skin · crackedFUSELAGE SKIN CRACKED AT BS 344.5, STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014050227613Skin · crackedFUSELAGE SKIN CRACKED AT BS 340, STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014043027537Skin · crackedFUSELAGE EXTERNAL SKIN FWD CARGO DOOR CUT OUT CRACKED AT BS 440+3, STRINGER 24R. REPAIRED SKIN IAW SRM.SDR SWAA2014043027536Skin · crackedFUSELAGE EXTERNAL SKIN FWD CARGO DOOR CUT OUT CRACKED AT BS 440+6, STRINGER 18R. REPAIRED SKIN IAW SRM.SDR SWAA2014042827390Channel · crackedCHANNEL CRACKED BETWEEN BS 663 TO BS 670, RBL 24.5+12. R & R CHANNEL IAW EO & EA.SDR SWAA2014042427353Support Channel · corrodedFRAME SUPPORT CHANNEL CORRODED AT BS 787, BETWEEN STRINGER 19L TO STRINGER 25L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014042427349Angle · crackedANGLE CRACKED AT BS 727, BETWEEN LBL 45 TO LBL 52. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042427348Frame · corrodedFRAME CORRODED AT BS 360 & BETWEEN STRINGER 28L TO STRINGER 28R. REPAIRED FRAME IAW SRM.SDR SWAA2014042227272Cover · crackedRIGHT EE COMPARTMENT COVER ASSEMBLY CRACKED. R & R COVER ASSEMBLY IAW SRM & DWG.SDR SWAA2014041627171Strap · crackedSTRAP CRACKED AT BS 312, RBL 45. R & R STRAP IAW SRM & DWG.SDR SWAA2014041627170Strap · crackedSTRAP CRACKED AT BS 328, RBL 31. R & R STRAP IAW SRM & DWG.SDR SWAA2014041427117Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 15L. REPAIRED FRAME IAW EA.SDR SWAA2014041427058Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT REAR SPAR BETWEEN STAB STATION 92.7 & 101.9. REPAIRED SKIN IAW EA.SDR SWAA2014041427057Angle · crackedLEFT WING NO STEP ANGLE CRACKED AT THE AFT END. R & R ANGLE IAW DWG & SRM.SDR SWAA2014040826923Skin · crackedLEFT WING NR 2 SLAT CRACKED ON LOWER SKIN. REPAIRED SKIN IAW SRM.SDR SWAA2014040726871Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, RBL 31.6. R & R WEB IAW SRM & DWG.SDR SWAA2014040726866Cover · unsecureL1 DOOR EMERGENCY EXIT SIGN COVER FELL OFF. R & R COVER IAW SIP.SDR SWAA2014040426828Controller · faultyDECLARED EMERGENCY. CABIN PRESS CONTROL WARN HORN SOUNDED & LOSS OF PRESS. R & R NR 1 CABIN PRESS CONTROLLER & OUTFLOW VLV IAW MM.SDR SWAA2014042927511Angle · crackedANGLE CRACKED LOCATED INTERNAL AREA ACCESS PANEL 5757L STRUT TORQUE BOX ENG NR 1. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042827443Angle · crackedANGLE CRACKED ON INTERNAL AREA ACCESS PANEL 5743L AFT STRUT FAIRING ENG NR 1. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042827389Frame · crackedFRAME CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW EA & DWG.SDR SWAA2014042827388Frame · crackedFRAME CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2014042227271Angle · crackedLEFT EE COMPARTMENT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042227275Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STRINGER 20L TO STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014041727200Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014041727199Web · crackedRIGHT SIDE NLG WHEEL WEB CRACKED AT BS 251.6+4.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014041427107Strap · damagedRIGHT LOWER AUXILIARY STRAP DAMAGED AT BS 727. R & R STRAP IAW EA.SDR SWAA2014041427076Angle · crackedCLIP ANGLE CRACKED AT BS 320, BETWEEN STRINGER 20L TO STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014040726852Fitting · crackedCLIP CRACKED AT BS 336, BETWEEN STRINGER 20L TO STRINGER 21L. R & R CLIP IAW SRM & DWG.SDR SWAA2014040726851Fitting · crackedCLIP CRACKED AT BS 328, BETWEEN STRINGER 20L TO STRINGER 21L. R & R CLIP IAW SRM & DWG.SDR SWAA2014040326787Bulb · inoperativeR2 DOOR EMERGENCY EXIT LIGHT BULB INOPERATIVE. REPLACED BULB IAW MM.SDR SWAA2014050227594Crossbeam · crackedAFT CARGO DOOR CROSSBEAM CHORD CRACKED AT FWD END. REPAIRED CHORD IAW EA.SDR SWAA2014050127584Frame · crackedFUSELAGE FRAME OTBD CHORD CRACKED AT STATION 727, STRINGER 18A, RT SIDE. REPAIRED FRAME CHORD IAW EA.SDR SWAA2014050127583Frame · crackedFUSELAGE FRAME OTBD CHORD CRACKED AT STATION 727, STRINGER 18A, LT SIDE. REPAIRED FRAME CHORD IAW EA.SDR SWAA2014050127582Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 348.2, STRINGER 16L. R & R CLIP IAW SRM & EA.SDR SWAA2014043027535Skin · crackedSKIN CRACKED AT BS 794+3, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2014042927510Door · crackedAFT ENTRY DOOR LOWER HINGE CUT OUT OF THE FWD FRAME CRACKED. R & R DOOR IAW SRM.SDR SWAA2014042827442Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664, LBL 45.5 - 5. REPAIRED WEB IAW EA.SDR SWAA2014042827437Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED CHORD IAW EA.SDR SWAA2014042827436Bulkhead · canningAFT PRESS BULKHEAD DOME WEB OIL CANNING AT BS 1016, RBL 60. REPAIRED DOME WEB IAW EO & EA.SDR SWAA2014042827387Stiffener · crackedZ STIFFENER CRACKED AT BS 1016, STRINGER 3L. REPAIRED Z STIFFENER IAW EO & EA.SDR SWAA2014042827403Structure · crackedLEFT WING UPPER CHORD CRACKED AT LEVEL S 2 & WBL 114 FUEL TANK. REPAIRED CHORD IAW EO & EA.SDR SWAA2014042427347Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014040326799Cover · missingFORWARD AREA EMERGENCY EXIT SIGN COVER MISSING. INSTALLED COVER IAW MM.SDR SWAA2014040226763Attach Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE LOWER FWD ATTACH BRACKET CRACKED. R & R BRACKET IAW AMM.
Back to Boeing 737-3H4