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 SWAA2014120434664Skin · crackedSKIN CRACK BETWEEN BS 339 TO 381, BETWEEN STRINGER 1 TO 2L. REPAIRED SKIN IAW EA.SDR SWAA2014120234602Panel · delaminatedLEFT MAIN WW LOWER FUSELAGE COMPOSITE PANEL CUT OUT DELAMINATED. REPAIRED PANEL IAW AMM.SDR SWAA2014110533817Attach Fitting · crackedAFT CARGO FLOOR STRUCTURE INTERCOSTAL ATTACH CLIP CRACKED AT BS 787 STRINGER 27R. R & R CLIP IAW SRM & DWG.SDR SWAA2014110533762Intercostal · crackedINTERCOSTAL CRACKED AT BS 323 RBL 31. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014110333656Angle · crackedRIGHT WING AILERON BALANCE BAY INBD ANGLE CRACKED AT NR 2 HINGE. R & R ANGLE IAW SRM.SDR SWAA2014110333642Battery · dischargedL2 DOOR OVERHEAD EXIT SIGN INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2014110333623Cover · looseFORWARD ENTRY LOWER EXIT SIGN COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2014120334611Rib · crackedRIGHT WING RIB LOWER CHORD CRACKED AT WBL 135.5, STRINGER 2. REPAIRED CHORD IAW EA.SDR SWAA2014120234589Skin · crackedSKIN CRACKED BETWEEN BS 500A+3 TO 500A+7, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2014120134528Skin · crackedSKIN CRACKED BETWEEN BS 799 TO 802, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2014120434663Skin · crackedSKIN CRACKED BETWEEN BS 1009 TO 1011, STRINGER 20L. REPAIRED SKIN IAW SRM.SDR SWAA2014112134355Cusp Web · corrodedRIGHT CUSP WEB CORRODED BETWEEN BS 360 TO 380. R & R CUSP WEB IAW DWG.SDR SWAA2014111934312Pressure Deck · crackedMAIN WW HORIZONTAL PRESS DECK CRACKED AT BS 665, BETWEEN LBL 3 TO LBL 22. REPAIRED DECK IAW EA.SDR SWAA2014111834282Frame · crackedFRAME CRACKED AT BS 303, STRINGER 17R. R & R FRAME IAW SRM & DWG.SDR SWAA2014111134044Angle · crackedL1 DOOR CUT OUT ANGLE CRACKED AT BS 348.2 STRINGER 15L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014120434662Skin · crackedAFT GALLEY DOOR FWD OF LOWER HINGE SKIN CUT OUT CRACKED AT BS 951. REPAIRED SKIN IAW EA.SDR SWAA2014110333649Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360 STRINGER 8R. R & R CLIP IAW SRM & DWG.SDR SWAA2014110333646Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727 STRINGER 18A LT LOWER FWD FASTENER HOLE. R & R CHORD IAW EA.SDR SWAA2014103033556Panel · looseLEFT EMER LIGHTING PANEL LOOSE AT ROW 17. SECURED PANEL IAW SIP.SDR SWAA2014102933421Outflow Valve · faultyAIR TURN BACK CABIN ALT WARNING HORN & LIGHT CAME ON AT 29'000. R & R MAIN OUTFLOW VLV IAW AMM.SDR SWAA2014102833390Regulator · faultyAIR TURN BACK CABIN PRESS ALTITUDE WARNING HORN SOUNDED & PRESSURIZATION NEVER RECOVERED. R & R NR 1 ENG PNEU BLEED HIGH STAGE REGULATOR IAW MM.SDR SWAA2014120134527Bulkhead · crackedAFT PRESS BULKHEAD Y CHORD WEB CRACKED AT BS 1016, STRINGER 16L. REPAIRED WEB IAW EA.SDR SWAA2014110433661Regulator · faultyAIR TURN BACK DURING CLIMB NR 1 ENG BLEED 0 PSI. PRESS WOULD NOT RETURN. R & R BLEED AIR REGULATOR IAW MM.SDR SWAA2014103133580Panel · delaminatedNUMBER 6 SPOILER PANEL DELAMINATED. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2014103033554Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014102933456Fuse · blownLEFT CABIN EMER EXIT LIGHT INOPERATIVE BETWEEN ROW 1 - 3. R & R FUSE IAW AMM.SDR SWAA2014102833388Sign · unsecureL1 DOOR EXIT SIGN FELL OFF. R & R EXIT SIGN IAW MM.SDR SWAA2014111734210Structure · corrodedR1 CHORD CORRODED BETWEEN BS 292 TO 328. R & R CHORD IAW SRM.SDR SWAA2014111234095Flap · delaminatedLEFT WING TE INBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2014111134043Angle · corrodedR1 DOOR CUT OUT FWD FRAME ANGLE CORRODED AT STRINGER 17. R & R ANGLE IAW SRM & DWG.SDR SWAA2014103033555Strap · crackedFRAME STRAP CRACKED AT BS 348 STRINGER 16L. REPAIRED STRAP IAW SRM.SDR SWAA2014110633849Floor Support · crackedMAIN CABIN LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 666 RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014110533761Floor Support · crackedMAIN CABIN LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 666 RBL 24.8. REPAIRED CHORD IAW SRM.SDR SWAA2014103133597Stringer Clip · damagedFUSELAGE STRINGER CLIP DAMAGED AT STATION 727E STRINGER 5L. R & R CLIP IAW SRM.SDR SWAA2014103033553Flap · damagedRIGHT WING INBD MID FLAP TE DAMAGED. REPAIRED MID FLAP IAW SRM.SDR SWAA2014102933423Skin · corrodedLEFT WING UPPER SKIN CORRODED AT STATION 198 TE. REPAIRED SKIN IAW EA.SDR SWAA2014120834777Structure · crackedAFT CARGO DOOR AFT END OF CROSSBEAM E, OTBD T CHORD CRACKED. REPAIRED T CHORD IAW CCO.SDR SWAA2014120434661Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, RT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2014120434660Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, LT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2014112434420Skin · crackedNUMBER 5 SLAT LOWER LE SKIN CRACKED AT INBD AUXILIARY TRACK AREA. REPAIRED SLAT IAW SRM.SDR SWAA2014102933455Panel · crackedNUMBER 2 ENG PYLON PANEL 5869 UPPER AFT FASTENER HOLE CRACKED. REPAIRED PANEL IAW SRM.SDR SWAA2014102933439Light · inoperativeFLIGHT DECK EMER LIGHT, ABOVE OBSERVER SEAT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2014102733382Wedge · delaminatedRIGHT INBD TE MID FLAP WEDGE PANEL DELAMINATED TOP SURFACE. R & R WEDGE IAW MM.SDR SWAA2014111434179Skin · crackedSKIN CRACKED AT BS 400 STRINGER 14L AT LOWER ROW AT 3 O'CLOCK POSITION. REPAIRED SKIN IAW EA.SDR SWAA2014111434178Skin · crackedSKIN CRACKED AT BS 420 STRINGER 14L AT LOWER ROW AT THE 5 O'CLOCK POSITION. REPAIRED SKIN IAW EA.SDR SWAA2014111334130Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14L LOWER ROW BOTH HOLES AT 3 & 9 O'CLOCK POSITIONS. REPAIRED SKIN IAW EA.SDR SWAA2014111134036Skin · crackedSKIN CRACKED AT BS 500 STRINGER 14R AT 3 & 9 O' CLOCK POSITIONS. REPAIRED SKIN IAW EA.SDR SWAA2014111134035Skin · crackedSKIN CRACKED AT BS 380 STRINGER 14R AT THE 5 O' CLOCK POSITION. REPAIRED SKIN IAW EA.SDR SWAA2014102733376Lens · looseEMERGENCY BULLNOSE LIGHT LENS LOOSE AT 9 DEF. SECURED LENS IAW MM.SDR SWAA2014102933420Support Strap · crackedISOLATOR SUPPORT STRAP CRACKED AT BS 947 BETWEEN STRINGER 15R TO 17R. REPAIRED STRAP IAW DWG & SRM.
Back to Boeing 737-3H4