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 ASAA0040030Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THREE EMERGENCY EXIT FLOOR TRACK LIGHTS AT AFT OVERWING EXIT WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHTS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040029Pin · disconnectedLAX - PRIOR TO FLIGHT 679, THE FORWARD TWO EMERGENCY EXIT LIGHTS WERE FOUND TO BE INOPERATIVE. REATTACHED PINS IN LIGHT SOCKETS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040028Wire · disconnectedANC - PRIOR TO FLIGHT 62, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 14-16 WERE FOUND TO BE INOPERATIVE. SECURED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040026Wire · disconnectedSEA - PRIOR TO FLIGHT 388, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 20-24 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040024Wire · disconnectedGEG - PRIOR TO FLIGHT 570, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE AT ROW 13. RECONNECTED WIRING AT ROW 13 AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040016Wire · disconnectedSEA - PRIOR TO FLT 256, THE FORWARD 3 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATAIVE. RECONNECTED WIRIGN AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040013Connector · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS AT ROWS 13-16 WERE FOUND INOPERATIVE. RECONNECTED LOOSE CONNECTOR AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA0040010Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY TRACK LIGHTS AT ROWS 14-17 WERE FOUND INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA0040007Light · brokenPDX - DURING MAINTENANCE CHECK, 2 EACH EMERGENCY EXIT TRACK LIGHTS WERE FOUND INOPERATIVE AT ROW 13. REPLACED 2 EACH LIGHT ASSEMBLIES AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA0040006Door · out of adjustOAK - PRIOR TO FLIGHT 340, THE R2 DOOR INNER HANDLE WAS REPORTED TO SEEM LOOSE, NOT ALLOWING THE DOOR TO CLOSE TIGHTLY. MAINTENANCE ADJUSTED DOOR AND THE DOOR OPERATED NORMALLY. (M)SDR ASAA0040004Roller · damagedSEA - PRIOR TO FLT 723 - THE L1 DOOR WAS REPORTED TO BE DIFFICULT TO OPEN OR CLOSE. REPLACED FORWARD CAM FOLLOWER ROLLER AND DOOR OPERATED NORMALLY. (M)SDR ASAA0040003Door · lack of lubeSEA - PRIOR TO FLIGHT 389, THE L1 DOOR WAS REPORTED TO BE HARD TO OPEN OR CLOSE. LUBRICATED DOOR AND DOOR OPERATED NORMALLY. (M)SDR ASAA0040002Control Panel · smokePDX - FLT 603 - DURING FLIGHT, THE NR 2 GENERATOR BUS OFF LIGHT ILLUMINATED WITH ASSOCIATED SYSTEM LIGHTS. ODOR OF ELECTRICAL SMOKE WAS NOTED, THEN DISSIPATED. SMOKE WAS NOTED COMING FROM THE GCU. REMOVED POWER FROM NR 2 GEN BUS AND SMOKE CEASED. THE AIRCRSDR ASAA0040001Engine · malfunctionedPDX-ATB - FLT 95, DUE TO REPORT OF SMOKE IN THE CABIN AFTER TAKEOFF. PACKS WERE TURNED OFF AND THE SMOKE DISSIPATED. AIRCRAFT RETURNED TO PDX AND LANDED WITHOUT INCIDENT. PDX MAINTENANCE INSPECTED AIRCRAFT AND RELEASED FOR FERRY FLIGHT TO SEA FOR REPAIR. SSDR ASAA9940169Door · lack of lubePDX - PRIOR TO FLIGHT 419, THE L1 DOOR WAS FOUND TO BE HARD TO CLOSE. LUBRICATED DOOR AND DOOR OPERATED NORMALLY. (M)SDR ASAA9940166Fuse · failedLAX - DURING MAINTENANCE CHECK, THE FORWARD EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE IN THE FORWARD FIRST CLASS CABIN AREA. REPLACED FUSE IN THE LEFT FORWARD BATTERY PACK AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940165Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE AFT 3 EMERGENCY EXIT TRACK LIGHTS AND THE R1 DOOR EMERGENCY EXIT IDENTIFIER WERE FOUND INOPERATIVE. REPLACED THE AFT TRACK LIGHT ASSEMBLY AND THE R1 DOOR EMERGENCY EXIT IDENTIFIER AND LIGHTS OPERATED NORMALLY. REF: OPER CSDR 2000ZZZX252Sign · inoperativeSEA - DURING MAINTENANCE CHECK, THE AFT 3 EMERGENCY EXIT TRACK LIGHTS AND THE R1 DOOR EMERGENCY EXIT IDENTIFIER WERE FOUND INOPERATIVE. REPLACED THE AFT TRACK LIGHT ASSEMBLY AND THE R1 DOOR EMERGENCY EXIT IDENTIFIER AND LIGHTS OPERATED NORMALLY. REF: OPER CSDR ASAA9940164Wire · disconnectedGEG - PRIOR TO FLT 570, 3 EACH EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. REPAIRED LOOSE WIRING/CONNECTION AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940163Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE AFT THREE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERABLE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940162Harness · failedPDX-ATB OF F500 DUE TO MULTIPLE CIRCUIT BREAKERS POPPED. AIRCRAFT RETURNED TO PDX. PDX MAINTENANCE INSPECTED AND FOUND A FAILURE OF THE WIRE BUNDLE INSULATION AT BS 410, WL 203, RBL 58 (BEHIND LINER IN FORWARD CARGO COMPARTMENT AFT OF E/E BULKHEAD AND FORWARSDR ASAA9940161Wire · disconnectedPDX - PRIOR TO FLT 602, THE FLOOR TRACK LIGHT COVER WAS FOUND LOOSE AT ROW 20. MAINTENANCE INSPECTED AND FOUND LIGHTS TO BE INOPERATIVE. RECONNECTED WIRING AT ROWS 20 AND 23. LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940157Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS IN THE FIRST CLASS CABIN OPERATED NORMALLY INITIALLY AND THEN BECAME INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940156Wire · disconnectedSEA - PRIOR TO FLT 394, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERABLE AND LENSES MISSING AT ROWS 21 AND 22. REPLACED LENSES AT ROWS 21 AND 22. RELAMPED LIGHT AT ROW 22, LIGHT OPERATED NORMALLY. EMERGENCY EXIT FLOOR TRACK LIGHT AT ROW 21 WAS STSDR 99ZZZX4626Lens · missingSEA - PRIOR TO FLT 394, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERABLE AND LENSES MISSING AT ROWS 21 AND 22. REPLACED LENSES AT ROWS 21 AND 22. RELAMPED LIGHT AT ROW 22, LIGHT OPERATED NORMALLY. EMERGENCY EXIT FLOOR TRACK LIGHT AT ROW 21 WAS STSDR ASAA9940153Wire · failedPDX - PRIOR TO FLT 440 SEVERAL EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE MID-CABIN AREA. REPAIRED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940152Wire · failedYVR - PRIOR TO FLT 684, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE AT ROWS 14-15. CONTRACT MAINTENANCE REPAIRED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940151Light · inoperativePDX - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE AT ROWS 14-17. REPLACED LIGHT ASSEMBLY AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940150Wire · failedSEA - PRIOR TO FLT 364, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE AT ROWS 20-24. REPAIRED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940149Light · inoperativeSEA - DURING MAINTENANCE CHECK, ONE EMERGENCY EXIT FLOOR TRACK LIGHT WAS FOUND INOPERATIVE BETWEEN AFT LAVS. REPLACED LIGHT ASSEMBLY AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940146Wire · failedSEA - DURING MAINTENANCE CHECK, 2 EACH AFT EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. REPAIRED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940144Wire · disconnectedPDX - DURING MAINTENANCE CHECK, FOUND THE AFT 4 EMERGENCY EXIT TRACK LIGHTS TO BE INOPERATIVE. RECONNECTED WIRING TO LIGHTS AND RELAMPED, LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940142Wire · looseSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 1 WERE FOUND LOOSE AND INOPERATIVE. REPLACED WIRING, LIGHTS AND TRACK COVER IN FLOOR TRACK AND LIGHTS OPERATED NORMALLY. (M)SDR 99ZZZM638Lights · inoperativeSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 1 WERE FOUND LOOSE AND INOPERATIVE. REPLACED WIRING, LIGHTS AND TRACK COVER IN FLOOR TRACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940140Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE L2 DOOR LOWER EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. REPLACED LIGHT ASSY AND LIGHT OPERATED NORMALLY. (M)SDR ASAA9940138Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE AFT 3 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED LIGHTS/WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940137Light · inoperativeJNU - DURING MAINTENANCE CHECK, THE AFT THREE EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. REPLACED LIGHT ASSEMBLY AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940133Charger · inoperativeANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE FROM ROW 8 TO THE FIRST OVERWING EXIT. REPLACED BATTERY PACK, CHARGER, AND REPAIRED WIRING, LIGHTS OPERATED NORMALLY. (M)SDR 99ZZZM623Battery Charger · dischargedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE FROM ROW 8 TO THE FIRST OVERWING EXIT. REPLACED BATTERY PACK, CHARGER, AND REPAIRED WIRING, LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940132Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE FORWARD 2 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING/LIGHTS AND THE LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940122Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE AT SEVERAL LOCATIONS. RELAMPED 2 EACH LIGHTS AND REPAIRED WIRING TO FLOOR TRACK LIGHTS, LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940131Support · crackedPHX - DURING SCHEDULED SI CHECK, THE RT AILERON INBOARD HINGE SUPPORT WAS FOUND TO BE CRACKED AT THE NUTPLATE, OUTBOARD SIDE. REPAIRED PER EA 5740-01177. (M)SDR ASAA9940130Chord · corrodedPHX - DURING SCHEDULED SI CHECK, THE RIGHT INNER CHORD AT THE R2 DOOR STATION 947.5 TO 957.5 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 51-40-02. (M)SDR ASAA9940129Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FLOORBEAM CAP UPPER SURFACE AT STATION 344, LBL 40-56 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-00-51, FIG 203. (M)SDR ASAA9940128Skin · lightning strikePHX - DURING SCHEDULED SI CHECK, THE EXTERNAL FUSELGE SKIN AT BS 360, STRINGER 17L WAS FOUND TO HAVE 2 LIGHTNING STRIKES. REPAIRED PER SRM 53-00-01, FIG 223. (M)SDR ASAA9940127Floorbeam · damagedPHX - DURING SCHEDULED SI CHECK, THE TOP FLANGES OF THE FLOORBEAM AT STATION 986.5, LBL 33 - RBL 30 WERE FOUND TO BE GOUGED AND CORRODED. REPAIRED PER EA 5310-01697. (M)SDR ASAA9940126Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FORWARD AND AFT FLANGES OF THE FLOORBEAM AT STATION 947.5, LBL 12-RBL 10 WERE FOUND TO BE CORRODED. REPAIRED PER EA 5310-01702. (M)SDR ASAA9940125Frame · dentedPHX - DURING SCHEDULED SI CHECK, THE AFT CARGO COMPARTMENT TOP OF MAIN FRAME WAS FOUND TO BE DENTED AT BS 727E 30 INCHES BELOW STRINGER 22R AND BS 727F ABOVE STRINGER 25R. REPAIRED PER EA 5310-01701. (M)SDR ASAA9940124Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FLOORBEAM CAP UPPER SURFACE AT STATION 312 LBL 12 TO RBL 12 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-10-01 FIG 205. (M)SDR ASAA9940123Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FORWARD AND AFT TOP FLANGED OF THE FLOORBEAM AT STATION 967, LBL 14-21 AND 23-33 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-00-51 FIG 202. (M)
Back to Boeing 737-4Q8