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 SWAA2015041538519Fitting · crackedLEFT SIDE NOSE WW ANGLE CLIP CRACKED AT BS 294.5, STRINGER 23L. R & R ANGLE CLIP IAW SRM & DWG.SDR SWAA2015041338446Strap · crackedRIGHT AUXILIARY STRAP CRACKED AT BS 727. R & R STRAP IAW SRM.SDR SWAA2015040738245Plate · crackedR1 DOOR INTERNAL SKIN PLATE CRACKED BOTTOM, AFT LIGHTNING HOLE ON FWD SIDE. REPAIRED PLATE IAW SRM.SDR SWAA2015032437748Fitting · crackedLEFT WING INBD GND SPOILER INBD ACTUATOR FITTING CRACKED. R & R FITTING IAW AMM.SDR SWAA2015032337719Fairing · delaminatedLEFT WING INBD FLAP OTBD TRACK FAIRING DELAMINATED INBD AFT AREA. REPAIRED FAIRING IAW SRM.SDR SWAA2015032337683Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED AT OTBD AREA. R & R AFT FLAP IAW MM.SDR SWAA2015032337682Slat · delaminatedRIGHT WING NR 4 SLAT TE WEDGE INBD END DELAMINATED. R & R NR 4 SLAT ASSEMBLY IAW AMM.SDR SWAA2015032337681Slat · delaminatedLEFT WING NR 1 SLAT DELAMINATED INBD AFT CORNER. R & R NR 1 SLAT IAW AMM.SDR SWAA2015032337720Strap · displacedRIGHT EMER EXIT HATCH THE ESCAPE STRAP DISPLACED. REINSTALLED STRAP IAW AMM.SDR SWAA2015050439233Web · corrodedWEB CORRODED BETWEEN BS 400 - 420, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2015050439232Frame · crackedFRAME CRACKED AT BS 380, BETWEEN STRINGER 14R - 16R. REPAIRED FRAME IAW EA.SDR SWAA2015042738976Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 787+3, STRINGER 18R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042038661Web · corrodedFLOOR WEB STRUCTURE CORRODED BETWEEN BS 500 - 500A, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015041538518Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 20R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015041538517Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STRINGER 20R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015040138046Web · corrodedWEB CORRODED AT BS 348, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015032737933Glowstrip · deterioratedRIGHT EEPLS PHOTO LUMINESCENT STRIPS DETERIORATED. R & R STRIP IAW MM.SDR SWAA2015032737931Glowstrip · deterioratedLEFT EEPLS PHOTO LUMINESCENT STRIPS DETERIORATED. R & R STRIP IAW MM.SDR SWAA2015032037674Latch · faultyRIGHT EMER ESCAPE ROPE DOOR LATCH FAULTY. R & R LATCH IAW SIP.SDR SWAA2015032037673Cover · missingFORWARD GALLEY EMER EXIT LIGHT COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2015050439231Floorbeam · crackedFLOORBEAM CRACKED AT BS 947.5, LBL 53. REPAIRED FLOORBEAM IAW EO & EA.SDR SWAA2015042939106Skin · crackedLEFT WING FIXED LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2015042939105Skin · crackedLEFT WING NR 1 SLAT EXTERNAL LOWER SKIN AT LEVEL OF OTBD MAIN TRACK CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2015042839060Support Angle · crackedLEFT PYLON ACCESS PANEL 5744L AT AFT STRUT FAIRING SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2015041638598Stringer · corrodedRIGHT STRINGER CORRODED BETWEEN BS 1113 - 1124. R & R STRINGER IAW SRM & DWG.SDR SWAA2015041338407Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 907, STRINGER 18L. R & R SPLICE IAW SRM.SDR SWAA2015041038342Tie Clip · crackedTIE CLIP CRACKED AT BS 887, STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015040838273Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2015033137999Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED ON UPPER SURFACE AT 48 INCHES OTBD END. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015033037948Stringer · corrodedRIGHT STRINGER CORRODED BETWEEN BS 1116 TO 1128. R & R STRINGER IAW SRM & DWG.SDR SWAA2015032637887Strap · crackedRIGHT AUXILIARY STRAP CRACKED AT BS 727. R & R STRAP IAW DWG & SRM.SDR SWAA2015031937615Latch · out of adjustFIRST OFFICER EMER ESCAPE ROPE DOOR LATCH OUT OF ADJUSTMENT. ADJUSTED LATCH IAW AMM.SDR SWAA2015031937597Light · inoperativeRIGHT MID CABIN EMER EXIT SIDEWALL OVERHEAD FLORESCENT LIGHT INOPERATIVE. REPAIRED LIGHT IAW MM.SDR SWAA2015050439247Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, BETWEEN STRINGER 9R - 11R. R & R CHORD IAW EO & EA.SDR SWAA2015050139203Frame · crackedFORWARD CARGO COMPARTMENT FRAME CRACKED AT BS 520, BETWEEN STRINGER 20R - 21R. REPAIRED FRAME IAW SRM.SDR SWAA2015041738619Frame · corrodedFRAME CORRODED AT BS 992.8, BETWEEN STRINGER 17A - 17R. REPAIRED FRAME IAW EO & EA.SDR SWAA2015040738191Strap · crackedSPLICE STRAP CRACKED AT BS 360, STRINGER 3R. REPAIRED STRAP IAW EA.SDR SWAA2015033037953Angle · crackedAFT PRESS BULKHEAD Z ANGLE CRACKED AT BS 1016, BETWEEN LBL 8.5 - 17. R & R Z ANGLE IAW SRM & DWG.SDR SWAA2015033037947Doubler · crackedCENTER WING BOX DOUBLER CRACKED AT BS 639, RBL 45.5+7. R & R DOUBLER IAW SRM & DWG.SDR SWAA2015032537756Lug · corrodedRIGHT WING NR 5 FLAP TRACK LUG CORRODED. REPAIRED LUG IAW CMM.SDR SWAA2015032537755Lug · corrodedLEFT WING NR 4 FLAP TRACK INBD LUG CORRODED. REPAIRED LUG IAW CMM.SDR SWAA2015031737524Release Cable · disconnectedL2 DOOR EMER EVAC SLIDE RELEASE CABLE DISCONNECTED. RECONNECTED SLIDE IAW MT.SDR SWAA2015042138736Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5 LBL 14.5. REPAIRED FLOORBEAM IAW EO & EA.SDR SWAA2015041638603Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947.5, BETWEEN STRINGER 27L TO 26R. R & R SHEAR TIE IAW SRM.SDR SWAA2015041638597Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 328, LBL 26.75. REPAIRED CHORD IAW EA.SDR SWAA2015041438499Shear Tie · corrodedFRAME SHEAR TIE ANGLE CORRODED AT BS 344, STRINGER 27R. R & R ANGLE IAW DWG.SDR SWAA2015041038376Stringer · corrodedSTRINGER CORRODED AT BS 355, STRINGER 24R. R & R STRINGER IAW SRM & DWG.SDR SWAA2015040938318Strap · crackedLOWER CABIN FLOOR STRUCTURE STRAP CRACKED NEAR FASTENER HOLE AT BS 344, BL 0. REPAIRED STRAP IAW EA & EA.SDR SWAA2015040638155Fitting · crackedCLIP CRACKED AT BS 303.9+8, STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2015033137998Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED ON UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.
Back to Boeing 737-3H4