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 SWAA2015113046508Stringer Clip · crackedMAIN CABIN STRINGER CLIP CRACKED AT BS 500A, STRINGER 16L. R & R CLIP IAW DWG.SDR SWAA2015113046507Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500, STRINGER 16L. R & R CLIP IAW DWG & SRM.SDR SWAA2015113046506Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 480, STRINGER 16L. R & R CLIP IAW DWG & SRM.SDR SWAA2015112446402Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015112346289Lens · brokenFORWARD EMER EXIT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2015112346285Skin · crackedLEFT HORIZONTAL STABILIZER LOWER SURFACE, INSPAR SKIN CRACKED, BETWEEN FASTENERS AT REPAIR SPAR STABILIZER STATION 89. REPAIRED SKIN IAW EA.SDR SWAA2016040150510Threshold · crackedAFT CARGO COMPARTMENT CUT OUT AFT CORNER THRESHOLD CRACKED IN RADIUS. R & R THRESHOLD IAW MM.SDR SWAA2016011948084Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8, INBD OF SEAT TRACK. REPAIRED CHORD IAW EA.SDR SWAA2016011548034Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED AT RSS 224. REPAIRED CHORD IAW EA.SDR SWAA2016011548011Spar · crackedRIGHT WING AFT SPAR, UPPER CHORD CRACKED AT RSS 224. REPAIRED CHORD IAW EA.SDR SWAA2016010747772Flap Track · corrodedRIGHT WING NR 6 FLAP TRACK AFT ATTACH POINT CORRODED, AT AFT OTBD WING TO TRACK MATING SURFACE. R & R TRACK IAW SRM.SDR SWAA2016010647677Floor Support · corrodedAFT CARGO BAY TIE DOWN FLOOR SUPPORT CORRODED AT BS 945, RBL 13. R & R SUPPORT IAW SRM.SDR SWAA2015122347374Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 847, STRINGER 27R - 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015122347373Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 927, STRINGER 26L - 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015121647186Intercostal · corrodedINTERCOSTAL CORRODED, BETWEEN BS 727A - 727B, BETWEEN STRINGER 25L - 26L. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015121647185Angle · corrodedAFT CARGO COMPARTMENT, SIDEWALL SUPPORT AROUND FASTENER HOLES, CORRODED AT BS 727D, BETWEEN STRINGER 25R - 27R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015121547145Intercostal · corrodedINTERCOSTAL CORRODED, BETWEEN BS 727A - 727B, BETWEEN STRINGER 27R TO 26R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015121146985Light · inoperativeAFT LAVATORY EMER EXIT SIGN BULB INOPERATIVE. R & R SIGN IAW AMM.SDR SWAA2015120746754Support · corrodedAFT CARGO COMPARTMENT, FLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 727D - 727E, BETWEEN STRINGER 26R - 27R. R & R SUPPORT IAW SRM.SDR SWAA2015120746753Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 767 - 787, BETWEEN STRINGER 26L - 27R. R & R SUPPORT IAW SRM.SDR SWAA2015120746752Intercostal · corrodedINTERCOSTAL CORRODED, BETWEEN BS 847 - 867, STRINGER 27R. R & R INTERCOSTAL IAW SRM.SDR SWAA2015120346671Bracket · crackedAFT CARGO SUPPORT ANGLE BRACKET CRACKED AT BS 807, RBL 8.1. R & R BRACKET IAW SRM.SDR SWAA2015112346246Lens · looseRIGHT EMER LIGHT LENS LOOSE AT ROW 12. SECURED LENS IAW MM.SDR SWAA2016011147826Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD CRACKED AT RSS 222. REPAIRED CHORD IAW EA.SDR SWAA2015121747248Skin · crackedFUSELAGE SKIN CRACKED AROUND THE VHF3 ANTENNA. REPAIRED SKIN IAW EA & DWG.SDR SWAA2015121146961Web · corrodedFORWARD CARGO DOOR THRESHOLD SILL WEB CORRODED. R & R WEB IAW SRM.SDR SWAA2015120746751Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 500C - 500D, BETWEEN STRINGER 26R - 25R. R & R SUPPORT IAW SRM.SDR SWAA2015120246626Intercostal · crackedINTERCOSTAL CRACKED, BETWEEN BS 867 - 887, STRINGER 25R. R & R INTERCOSTAL IAW SRM.SDR SWAA2015112346287Skin · crackedSKIN CRACKED AT BS 400+17, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2015112346286Skin · crackedSKIN CRACKED AT BS 500D+4, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015111946224Slat · delaminatedRIGHT WING NR 5 SLAT DELAMINATED AT 66" FROM INBD SIDE. R & R NR 5 SLAT IAW MM.SDR SWAA2015111946223Slat · delaminatedLEFT WING NR 3 SLAT TE DELAMINATED AT INBD END. R & R NR 3 SLAT IAW MM.SDR SWAA2015111946222Slat · delaminatedLEFT WING NR 2 SLAT TE INBD END DELAMINATED. R & R NR 2 SLAT IAW MM.SDR SWAA2015111946236Glowstrip · delaminatedFORWARD ENTRYWAY PHOTO LUMINESCENT STRIP DELAMINATED. R & R STRIP IAW AMM.SDR SWAA2015111946235Light · damagedRIGHT EMER PATH LIGHTNING DAMAGED AT ROW 4. R & R EEPLS IAW AMM.SDR SWAA2015111946234Strap · brokenFORWARD FLASH LIGHT SECURITY STRAPS BROKEN. R & R STRAP IAW AMM.SDR SWAA2015120246617Plate · crackedLEFT WING WIGGLE PLATE ATTACHED TO LOWER WING SKIN TE AT APPROX RSS 248 CRACKED. R & R WIGGLE PLATE IAW SRM.SDR SWAA2015112446409Skin · crackedFORWARD CARGO DOOR, LOWER FWD CORNER CUT OUT CRACKED, BELOW STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2015112446405Light · crackedG1 GALLEY, LOWER OTBD EMER EXIT INDICATOR LIGHT CRACKED. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015112346317Skin · crackedFORWARD LOWER CORNER OF FWD PIT DOOR CUT OUT, CRACKED AT BS 440, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2015112346259Battery Pack · faultyAFT OVERHEAD & RT DOOR EMER LIGHT FAULTY. R & R BATTERY PACK IAW AMM.SDR SWAA2015111846200Spoiler · delaminatedRIGHT WING NR 9 FLIGHT SPOILER DELAMINATED. R & R NR 9 FLIGHT SPOILER IAW AMM.SDR SWAA2015111846140Light · inoperativeLEFT EMER LIGHT INOPERATIVE AT ROW 6. R & R BULB IAW AMM.SDR SWAA2015111846134Light · inoperativeRIGHT EMER LIGHT INOPERATIVE AT ROW 19. R & R BULB IAW AMM.SDR SWAA2016010647701Spar · crackedLEFT WING REAR SPAR UPPER CHORD, CRACKED AT UPPER FASTENER HOLE, LOCATED RSS 222. REPAIRED CHORD IAW EA.SDR SWAA2016010647700Spar · crackedLEFT WING REAR SPAR WEB, CRACKED AT UPPER FASTENER HOLE, LOCATED RSS 223. REPAIRED WEB IAW EA.SDR SWAA2016010647699Spar · crackedLEFT WING REAR SPAR UPPER CHORD, CRACKED AT UPPER FASTENER HOLE, LOCATED RSS 223. REPAIRED CHORD IAW EA.SDR SWAA2016010647690Spar · crackedRIGHT WING REAR SPAR UPPER CHORD WEB CRACKED AT THE UPPER FASTENER HOLE LOCATED RSS 223. REPAIRED WEB IAW EA.SDR SWAA2016010647689Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT UPPER FASTENER HOLE, LOCATED RSS 223. REPAIRED CHORD IAW EA.SDR SWAA2015121647184Cover · missingLEFT EMER EXIT AISLE LIGHT COVER MISSING AT ROW 10. INSTALLED COVER IAW AMM.
Back to Boeing 737-3H4