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 SWAA2014012024217Skin · crackedRT BS 400+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 2 TO HOLES 7. REPAIRED SKIN IAW EA.SDR SWAA2014012024212Skin · crackedLT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW EA.SDR SWAA2014011724193Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED BETWEEN BS 705 TO BS 715 LBL 24.8. REPAIRED WEB IAW SWA EA.SDR SWAA2014011624164Skin · crackedLT BS 500+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 2 TO 7. REPAIRED SKIN IAW EA.SDR SWAA2014011624163Skin · crackedLT BS 400+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE 5. REPAIRED SKIN IAW EA.SDR SWAA2014011624162Skin · crackedLT BS 380+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 4 TO 6. REPAIRED SKIN IAW EA.SDR SWAA2014011624161Skin · crackedRT BS 380+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 1 TO 9. REPAIRED SKIN IAW EA.SDR SWAA2014011624160Skin · crackedRT BS 380+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 3 TO 7. REPAIRED SKIN IAW SWA EA.SDR SWAA2014011624132Door Frame · crackedAFT CARGO COMPARTMENT DOOR FRAME LOWER FWD CORNER CRACKED. R & R FRAME IAW SRM & DRAWING.SDR SWAA2014011424108Skin · crackedRT BS 807 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 4. REPAIRED SKIN IAW EA.SDR SWAA2014011324068Skin · crackedLT BS 520+10 LOWER AFT WINDOW SKIN CUT OUT CRACKED AT HOLE 4. REPAIRED SKIN IAW SWA EA.SDR SWAA2014011324067Skin · crackedRT BS 360+10 LOWER AFT WINDOW SKIN CUT OUT CRACKED AT HOLES 2 - 7. REPAIRED SKIN IAW EA.SDR SWAA2014010923928Skin · crackedRT BS 440+10 UPPER FWD SKIN CUTOUT CRACKED AT HOLE 3 & 7. REPAIRED SKIN IAW EA.SDR SWAA2014010923924Support Angle · crackedCTR WING BOX SUPPORT ANGLE CRACKED AT BS 727 LBL 45.5. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010823879Skin · crackedLT BS 480+10 UPPER FWD SKIN CUTOUT CRACKED AT HOLES 3, 5 & 8. REPAIRED SKIN IAW SB.SDR SWAA2014010823876Skin · crackedLT BS 500A+10 LOWER AFT SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2014010823875Skin · crackedLT BS 500B+10 UPPER FWD SKIN CUTOUT CRACKED AT HOLES 2, 4, 5 & 8. REPAIRED SKIN IAW SB.SDR SWAA2014010823874Skin · crackedLT BS 500A+10 UPPER FWD SKIN CUTOUT CRACKED AT HOLES 2, 4, 5, 6 & 8. REPAIRED SKIN IAW SB.SDR SWAA2014010723842Skin · crackedLT BS 847+10 UPPER AFT SKIN CUTOUT CRACKED INDICATION AT HOLE 2. REPAIRED SKIN IAW SB.SDR SWAA2014010723822Skin · crackedLT BS 807+10 UPPER AFT SKIN CUTOUT CRACKED INDICATION AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2014010723806Skin · crackedRT BS 767+10 LOWER FWD SKIN CUTOUT CRACKED INDICATION AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2014010723790Skin · nickedSKIN NICKED AT BS 178+8.5" LBL 4. REPAIRED SKIN IAW EA.SDR SWAA2014012324442Pressure Deck · crackedMAIN WW PRESS DECK CRACKED BETWEEN BS 664 TO BS 675 BETWEEN LBL 24.5 TO LBL 45.50. REPAIRED DECK IAW EA.SDR SWAA2014010923933Angle · crackedRT DORSAL FIN CLOSURE PANEL RETAINER ANGLE CRACKED. R & R ANGLE IAW BAC DRAWING & SRM.SDR SWAA2014010223707Plate · crackedPLATE CRACKED BETWEEN BS 1137 TO BS 1156 STRINGER 9L. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013122623620Lens · looseRT EMERGENCY EXIT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2013122623640Light · inoperativeLT AFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED EMERGENCY EXIT LIGHT IAW MM.SDR SWAA2014012024283Light · brokenAFT SIDE OF FWD LAVATORY EMERGENCY EXIT LIGHT BROKEN. R & R LIGHT IAW MM.SDR SWAA2014010723832Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360 STRINGER 4L. REPAIRED SPLICE IAW EA.SDR SWAA2014010223727Tail Cone · delaminatedAPU TAIL CONE DELAMINATED. R & R TAIL CONE IAW AMM.SDR SWAA2013122623634Structure · crackedFUSELAGE CHORD CRACKED AT STATION 727 RT SIDE 5 O'CLOCK TO 9 O'CLOCK POSITION. REPAIRED CHORD IAW SWA EA.SDR SWAA2013122623633Structure · crackedFUSELAGE CHORD CRACKED AT STATION 727, BETWEEN STRINGER 18L & STRINGER 27L. REPAIRED CHORD IAW SWA EA.SDR SWAA2013122323600Slide · looseL1 DOOR SLIDE LOOSE. REINSTALLED L1 DOOR SLIDE IAW MT.SDR SWAA2013122323597Wedge · crackedRT INBD MID FLAP TE WEDGE CRACKED ON BOTTOM SIDE. R & R WEDGE ASSEMBLY IAW MM.SDR SWAA2013122023574Stiffener · crackedRT WING AILERON INBD STIFFENER CRACKED. R & R STIFFENER IAW SRM.SDR SWAA2013122023573Door Frame · crackedR1 DOOR FRAME CRACKED AT LOWER AFT CORNER. R & R R1 DOOR IAW MM.SDR SWAA2013122323595Slide · out of positionL2 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013122323590Priority Valve · faultyDURING GEAR RETRACTION NLG RED LIGHT REMAINED ILLUMINATED WITH GEAR HANDLE UP. NLG EXTENDED WITH GEAR HANDLE IN NEUTRAL POSITION. R & R NLG PRIORITY VLV MODULAR UNIT & LOCK ACTUATOR IAW MM.SDR SWAA2013121923534Light · inoperativeLT BULLNOSE EMERGENCY EXIT LIGHT BULB INOPERATIVE AT ROW 21. R & R BULB IAW AMM.SDR SWAA2014010223714Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360 STRINGER 8R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013122723658Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 727D, STRINGER 8R. R & R STRINGER CLIP IAW SRM & BAC DRAWING.SDR SWAA2013122323596Flap · damagedRT INBD AFT FLAP DAMAGE ON TRAIL EDGE. R & R AFT FLAP IAW MM.SDR SWAA2013121823501Light · inoperativeRT EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2013121823482Lens · looseRT EMERGENCY EXIT LENS COVER LOOSE. SECURED COVER IAW AMM.SDR SWAA2013121923538Channel · crackedSPLICE CHANNEL CRACKED AT STATION 908, STRINGER 4L. R & R CHANNEL IAW DRAWING & SRM.SDR SWAA2013121823488Skin · crackedSKIN CRACKED AT STATION 747+8, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2013121823487Skin · crackedSKIN CRACKED AT STATION 727D +11, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2013121723433Fuse · blownL1 DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. R & R FUSE IAW MM.SDR SWAA2013121723432Fuse · blownRT BULLNOSE EMERGENCY LIGHTS INOPERATIVE AT ROW 23. R & R FUSE IAW MM.SDR SWAA2013122723661Frame · crackedFUSELAGE FRAME CRACKED AT STATION 500C, BETWEEN STRINGER 19R & STRINGER 22R. REPAIRED FRAME IAW SRM.
Back to Boeing 737-3H4