Boeing 737-3L9
Service difficulty reports · 1,188
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 = '7373L9' 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 = '7373L9' 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 W8PA970215Web · corrodedFOUND CORROSION ON BOTTOM OF WEB AT FLOOR PANEL ATTACHMENT HOLE. REMOVED DAMAGE AREA FROM WEB. FABRICATED AND INSTALLED REPAIR PARTS, BS 710, WL 208, LBL 65. (M)SDR W8PA970214Web · crackedWEB HAS A CRACK. CUTOUT DAMAGED AREA AT BS 277, STRINGER 14R WEB. INSTALLED FABRICATED PARTS. (M)SDR W8PA970213Web · crackedFOUND CRACKED WEB. REMOVED DAMAGED AREA OF WEB. FABRICATED REPAIR PARTS, INSTALLED, BS 350, LBL 66, STRINGER LT 16. (M)SDR W8PA970207Floor Support · corrodedFOUND CORROSION ON FLOOR SUPPORT AROUND TOP AND BOTTOM OF FASTENER HOLES. REMOVED DAMAGED PART AND REPLACED WITH NEW PART, BS 967 TO 987, WL 208, RBL 18. (M)SDR W8PA970206Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AROUND FASTENER HOLE. FABRICATED PARTS AND INSTALLED, BL 967, WL 208, RBL 16. (M)SDR W8PA970205Hat Channel · corrodedFOUND CORROSION ON HAT CHANNEL TOP AND BOTTOM OF FLANGE. REMOVED DAMAGED PARTS AND REPLACED WITH NEW PARTS, BS 948, WL 208, LBL 20 TO LBL 54. (M)SDR W8PA970204Hat Channel · corrodedFOUND CORROSION ON HAT CHANNEL. REMOVED DAMAGED PART AND REPLACED WITH NEW PART BL 913, WL 208, LBL 30 TO LBL 44. (M)SDR W8PA970203Floor Support · corrodedFOUND CORROSION ON FLOOR SUPPORT. CUT OUT DAMAGE, FABRICATED AND INSTALLED NEW PARTS, BL 907, WL 208, LBL 62. (M)SDR W8PA970202Floor Support · corrodedFOUND CORROSION ON FLOOR SUPPORT. REMOVED AND REPLACED BEAM, BL 965, WL 208, RBL 20. (M)SDR W8PA970201Bracket · corrodedFOUND CORROSION ON 4 'Z' BRACKETS AT ASD. INSTALLED NEW 'Z' BRACKETS, BL 967-987, WL 208, RBL 55. (M)SDR W8PA970200Sill · corrodedFOUND CORROSION ON ASD MOPSILL. FABRICATED NEW WEB AND INSTALLED, BS 953-988, WL 208, RBL 52. (M)SDR W8PA970199Web · corrodedFOUND CORROSION ON TOP AND BOTTOM OF HSD WEB. FABRICATED NEW WEB BS 953-985, WL 208, RBL 55. (M)SDR W8PA970198Web · corrodedFOUND CORROSION UNDER WEB. REMOVED DAMAGED WEB SUPPORT REPLACED NEW PART BS 994, WL 208 LBL 47. (M)SDR W8PA970197Floor Support · corrodedCORROSION ON THE TOP AND BOTTOM OF FLOOR SUPPORT AND WEB. FOUND FLOOR SUPPORT TO BE WITHIN LIMITS. WEB REPAIR TO BE COMPLETED ON CUSTOMER IAD NR 0000602. (M)SDR W8PA970196Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AROUND TOP AND BOTTOM OF FASTENER HOLE. REPLACED FLOORBEAM AT BS 967, WL 208 AND LBL 15. (M)SDR W8PA970195Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AROUND FASTENER NUTS. REPAIRED FLOORBEAM, BS 967, WL 208, LBL 18. (M)SDR W8PA970176Light · inoperativeFOUND EMERGENCY TRACK LIGHT INOP AT ROW 12. RECONNECTED WIRES AND REPLACED LENS. (M)SDR W8PA970531Frame · corrodedFOUND CORROSION ON TOP OF BS 219 FRAME, LBL 13 IN FORWARD E/E BAY. FABRICATED AND INSTALLED REPAIR PARTS, BS 219. (M)SDR W8PA970522Linkage · corrodedFOUND CORROSION ON POTABLE WATER VERTICAL PITCH ROD ATTACH LINKAGE, BS 959, LBL 23, WL 202. REMOVED CORRODED PARTS AND REPLACED WITH NEW PARTS, BS 959, LBL 23, WL 202. (M)SDR W8PA970521Linkage · corrodedFOUND CORROSION ON POTABLE WATER SERVICE PAN PITCH CONTROL ROD END ARM NEXT TO WATER TANK, BS 955, LBL 8, WL 148, ABOVE STRINGER 28R. REMOVED CORRODED PARTS AND INSTALLED NEW PARTS BS 955, LBL 8, WL 148. (M)SDR W8PA970520Stiffener · corrodedFOUND CORROSION ON TWO SUPPORT STIFFENERS RUNNING ACROSS THE TOP OF THE POTABLE WATER SERVICE PAN, BS 953 AND 957, LBL 20, WL 150.1. REMOVED CORRODED STIFFENERS, FABRICATED AND INSTALLED NEW STIFFENERS, BS 953 AND 957, LBL 20, WL 150.1. (M)SDR W8PA970518Frame · corrodedFOUND CORROSION ON UNDERSIDE OF NUTPLATE AND ON FRAME AT BS 500, RBL 23.3, WL 152.2. REMOVED CORRODED SECTION OF FRAME, FABRICATED FILLER AND DOUBLER AND INSTALLED, BS 500, RBL 23.3, WL 152.2. (M)SDR W8PA970509Bracket · corrodedFOUND BRACKET CRACKED AT BS 807, RBL 22, WL 157. REPLACED CRACKED BRACKET AT BS 807, RBL 22, WL 157. (M)SDR W8PA970508Chord · corrodedFOUND CORROSION BS 629, LBL 70 TO STRINGER 15L AROUND FASTENER HOLES. REPLACED CHORD PER BS 629, LBL 70, STRINGER 15L. (M)SDR W8PA970507Support · corrodedFOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT BS 992, LBL 38, WL 197. REPLACED PARTS BS 992, LBL 38, WL 197. (M)SDR W8PA970506Stringer · corrodedFOUND CORROSION ON OUTBOARD FLANGE OF STRINGER BS 848, STRINGER 23R, WL 167. REPLACED STRINGER. (M)SDR W8PA970505Intercostal · corrodedFOUND CORROSION ON BOTTOM SIDE OF INTERCOSTAL BS 867-887, RBL 23, WL 166. FABRICATED NEW INTERCOSTAL AND INSTALLED BS 867-887, RBL 23, WL 166. (M)SDR W8PA970503Stringer · corrodedFOUND STRINGER 28R CORRODED FROM BS 350-370, WL 148, WL 148, IN E-BAY. REMOVED DAMAGED STRINGER SECTION. REPLACED STRINGER SECTION. REPLACED STRINGER SECTION BS 350-370, WL 148, STRINGER 28R. (M)SDR W8PA970502Frame · corrodedFOUND CORROSION ON FRAME BS 360, BL 0 - RBL 6, WL 148 IN E-BAY. FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-00-07. (M)SDR W8PA970501Bulkhead · crackedFOUND CRACK AT BS 663.75 BULKHEAD FROM RBL 43 TO RBL 55, WL 156 TO WL 167. REPAIRED CRACK, BS 663.75, RBL 43 TO RBL 55, WL 156 TO WL 167. (M)SDR W8PA970500Filter Bracket · shearedSHEARED RIVET ON UPPER RIGHT CORNER OF HYDRAULIC RETURN FILTER BRACKET BS 663.75, RBL 40, WL 176. REMOVED SHEARED RIVET AND FILTER BRACKET. INSTALLED BRACKET AND NEW RIVET, BS 663.75, RBL 40, WL 176. (M)SDR W8PA970499Stringer · corrodedFOUND CORROSION AROUND NUTPLATE HOLE BS 500B PLUS 18, STRINGER 23R. REMOVED CORRODED PART, FABRICATED AND INSTALLED REPAIR PARTS BS 500B PLUS 18, STRINGER 23R. (M)SDR W8PA970483Channel · crackedEXPANSION LINK SEAT TRACK SUPPORT CHANNEL IS CRACKED. REMOVED CRACKED EXPANSION LINK AND REPLACED WITH NEW EXPANSION LINK, BS 520, WL 206, RBL 24.5. (M)SDR W8PA970482Channel · crackedEXPANSION LINK SEAT TRACK SUPPORT CHANNEL IS CRACKED. REMOVED DAMAGE PART, INSTALLED NEW PART, BS 520, WL 206, RBL 24.5. (M)SDR W8PA970236Stiffener · corrodedFOUND CORROSION ON STIFFENER AND ON TOP OF AFT TOILET SERVICE PAN. REMOVED AND REPLACED STIFFENER AND INTERCOSTAL, BS 997, WL 145, RBL 12. (M)SDR W8PA970235Web · corrodedFOUND CORROSION ON OUTBOARD SIDE OF WEB. REPLACED PARTS PER SRM 51-40-02, BS 992, WL 197 LBL 38. (M)SDR W8PA970234Support · corrodedFOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT. FABRICATED AND INSTALLED NEW SUPPORT, BS 797-877, WL 163, LBL 22. (M)SDR W8PA970224Hat Channel · corrodedFOUND CORROSION ON HAT CHANNEL. REMOVED AND REPLACED HAT CHANNEL, BL 947, WL 208, RBL 10-56. (M)SDR W8PA970221Support · corrodedFOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT, LOWER SURFACE UNDER NUTPLATES. REPLACED SUPPORT, BL 787-814, WL 156, RBL 22. (M)SDR W8PA970220Nutplates · corrodedFOUND CORROSION ON AND AROUND NUTPLATES. FABRICATED AND INSTALLED REPAIR PARTS, BL 850, WL 164, RBL 25. (M)SDR W8PA970219Web · corrodedFOUND CORROSION ON SUB THRESHOLD WEB. FABRICATED NEW WEB AND INSTALLED, BS 807-847, WL 157-160, RBL 28. (M)SDR W8PA970216Support · corrodedFOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT. REMOVED DAMAGED PART REPLACED WITH NEW PART BS 764-797, WL 159, LBL 22. (M)SDR W8PA970524Web · crackedFOUND CRACKED WEB BS 350, LBL 66, STRINGER 16L. REMOVED DAMAGED AREA OF WEB. FABRICATED REPAIR PARTS AND INSTALLED, BS 350, LBL 66, STRINGER 16. (M)SDR W8PA970517Floor Support · corrodedFOUND CORROSION ON FLOOR SUPPORT AROUND NUTPLATES BS 727 PLUS 17 - 860, LBL 3, WL 164. REMOVED CORROSION, FOUND FLOOR SUPPORT TO BE OUT OF LIMITS, REPAIRED. (M)SDR W8PA970516Floor Support · corrodedFOUND CORROSION ON FLOOR SUPPORT BS 727B PLUS 17 - 926, RBL 7.5, WL 175. FABRICATED REPAIR PARTS AND REPLACED FLOORBEAM, BS 727B PLUS 17 - 926, RBL 7.5, WL 175. (M)SDR W8PA970515Intercostal · corrodedFOUND CORROSION ON INTERCOSTAL AND ATTACH BRACKETS BS 927-947, STRINGER 21R, WL 187. FABRICATED NEW INTERCOSTAL AND ATTACH BRACKETS AND INSTALLED, BS 927-947, STRINGER 21R, WL 187. (M)SDR W8PA970514Support · corrodedFOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT, BOTH TOP AND BOTTOM AROUND NUTPLATES BS 877-949, LBL 21, WL 174. REMOVED CORRODED PART. FABRICATED AND INSTALLED NEW PART. (M)SDR W8PA970498Intercostal · corrodedFOUND CORROSION UNDER NUTPLATES ON INTERCOSTAL UNDER FLOOR TO SIDEWALL SUPPORT. REMOVED INTERCOSTAL, FABRICATED LEFT INTERCOSTAL, BS 927-947, LBL 22.5, WL 173. (M)SDR W8PA970233Support · corrodedFOUND CORROSION ON FLOOR SUPPORT AROUND NUTPLATES. FABRICATED AND INSTALLED REPAIR PARTS, BS 727B PLUS 17 TO 860, WL 164, LBL 8. (M)SDR W8PA970232Support · corrodedFOUND CORROSION ON FLOOR SUPPORT AROUND NUTPLATES. REPAIRED AND REPLACED FLOOR SUPPORT, BS 727B PLUS 17 TO 926, WL 175, LBL 12. (M)
Back to Boeing 737-3L9