Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA0140007Frame · crackedPAE - DURING SI CHECK, FOUND CRACK AT BS 178 LEFT AND RIGHT SIDE AT WL 205. REMOVED AND REPLACED BS 178 LEFT AND RIGHT SIDE CHORD PER EA 5310-01890. (M)SDR ASAA0140006Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM AT BS 986.6 RBL 44 TO LBL 31, WL 208 AROUND FASTENER HOLES. REPAIRED FLOORBEAM IAW EA 5310-01891. (M)SDR ASAA0140003Wire · disconnectedSEA - BEFORE FLIGHT, FOUND FLOOR TRACK LIGHTING IN MID CABIN INOPERATIVE. RECONNECTED WIRING, OPERATIONAL CHECK NORMAL. (M)SDR ASAA0140004Wire · brokenSEA - DURING PREFLIGHT, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE. REPLACED BROKEN WIRES OPERATIONAL CHECKED NORMAL. (M)SDR ASAA0140002Light · inoperativePDX - DURING LINE CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY SPOT LGIHT INOPERATIVE, BURNED OUT. REPLACED BULB, OPS CHECK NORMAL. (M)SDR ASAA0140001Wire · brokenSEA - DURING LINE CHECK INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROWS 17-20, BROKEN WIRE. REPAIRED WIRE, OPERATIONAL CHECK NORMAL. (M)SDR ASAA0040161Light · inoperativePDX - DURING LINE CHECK INSPECTION, FOUND AFT 3 TRACK LIGHTS INOPERATIVE IN AFT CABIN, LOOSE WIRING. RECONNECT LIGHTS, OPERATIONAL CHECK NORMAL. (M)SDR ASAA0040160Wire · loosePSP - BEFORE FLIGHT, FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROW 10, LOOSE WIRING. INSPECTED AND FOUND LOOSE WIRING, RECONNECTED WIRING. OPS CHECK NORMAL. (M)SDR ASAA0040158Battery Pack · dischargedSEA - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROWS 19-22 INOPERATIVE. REMOVED AND REPLACED BATTERY PACK FOR ROW 10-22 TRACK LIGHTS, OPS CHECKED NORMAL. (M)SDR ASAA0040156Wire · faultyPSP - PRIOR TO FLIGHT - FOUND LAST FOUR EMERGENCY EXIT TRACK LIGHTS INOPERATIVE. REPAIRED FAULTY WIRE CONNECTION AS REQUIRED, OPS CHECK NORMAL. (M)SDR ASAA0040157Wire · disconnectedSEA - DURING LINE CHECK, FOUND FIRST 5 FRONT EMERGENCY TRACK LIGHTS INOPERATIVE, DISCONNECTED. RECONNECTED MODULE WIRING ASSEMBLY, OPS CHECK NORMAL. (M)SDR ASAA0040159Wire · brokenSEA - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTS AT ROW 19 INOPERATIVE, WIRE BROKEN. REPAIRED WIRING AND RECONNECTED, OPS CHECK NORMAL. (M)SDR ASAA0040155Wire · disconnectedSEA - DURING LINE CHECK INSPECTION, FOUND FLOOR EMERGENCY EXIT LIGHTING INOPERATIVE AT LEFT OVERWING EXIT. RECONNECT WIRE, OPS CHECK NORMAL. (M)SDR ASAA0040152Lamp · inoperativeSEA-DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTING INOPERATIVE AT ROWS 16, 19. REMOVED AND REPLACED LIGHTS AND WIRING ASSEMBLIES, OPS CHECKED NORMAL.SDR ASAA0040151Wire · disconnectedPDX-DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHT INOPERATIVE AT ROWS 17 AND 19. DISCONNECTED WIRING. RECONNECTED WIRE, OPERATIONAL CHECK, NORMAL.SDR ASAA0040148Threshold · crackedPAE - DURING C-CHECK, FOUND AFT CARGO BAY CENTER THRESHOLD CRACKED. REMOVED AND REPAIRED IAW ASA EA 5320-01442. (M)SDR ASAA0040147Panel · crackedPAE - DURING C-CHECK INSPECTION, FOUND SLAT ACCESS PANEL NR 6516 CORNER CRACKED. REPAIRED IAW ASA EA 5740-01231. (M)SDR ASAA0040146Frame · crackedPAE - DURING C-CHECK INSPECTION WHILE PERFORMING AN EDDY CURRENT EXAMINATION, FOUND CRACK AT LEFT SIDE CHORD AT BS 178 BELOW THE FLOOR FROM WATERLINE 202 TO 207 AND BUTTLINE 4.7. REPAIRED IAW ASA EA 5310-01883. (M)SDR ASAA0040145Wire · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE AT ROWS 16/19. RECONNECTED WIRE, OPERATIONAL CHECKS NORMAL. (M)SDR ASAA0040141Guard · damagedPAE - DURING INSPECTION, FOUND FORWARD CARGO COMPARTMENT LEFT BLOW OUT PANEL GRATE DAMAGED. REMOVED FORWARD CARGO COMPARTMENT LEFT BLOWOUT PANEL GRATE, ACCOMPLISHED PERMANENT REPAIR PER SRM 51-40-02 AND EA 2550-C1151 AND REINSTALLED. (M)SDR ASAA0040139Light · damagedSEA-DURING LINE CHECK FOUND FLOOR EMERGENCY TRACK LIGHTS INOP AT ROWS 17-20. REMOVED AND REPLACED LIGHT ASSEMBLIES, OPERATIONAL CHECKS NORMAL.SDR ASAA0040140Skin · wornSEA-DURING C CHECK FOUND RT RAM AIR INLET DUCT LOWER WEB SKINS AT STATION 530 TO 540 HAVE WEAR AREA'S FROM DOOR MOVEMENT. REPAIRED IN ACCORDANACE WITH EA 5320-01440.SDR ASAA0040132Light · disconnectedPDX - DURING SERVICE INSPECTION, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE AT ROW 1-2, WIRE DISCONNECTED. RECONNECTED TRACK LIGHTS, OPERATION CHECKED NORMAL. NO DEFECTS NOTED. (M)SDR ASAA0040133Fitting · gougedPAE - DURING SI CHECK, FOUND LEFT AILERON INBOARD HINGE FITTING A/C SIDE WAS GOUGED ON INBOARD LUG OUTBOARD SIDE. REPAIRED IAW ASA EA5750-01491. (M)SDR ASAA0040136Skin · wornSEA - DURING C-CHECK INSPECTION, FOUND WEAR DAMAGE ON INNER SURFACE IF WING SKIN AT THE INBOARD FUEL BOOST PUMP ACCESS PANEL CUTOUT LOCATED AT APPROXIMATELY WL 120 AND S-7. REPAIRED IAW ASA EA 5720-01189. (M)SDR ASAA0040137Skin · wornSEA - DURING C-CHECK INSPECTION, FOUND WEAR DAMAGE ON THE INNER SURFACE OF WING LOWER SKIN AT THE FUEL BOOST PUMP ACCESS PANEL CUTOUT LOCATED AT APPROX WBL 151.0 AND S-7. REPAIRED IAW EA 5720-01187. (M)SDR ASAA0040134Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 986, WL 208, LBL 65 - RBL 65 IS CORRODED AROUND NUTPLATE. REPAIRED IAW EA 5310-01885. (M)SDR ASAA0040135Clip · gougedPAE - DURING SI CHECK, FOUND THRUST REVERSER BLOCKER DOOR ANTI-ROTATION CLIPS HAVE GOUGED THE C-DUCT BULL NOSE BEYOND MFG LIMITS. REPAIRED IAW EA5430-01084. (M)SDR 20001214SH007Nut · looseDURING ROUTINE C-CHECK INSPECTION, FOUND LEFT MAIN LANDING GEAR LOWER SIDE STRUT LOWER ATTACH POINT HAD A .250 INCH GAP BETWEEN NUT AND STRUT AND NUT HAD NO LOCKING FEATURE. IPC 32-30-00-03A FIG NR A ITEM 40. (X)SDR ASAA0040131Frame · crackedPAE - DURING SI CHECK, FOUND RIGHT AND LEFT SIDE CHORDS AT BODY STATION 178, WATERLINE 2.6.5 TO 208 ARE CRACKED. BULKHEAD WEB IS ALSO CRACKED AT WATER LINE 201.5 TO 202, RBL 4.7 FUSELAGE 154, CRACK IN WEB, FUSELAGE 155 RIGHT CHORD, FUSELAGE 156 LEFT CHORD. SSDR ASAA0040130Wire · disconnectedPDX-FOUND EMERGENCY TRACK LIGHTS INOP AT ROW 18-19, DISCONNECTED.RECONNECTED TRACK LIGHTS, OPERATION CHECKED NORMAL, NO DEFECTS NOTED.SDR ASAA0040129Light · inoperativeSJC: PRIOR TO SCHEDULED FLIGHT FOUND EMERGENCY FLOOR TRACK EGRESS LIGHTS AT ROWS 16 & 17 INOP. REMOVED AND REPLACE EGRESS TRACK LIGHT BULBS AND REPLACED WIRES AT ROWS 16 & 17, OPS CHECKED NORMAL, RELEASED ACFT FOR SERVICE.SDR ASAA0040128Engine · odorLAX-NR1 ENG ON APPROACH, PRODUCED AN ELECTRICLA SMELL AND HAZE WAS SEEN IN THE CABIN IN CONJUNCTION, A NOISE WAS HEARD, THE EGT STARTED INCREASING, SHUT DOWN PROCEDURES WERE INITIATED, ACFT LANDED WITHOUT INCIDENT. REMOVED AND REPLACED NR1 ENGINE, ENGINE WAS RSDR ASAA0040121Seat Track · gougedPAE DURING MAINTENANCE INSPECTION FOUND GOUGES ON SEAT TRACK AT STA 500E-520, RLB 25. REPAIRED IN ACCORDANCE WITH EA 5310-01870.SDR ASAA0040122Floorbeam · corrodedPAE DURING MAINTENANCE INSPECTION FOUND CORROSION ON UPPER FLANGE OF FLOOR BEAM @STA 986.5. REPAIRED IN ACCORDANCE WITH EA 5310-01972.SDR ASAA0040123Structure · damagedPAE DURING SCHEDULED MAINTENANCE CHECK, FOUR HOLES WERE DAMAGED ON THE NR2 PYLON OUTBOARD SID OF AFT HINGE FITTIN MOUNT AT NACELLE STA 224. REPAIRED IN ACCORDANCE WITH EA 5430-01078.SDR ASAA0040124Fairing · gougedPAE DURING MAINTENANCE INSPECTION FOUND N1 ENGINE SLEEVE TO STRUT FAIRING OUTBOARD SIDE, HAS A GOUGE IN THE CENTER AREA 6 INCHES LONG AND .5 INCHES WIDE. REPAIRED IN ACCORDANCE WITH EA 5450-01051.SDR ASAA0040125Beam · gougedPAE DURING SCHEDULED MAINTENANCE CHECK, FOUND NR 2 MLG BEAM GOUGED ON THE LOWER SURFACE. FORWARD EDGE, JUST OUTBOARD OF THE JANGER SHAFT FITTING. REPAIRED IN ACCORDANCE WITH EA 5750-01482.SDR ASAA0040126Fitting · damagedPAE DURING SCHEDULED MAINTENANCE CHECK, GOUGES WERE FOUND ON THE NR2 ENGINE THRUST REVERSER BLOCKED DOOR HINGE LUGS. REPAIRED IN ACCORDANCE WITH EA 7830-01133.SDR ASAA0040127Frame · crackedPAE DURING MAINTENANCE INSPECTION, FOUND RIGHT HAND AND LEFT HAND BULKHEAD SIDE CHORDS ARE CRACKED AT STA 178. REMOVED AND REPLACED RIGHT HAND AND LEFT HAND BULKHEAD SIDE CORDS IN ACCORDANCE WITH SB 737-53A1173 REV 3.SDR AA0040120Light · disconnectedPDX DURING SERVICE INSPECTION FOUND EMERERGENCY TRACK LIGHTS INOP AT ROW 6-7, (WIRE DISCONNECTED). RECONNECTED TRACK LIGHTS, OPERATION CHECKED NORMAL, NO DEFECTS NOTED.SDR ASAA0040119Light · disconnectedPDX DURING SERVICE INSPECTION FOUND EMERGENCY TRACK LIGHTS INOP AT ROW 22-24, DISCONNECTED. RECONNECTED TRACK LIGHTS, OPERATION CHECKED NORMAL. NO DEFECTS NOTED.SDR ASAA0040116Wire · disconnectedPDX-DURING MAINTENANCE SERVICE CHECK FOUND FWD 5 EMERGENCY TRACK LIGHTS INOP. RECONNECTED LIGHTS, OPS CHECKED NORMAL.SDR ASAA0040115Skin · gougedPAE DURING MAINTENANCE S1 CHECK THE FUSELAGE SKIN AT STA 796 BETWEEN STR 19R AND 20R, WAS FOUND TO BE GOUGED. REPAIRED PER BFG ENGINEERING REPAIR 00-1101P1.SDR ASAA0040117Bulkhead · gougedSEA-DURING MAINTENANCE CHECK FOUND, FWD CARGO PIT LT, RT, AND CTR BULKHEAD PANEL GOUGED. REPAIRED I.A.W. EA 2550-01093.SDR ASAA0040114Skin · damagedSEA-DURING SCHEDULED 'C' CHECK THE LOWER FUSELAGE BELLY WAS FOUND TO BE CREASED ALONG STA 460 RIVET LINE STRINGER 27R TO 25L. REPAIRED PER SRM.SDR ASAA0040113Skin · damagedSEA-DURING SCHEDULED 'C' CHECK THE LOWER FUSELAGE BELLY WAS FOUND TO BE CREASED ALONG STA 480 RIVET LINE BELOW THE FORWARD CARGO DOOR CUTOUT FROM STRINGER 27L TO 26R. REPAIRED PER SRM.SDR ASAA0040112Skin · damagedSEA DURING SCHEDULED 'C' CHECK THE FUSELAGE SKIN ON CROWN STA 860, STRINGER 1L, HOLE UNDER DORSAL FIN. REPAIRED PER EA 5330-01461.SDR ASAA0040118Skin · gougedPAE-DURING MAINTENANCE CHECK FOUND FWD CARGO DOOR CUTOUT SKIN 10 INCHES ABOVE LOWER AFT CORNER GOUGED. REPAIRED I.A.W. SRM.SDR ASAA0040108Wire · brokenPDX - PRIOR TO FLIGHT 95, THE MID CABIN EMERGENCY TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. REPAIRED BROKEN WIRE AT MODULE M1388 AND THE LIGHTS OPERATED NORMALLY. (M)
Back to Boeing 737-4Q8