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 SIMA20190506001Flashlight · inoperativeF/A FLASHLIGHT DOESN'T WORK. C/A-FWD FLIGHT ATTENDANT FLASHLIGHT REPLACED WORKING NORMAL AMM25-60-00.SDR AALA20190506002Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING FAILED TIMING TEST. REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019050832430Sign · looseFORWARD ENTRY DOOR EXIT LIGHT SIGN PLACARD LENS LOOSE. R&R SIGN PER AMM.SDR UIEA2019050704147Light · inoperativeM/D DOOR EMERGENCY LIGHT 2 EA FOUND INOP.(<P>M/D DOOR EMERGENCY LIGHT 2 EA REMOVED AND REPLACED. TESTED NORMAL IAW AMM 33-51-07.</P>)SDR MASA2019050511842Light · inoperativeROW 12DF EMERG EXIT SIGN ONE BULB INOP. RELAMPED.SDR AALA201905069016Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EPSU BATTERY FAULT AFTER OPERATIONS TEST OF THE ESCAPE FACILITIES PER JOBCARD 26L000025011. MAINTENANCE REPLACED BATTERY PER 33-51-38-000-001-A.SDR AALA201905069010Battery · faultyAIRCRAFT WAS NOT GROUNDED: REMOVED MEGAPHONE FOR TROUBLESHOOTING. MAINTENANCE INSTALLED SAME MEGAPHONE WITH NEW BATTERIES REPLACED BY STANDARD MAINTENANCE PRACTICES.SDR SWAA2019050632389Battery Pack · dischargedR1 DOOR EMERGENCY EXIT SIGN INOP. R&R BATTERY PACK M2816 IAW AMM.SDR SWAA2019050632382Light · defectiveROW SIDEWALL LIGHT ON RT SIDE OVERWING EMERGENCY EXIT FLICKERING. RELAMPED LIGHT PER AMM.SDR SWAA2019050632318Lens · missingL1 DOOR LOWER EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS PER EA.SDR IPXA2019050541772Battery · dischargedINSPECTION TYPE:N/A LVL 1 :EMER LT BAT 2 LO" ILLUMINATED AFTER AMER LT TEST. REPLACED EMERGENCY LIGHTS BATTERY REF AMM 33-51-01OPS NML ESR 33-51-10-01-005.SDR IPXA2019050541764Battery · dischargedINSPECTION TYPE:C3 UPPER DECK EMERGENCY LIGHT L1853, L1854 AND L5735 INOP IAW AMM 33-51-04-902-001-001 REV 95.03 RPL EMERGENCY LIGHT BATTERY (M5170), AND PERFORMED EMERGENCY LIGHT TEST, RESULT WAS SATISFACTORY.SDR IPXA2019050541763Battery · dischargedINSPECTION TYPE:C3 UPPER DECK EMERGENCY LIGHT L1382 AND L5734 INOP IAW AMM 33-51-04-902-001-001 REV 95.03 RPL EMERGENCY LIGHT BATTERY (M5055), AND PERFORMED EMERGENCY LIGHT TEST, RESULT WAS SATISFACTORY.SDR SWAA2019051432676Lens · missingRT EMERGENCY EXIT LIGHT LENS COVER MISSING AT ROW 6. INSTALLED LENS IAW AMM.SDR SWAA2019051432619Light · looseRT EMERGENCY EXIT INSIDE OVERHEAD BIN BULB ASSEMBLY LOOSE. SECURED LIGHT IAW AMM.SDR ASOA201905025067Battery · dischargedDURING MX INSPECTION THE AISLE EMERGENCY LIGHT STRIPS WERE OUT AFT OF OVERWING EXITS. REMOVED AND REPLACED NR 4 BATTERY IAW AMM 33-50-04 AND IPC 33-50-04 FIG 10 ITEM 50 OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR JJBA20190504005Contactor · looseSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R SERVICE DOOR EXT EMERGENCY LIGHT. OPS CHECK FAILED. AFTER FURTHER TROUBLESHOOTING FOUND CONTACTOR ON THE LIGHT ASSY LOOSE. LIGHT ASSY REQUIRES REPLACEMENT. REMOVED LIGHT ASSY TO FOM. REPLACED SERVICE DOOR SDR DALA2019050602906Lens · unknownSHIP 693 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. CORRECTIVE ACTION: REPLACED 1 EACH 2R EMERGENCY LIGHT LENS ASSY REF MM 33-50 CKS OK. (1059338)SDR DALA2019050602903Light · brokenSHIP 6713 EMERGENCY PATH LIGHT AT ROW 22 BROKEN. CORRECTIVE ACTION: REPLACED EMERGENCY PATH LIGHT ASSY. OPS CK GOOD. (5829548)SDR SWAA2019050732364Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK M1670 INOP. R&R BATTERY PACK PER AMM.SDR REXA2019050400615Battery Pack · dischargedEMERGENCY LIGHT STRIP LIGHT FROM ROW 6CD TO 8CD ARE ILLUMINATING. REMOVED AND REPLACED BATTERY PACK 3 AND BATTERY PACK 3 INVERTER (INVERTER FIX PROBLEM IAW AMM 33-51-04 AND AMM 33-51-07.SDR REXA2019050400614Light · inoperativeDURING WALK AROUND FOUND OUTSIDE FWD EMERGENCY EXIT LIGHT NOT WORKING. R/R OUTSIDE EXTERNAL FWD RT EMERGENCY LIGHT IAW AMM 33-51-21. OPS CHECK GOOD.SDR PNSA2019050401Light · looseEMERGENCY TRACK LIGHTING LOOSE AT 10A, RE-ATTACHED EMERGENCY TRACK LIGHTING.SDR AALA20190505003Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFTHAND CENTER LIGHT INOPERABLE. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER STANDARD PRACTICES.SDR SWAA2019050632410Battery Pack · dischargedLT EMERGENCY LIGHTS INOP BETWEEN ROW 4 TO ROW 6. R&R BATTERY PACK IAW AMM.SDR SWAA2019050632381Power Supply · inoperativeLT EMERGENCY LIGHTS INOP BETWEEN ROW 4 TO ROW 6. R&R POWER SUPPLY IAW AMM.SDR SWAA2019050632329Sign · brokenLT OVERWING EMERGENCY EXIT SIGN BROKEN. INSTALLED SIGN IAW AMM.SDR SWAA2019050632328Light · inoperativeLT DOOR OVERWING EMERGENCY EXIT SIGN LIGHT BULBS INOP. RELAMPED BULBS IAW AMM.SDR DALA2019050602835Lens · missing(LOG 5476563) DURING INSPECTION FOUND RED EMERGENCY PATH LIGHT LENS COVER IN ISLE OPPOSITE 1ST CLASS LAV, MISSING. REPLACED LENS OK FOR SERVICE.SDR SIMA20190504002Light · out of adjustEMERGENCY EXIT LIGHT ON RT SIDE FIRST ROW NOT WORKING. C/A-EMERGENCY EXIT LIGHT ON RT SIDE FIRST ROW ADJUSTED IAW AMM 33-50-00. OPC GOOD.SDR QXEA2019050600206Light · looseEMERGENCY FLOOR STRIP LIGHTING LIFTING AT 2D/E. REMOVED FROM SERVICE. RESECURED FLOOR STRIP LIGHTING AT 2D/E. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR F3LA2019050600035Battery · failedDISCREPANCY: REFERENCE LOG PAGE LP1111414 ITEM 1, EMERGENCY BATTERY UNITS FAILED BITE TEST AT FIN #10WL AND 13WL.
CORRECTIVE ACTION: REFERENCE LOG PAGE LP1111414 ITEM 1(LAS), PLACED ON MEL 33-50-09A, CONTROL NUMBER 1149938, DUE 5-14-19.
CORRECTIVE ACTION: RESDR JJBA20190504004Light · inoperativeEXTERNAL SERVICE DOOR EMERGENCY LIGHT INOPERATIVE. R&R LIGHT BULB ON SERVICE DOOR EXTERIOR EMERGENCY LIGHT. LIGHT WORK INTERMITTENTLY. R&R EXTERIOR SERVICE DOOR EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR MASA2019050411840Battery Pack · dischargedFWD GALLEY EMERG LIGHT INOP. REPLACED NR 1 EMERG BATTERY PACK.SDR SWAA2019061923938Wire · damagedRIGHT OVERWING EXIT LIGHT WIRE W4142-0213-20 DAMAGED. REPAIRED WIRE PER WDM.SDR SWAA2019050732327Cover · unsecureRT OVERWING EMERGENCY EXIT SIGN AT DOOR EDGE FELL OFF. REINSTALLED COVER IAW SIP.SDR N6WA2019050301Light · inoperativeCABIN CEILING EMERGENCY LIGHT AT ROW 4 INOP. AS PER TELECON WITH MXC DEFERRED CABIN FLOODLIGHT ON OCN 70055147 PER MEL 33-51-01B-2A. CAT C.SDR AALA201905049012Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS SEATS EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA201905049010Power Supply · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY FAILURE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY PER AMM 33-51-38-400-002.SDR AALA201905049008Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: INOPERABLE EMERGENCY POWER SUPPLY UNIT 14WL IN PASSENGER CABIN. REPLACED EPSU AND PERFORMED BITE TEST PER AMM 33-51-38-400-001-A.SDR SWAA2019050632408Lens · brokenAFT GALLEY LT SIDE EXIT SIGN LENS BROKEN. R&R LENS PER AMM.SDR SWAA2019050632403Fuse · blownAFT GALLEY EMERGENCY EXIT SIGN INOP. R&R POWER SUPPLY FUSE PER AMM.SDR SWAA2019050632402Fuse · blownOVER L2 DOOR EXIT SIGN INOP. R&R POWER SUPPLY FUSE PER AMM.SDR SWAA2019050632387Lens · unsecureAFT "EXIT/SALIDA" SIGN LENSES AT MID-CABIN FELL DOWN. SECURED AFT LENS COVER PER SIP.SDR SWAA2019050632321Guard · faultyEMERGENCY EXIT LIGHTS SWITCH GUARD WON'T STAY DOWN. R&R SWITCH GUARD IAW SIP.SDR IPXA2019050341696Relay · faultyINSPECTION TYPE:N/A EMERG EXIT LIGHT DID NOT ILLUMINATE W/GEAR EXTENSION. FLICKERED ON TAXI. R/R RELAY 69 WL IAW ESPM 20-46-50. OPS CK GOOD IAW MM 33-51-00. THIS CLEARS M669081.SDR IPXA2019050441731Light · inoperativeINSPECTION TYPE:N/A EMERGENCY LIGHT HAS THREE INOP BULBS. RELAMPED EMERGENCY LIGHT THREE BULBS PER AMM 33-51-01-1.SDR DALA2019050302819Power Supply · inoperativeTHE RIGHT & LEFT AFT OVERWING EMERGENCY EXIT IDENTIFIERS L2-837, L2-836 WERE FOUND TO BE INOPERATIVE. MAINTENANCE FOUND THAT THERE WAS NOT ANY POWER AT PIN 9 ON THE POWER SUPPLY B5-119. THE POWER SUPPLY WAS REPLACED PER AMM 33-51-03 400-802. CHECK WAS GOOD. (LSDR DALA2019050302818Light · inoperativeTHE EMERGENCY LIGHTS L2-786, L2-771, AND L2-772 ARE INOPERATIVE. MAINTENANCE FOUND THE GROUNDS 5238D AND 5239D TO BE LOOSE. THE GROUNDS WERE RE-INSTALLED PER WDM 33-51-12 AND ALL CHECKS WERE GOOD. (LP #5691118)SDR SIMA20190503001Battery · dischargedDURING PS-2 FOUND LH EXT EMERGENCY LIGHT BURNED OUT. C/A-REMOVED AND REPLACED LT FWD EXT EMERGENCY LIGHT ASSY IAW 33-50-10. EMERGENCY LIGHTS OPS CHECK GOOD IAW AMM 33-50-00. EMERGENCY LIGHTING BATTERY NR 4 P/N 2013-1A S/N 103874 AND 79164, NR 1 109569. BATTER
Back to JASC 3350