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 SWAA2015112446397Frame · corrodedFRAME CORRODED AT BS 967, BETWEEN STRINGER 27R - 27L. R & R FRAME IAW SRM & DWG.SDR SWAA2015112446396Bear Strap · corrodedAFT LAVATORY SERVICE PAN BEAR STRAP CORRODED AT BS 1006, BETWEEN STRINGER 27R - 27L. R & R BEAR STRAP IAW SRM & DWG.SDR SWAA2015112346244Skin · crackedLEFT WING NR 2 SLAT LOWER SURFACE, CRACKED OTBD OF INBD END, AT AFT ROW OF FASTENERS. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2015111846184Skin · crackedLEFT WING 1 SLAT CRACKED ON LOWER SURFACE FROM INBD END AT AFT ROW OF FASTENERS. REPAIRED 1 SLAT IAW SRM.SDR SWAA2015111846183Support · crackedAFT CARGO COMPARTMENT, FWD BULKHEAD SIDEWALL SUPPORT ATTACH FLANGE CRACKED AT BS 727+2, RBL 7. R & R FLANGE IAW SRM.SDR SWAA2015111846180Support Angle · crackedAFT CARGO COMPARTMENT ATTACH FLOOR TO SIDEWALL SUPPORT ANGLE CRACKED AT BS 947.5, STRINGER 25L. R & R ANGLE IAW SRM.SDR SWAA2015111846179Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STRINGER 21L. R & R CLIP IAW SRM.SDR SWAA2015111846178Support · corrodedAFT CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 847 - 867, LBL 22. R & R SUPPORT IAW SRM.SDR SWAA2015111846177Shear Tie · corrodedSHEAR TIE CORRODED AT BS 847, STRINGER 21L. R & R SHEAR TIE IAW SRM.SDR SWAA2015111846176Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 769, STRINGER 18R. R & R CLIP IAW SRM.SDR SWAA2015111846185Skin · crackedLEFT WING NR 2 SLAT CRACKED ON LOWER SURFACE, OTBD OF INBD END AT AFT ROW OF FASTENERS. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2015111646090Attach Fitting · crackedINTERCOSTAL ATTACH CLIP CRACKED AT BS 360, STRINGER 9L. R & R CLIP IAW SRM.SDR SWAA2015111646089Stringer Clip · corrodedAFT CARGO COMPARTMENT STRINGER CLIP CORRODED AT BS 727B, STRINGER 25L. R & R CLIP IAW SRM & DWG.SDR SWAA2015111646078Bulkhead · damagedAFT PRESS BULKHEAD CREASED AT BS 1016+4, BETWEEN RBL 1 TO LBL 1. REPAIRED BULKHEAD IAW EA.SDR SWAA2015111246014Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 25, LOWER ROW OF FASTENERS. REPAIRED WEB IAW EA.SDR SWAA2015111246010Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 5L. R & R CLIP IAW SRM.SDR SWAA2015111246009Stringer Clip · crackedAFT CARGO COMPARTMENT, STRINGER CLIP CRACKED AT BS 727A, STRINGER 25R. R & R CLIP IAW SRM & DWG.SDR SWAA2015110645816Angle · crackedLEFT WING TE SEAL, BULKHEAD AT WBL 209, LOWER ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015110645815Angle · crackedRIGHT WING TE SEAL, BULKHEAD LOWER ANGLE, CRACKED AT WBL 209. R & R ANGLE IAW SRM.SDR SWAA2015110445731Wire · brokenAFT EXIT IDENTIFIER SIGN WIRE BROKEN. REPAIRED SIGN ASSEMBLY IAW SWPM & AMM.SDR SWAA2015123047518Skin · crackedFORWARD CARGO DOOR SKIN CRACKED AT HANDLE CUT OUT. REPAIRED SKIN IAW EA.SDR SWAA2015121147023Skin · crackedFORWARD CARGO DOOR SKIN, CRACKED AT FWD SIDE OF HANDLE ASSEMBLY CUT OUT. REPAIRED SKIN IAW EA.SDR SWAA2015111145973Bracket · crackedNUMBER 2 PYLON, LOWER AFT SAIL TAIL AT FRAME, OTBD BRACKET CRACKED AT BS 363.65. R & R BRACKET IAW DWG & SRM.SDR SWAA2015110945877Support Angle · crackedLEFT WING LOWER LE SUPPORT STRUCTURE ANGLE, LOCATED INBD OF LE STATION 212, CRACKED. R & R ANGLE IAW DWG & SRM.SDR SWAA2015110945870Bracket · crackedNUMBER 1 PYLON LOWER AFT SAIL TAIL AT FRAME OTBD BRACKET CRACKED AT BS 363.65. R & R BRACKET IAW DWG & SRM.SDR SWAA2015110645823Strap · crackedISOLATOR STRAP CRACKED AT BS 946, STRINGER 16R. REPAIRED STRAP IAW AMM.SDR SWAA2015110245551Lens · looseLEFT CTR WING EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2015110245550Lens · missingMID CABIN OVERWING EXIT SIGN, LOWER LENS COVER MISSING. INSTALLED COVER IAW EA.SDR SWAA2015122947499Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 908, STRINGER 4R. R & R SPLICE IAW EA.SDR SWAA2015122947498Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 908, STRINGER 4L. R & R SPLICE IAW EA.SDR SWAA2015122947495Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 908, STRINGER 5R. R & R SPLICE IAW EA.SDR SWAA2015122947494Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 908, STRINGER 5L. R & R SPLICE IAW EA.SDR SWAA2015121447072Shear Tie · crackedSHEAR TIE CRACKED AT BS 908, BETWEEN STRINGER 2R - 3R. R & R SHEAR TIE IAW EA.SDR SWAA2015121147022Skin · crackedFORWARD CARGO DOOR SKIN, CRACKED AT HANDLE CUT OUT FWD SIDE FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2015112446395Stringer · corrodedSTRINGER CORRODED AT BS 967, STRINGER 27L. R & R STRINGER IAW SRM & DWG.SDR SWAA2015111646070Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 277, STRINGER 15R. R & R CLIP IAW SRM.SDR SWAA2015111646069Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8L. R & R CLIP IAW SRM.SDR SWAA2015111646068Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 11L. R & R CLIP IAW SRM.SDR SWAA2015111646067Web · corrodedFORWARD ENTRY DOOR MOPSILL SUPPORT WEB LOWER SURFACE CORRODED, BETWEEN BS 344 - 350. REPAIRED WEB IAW SRM.SDR SWAA2015110645814Angle · crackedFLOORBEAM VERTICAL STIFFENER ANGLE CRACKED AT BS 328, RBL 34. R & R ANGLE IAW SRM.SDR SWAA2015110245660Sign · looseLEFT OVERWING EMER EXIT SIGN LOOSE ON MOUNT. SECURED SIGN IAW AMM.SDR SWAA2015110245615Cover · looseRIGHT OVERWING EMER EXIT SIGN LIGHT, COVER LOOSE. SECURED SIGN IAW SIP.SDR SWAA2015121547149Skin · crackedLEFT WING UPPER AFT SKIN CRACKED ON UPPER WING APPROX 17" INBD OF RSS 254. REPAIRED SKIN IAW EA.SDR SWAA2015121147021Skin · crackedLEFT WING UPPER WING SKIN, FASTENER HOLE CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015111646066Strap · corrodedFORWARD PRESSURE BULKHEAD LOWER STRAP CORRODED AT BS 1016, BETWEEN STRINGER 27L - 27R. REPAIRED STRAP IAW EA.SDR SWAA2015110445747Sensor · faultyAIR TURN BACK, AIR & GND SYS FAILURE. GEAR WOULD NOT RETRACT, TAKEOFF CONFIGURATION WARNING LIGHT ILLUMINATED. GEAR WARNING HORN SOUNDED. R & R RT MLG S106 SENSOR IAW AMM.SDR SWAA2015110245657Angle · crackedLEFT WING TE CURVED ANGLE, CRACKED AT LOWER EDGE NEAR AILERON, 2ND FROM INBD HINGE, NEAR REAR SPAR STATION 547. R & R ANGLE IAW SRM & DWG.SDR SWAA2016022349264Fitting · corrodedLEFT WING REAR SPAR, INBD BATH TUB FITTING AT UPPER CHORD CORRODED, AT RSS 136, INBD FASTENER HOLE. REPAIRED FITTING IAW EA.SDR SWAA2015120846849Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED AT RSS 224.14. REPAIRED CHORD IAW ATS ER & EA.SDR SWAA2015113046520Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT MLG SUPPORT FITTING. REPAIRED WEB IAW EA.
Back to Boeing 737-3H4