JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
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 jasc_code = '3350' 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 jasc_code = '3350' 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 DALA2019052703319Light · inoperativeFOUND FLOOR PROXIMITY EMERGENCY OUT AT SEAT ROW 30, REPLACED FLOOR PROX LIGHT AT ROW 30.SDR HNAA2019052900155Light · inoperativeNDIS 639 33-51 0011920 25MAY19 RIC CLOSE EMER FLOOR STRIP @ SEAT 14 & 15A INOP 32622 00 BRA ACT 25MAY19 11:39 RIC R/R THE EMERGENCY FLOOR PROXIMITY STRIP AT SEAT 14 &15A IN REF TO AMM 33-50-12-000/400-801-A OPS CHECK GOOD OK FOR SERVICE P/N LIGHSDR DALA2019052803295Housing · broken(AIRCRAFT 685, L/P 5811421) EMERGENCY LIGHT AT 39D IS BROKEN. REPLACED EMERGENCY LIGHT HOUSING @ SEAT 39D. OPS CHECK GOOD. OK FOR SERVICE.SDR QXEA2019052800226Light · inoperativeFA REPORTS EXIT ROW LIGHTING STRIP NOT ILLUMINATING. REMOVED FROM SERVICE. R&R ED "EXIT ROW" (1 & 2A) LIGHTING STRIP IAW AMM 33-50-21-000-801-A & 33-50-21-400-801-A. OPS TEST GOOD, NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR AALA201905269005Battery · dischargedAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING JOBCARD 33C22033002, EMERGENCY LIGHT TEST CHECK FAILED EMERGENCY POWER SUPPLY UNIT, AISLE LIGHT. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38.SDR AALA20190525004Lens · crackedAIRCRAFT IN BASE MAINTENANCE: AFT MAIN CABIN LAVATORY 4F-RC, 4F-LC AND GALLEY 600 LEFTHAND AND RIGHTHAND SIDE WALL HAD SEVERAL EMERGENCY LIGHT LENS CRACKED. REPLACED FLOOR PROXIMITY LIGHT ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-058-9SDR R61A201905250550Power Unit · inoperativeCOCKPIT EMERGENCY LIGHT DOES NOT ILLUMINATE. R&R EMERGENCY LIGHT POWER UNIT IN FWD RT GALLEY BY R1 PANEL IAW AMM 33-50-01. OPS CHECK GOOD.SDR F3LA2019052800039Battery Pack · failedDISCREPANCY: REFERENCE LP1190568, L1 DOOR 10WL POWER SUPPLY FAILED EPSU TEST. CORECTIVE ACTION: REPLACED BATTERY PACK FOR L1 POWER SUPPLY, OPS TEST NORMAL. REF AMM 33-51-38 PB 401. /END/SDR SWAA2019060533324Lens · looseL/H EMERGENCY LIGHT LENS STOW BIN LOOSE AT ROW 12. R&R LENS IAW AMM.SDR I5EA2019053000035Light · inoperativeEMERGENCY LIGHT ABOUVE 13 DFE INOP. SUPPLEMENTAL INFORMATION: MEL CORRECTED BY RELAMPING SIGN.SDR ASAA2019052429511Cover · brokenFA ADV. LIGHT COVER BROKE OFF. GROUNDED - YES. REMOVED AND REPLACED FWD FA ADV. SIGN LIGHT ASSY IAW AMM 33-51-01-960-802. ALTERNATE DEACTIVATION APPLIED AND REVERSED IAW MPM 5-07-01, TABLE 3 ITEM 1. OPS CKS GOOD.SDR HNAA2019052900154Sign · inoperative628 33-51 0017630 24MAY19 RIC CLOSE EXIT SIGN ABOVE SERVICE DOOR DOES NOT ILLUMINATE 28916 00 BAD FACT 24MAY19 12:51 RIC R/R EXIT MARKING SIGN IN REF TO AMM 33-50-14-000/400-801-A. OPS CHECK GOOD. OK FOR SERVICE. P/N ON EXIT MARKER 1013834 P/NSDR SWAA2019052833121Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2019052833120Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2019052833119Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2019052833118Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR N6WA2019052401Light · inoperativeROW 4 EMERGENCY CEILING FLOODLIGHT INOP. DEFERRED FLOODLIGHT ON OCN 70056177 PER MEL 33-51-01A-2A. CAT C. AUTHORIZED BY MXC.SDR DALA2019052803278Lens · defectiveSHIP 5813 AFT LT OVERWING EXIT SIGN MISSING ARROW ON LENS COVER. CORRECTIVE ACTION: REF ERA 578483-14. R/R LENS LIGHT ASSY IAW AMM 33-52. (6304718)SDR SWAA2019052833059Light · inoperativeRT OVERWING EMERGENCY EXIT AIRCRAFT SIGN INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019052833039Battery Pack · failedRT FORWARD EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019052833038Battery Pack · failedLT AFT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019052833032Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2019052833022Cover · missingRT OVERWING EMERGENCY EXIT SIGN LIGHT COVER MISSING. R&R COVER PER MM.SDR JJBA20190524014Light · inoperativeLT EMERGENCY EXIT DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT. OPS CHECK SAT.SDR DALA2019052603182Light · inoperativeEPSU EXT LOAD EMER L MESSAGE ON EMERGENCY LIGHTS TEST, RELAMPED OVERWING LIGHTS.SDR MASA2019052411875Light · inoperativeROW 11 EMER CEILING FLOODLIGHT INOP. PLACED ON MEL.SDR DALA2019053003354Battery Pack · dischargedBOTH AFT SERVICE DOOR UPPER EXIT LIGHTS ARE INOPERATIVE. FOUND DEAD BATTERY PACK, REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR SWAA2019052933130Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY OPS CHECK AT M1668. R&R BATTERY PACK IAW AMM.SDR SWAA2019052933129Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY OPS CHECK AT M1673. R&R BATTERY PACK IAW AMM.SDR SWAA2019052933089Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY OPS CHECK AT M1675. R&R BATTERY PACK IAW AMM.SDR ASAA2019052329481Lens · detachedPLASTIC COVER OF "EXIT" SIGN BY DOOR L2 HAS FALLEN OFF. GROUNDED - YES. REPLACED LIGHT ASSY EMERGENCY EXIT OPS CK GOOD THIS ACTION CLEAR PLT DEFERRAL.SDR SWAA2019052833102Lens · missingCEILING AT OVERWING EXIT SIGN AFT LENS COVER MISSING. INSTALLED LENS PER MM.SDR DALA2019052403237Cover · detached(LOG 5500944) EMERG EXIT COVER DETACHED FROM SIGN. MAINENANCE SECURED LENS COVER.SDR DALA2019052403209Light · broken(LOG 1088276) DURING INSPECTION FOUND BROKEN GALLEY 2 EMERGENCY EXIT RED LIGHT AT FWD GALLEY AREA. REPLACED GALLEY 2 EMERGENCY EXIT RED LIGHT AT FWD GALLEY AREA AS PER AMM 33-51-01-960-802. OPERATIONAL TEST IS GOOD.SDR DALA2019052403208Light · broken(LOG 1088259) BROKEN GALLEY 1 EMERGENCY EXIT LIGHT BASE AT FWD GALLEY AREA. REPLACED GALLEY 1 EMERGENCY EXIT LIGHT BASE AT FWD AREA GALLEY AS PER AMM 33-51-01.SDR DALA2019052403207Lens · broken(LOG 1088248) DURING INSPECTION FOUND BROKEN EMERGENCY LIGHT LENS GALLEY 4 LT AND RT AT AFT GALLEY AREA. REPLACED EMERGENCY LIGHT LENS GALLEY 4 LT AND RT AT AFT GALLEY AREA AS PER AMM 33-51-01-960-802. OPERATIONAL TEST IS GOOD.SDR DALA2019052403187Epsu · inoperativeDURING CHECK, FOUND LEFT HAND SEAT EMERGENCY LIGHT AT 2, 3, 7, 8, 9, 10, 11, 15, 17, 21, 22, AND 23 WERE OUT. REPLACED EPSU AT DOOR 2L. LP 5649764SDR DALA2019052403186Power Supply · faultedDURING EPSU TEST, POWER SUPPLY 102WL2 FAULTED. REPLACED EPSU 102WL2. LP 5427697SDR AALA201905249002Battery · dischargedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS OPS CHECK OF THE EMERGENCY LIGHTING SYSTEM FAILED WHILE ACCOMPLISHING CARD 25-94-03. FAULTS BAT/EPSU 10WL FWD 3 BAT/ESPU 11WL EMER L REQS TROUBLESHOOTING. ACCOMPLISHED TSM 35-51-00-810-829-A AND TSM 35-51-00-810-855SDR AALA201905249004Battery · dischargedAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND INOP EPSU-EMERGENCY POWER SUPPLY UNIT 10WL AND 11WL BATTERY IN PASSENGER CABIN (2 EA). REPLACED EPSU-EMERGENCY POWER SUPPLY UNIT 10WL AND 11WL BATTERY IN PASSENGER CABIN (2EA) IAW AMM 33-51-38-400-002-A. PERFORMED OPESDR AALA201905249015Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND INOP EPSU-EMERGENCY POWER SUPPLY UNIT 10WL AND 11WL BATTERY IN PASSENGER CABIN (2 EA). REPLACED EPSU-EMERGENCY POWER SUPPLY UNIT 10WL AND 11WL BATTERY IN PASSENGER CABIN (2EA) IAW AMM 33-51-38-400-002-A. PERFORMED OPESDR AALA201905249006Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT MOUNTED ON SEAT 22D WAS BROKEN. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 22D PER AMM 33-51-19.SDR DALA2019052403178Sign · missingOVERWING EMERGENCY EXIT SIGNS MISSING. MAINTENANCE REPLACED THE EXIT SIGNS COVER. AIRCRAFT IS OK FOR SERVICE. (LP #4788928)SDR SWAA2019052432989Light · inoperativeSEVERAL EMERGENCY LIGHTS INOP THROUGHOUT THE CABIN. RELAMPED LIGHTS PER AMM.SDR SWAA2019052432988Lens · unsecureOVERHEAD AISLE EMERGENCY EXIT SIGN LENS FELL OFF. SECURED LENS PER MM.SDR N6WA2019052301Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 18 IS INOP. AS PER TELECOM MXC, DEFERRED OVERHEAD EMERGENCY LIGHT AT ROW 18 ON OCN 70056134 PER MEL33-51-01B CAT C.SDR R61A201905230536Sign · unsecureR2 EXIT SIGN LIGHT FELL OFF. R&R R2 EXIT SIGN LIGHT IAW AMM 33-50-15. OPS CHECK GOOD.SDR KCSA201905231133Light · inoperativeMULTIPLE EMERGENCY LIGHTS IN FWD UPPER DECK INOP.SDR QXEA2019052300217Unknown · malfunctionedEMERGENCY LIGHTS ARE ON WHEN FLIGHT DECK SWITCH IS IN THE ARM POSITION. REMOVED FROM SERVICE. CYCLED C/B'S LEFT CB PANEL E-3 & G-3. EMERGENCY LIGHTS OPERATE NORMALLY IN ALL SWITCH SETTINGS. AIRCRAFT RETURNED TO SERVICE.SDR MASA2019052211873Light · inoperativeGALLEY EMERG EXIT SIGN HAS 1 BULB INOP.
Back to JASC 3350