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 YENA2018120610809Battery Pack · no testFT # 225, JFK-TPA. FAILED EMERG LIGHT TEST; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES AT 11WL, 12WL & 13WL PER AMM 33-51-38. P/N OFF/ON 3214-31 S/N OFF094878 ON 831693. P/N OFF/ON 3214-31 S/N OFF 094867 ON 805202. P/N OFF/ON 3214-31 S/N OFF 094868 ON 9SDR YENA2018120610808Battery Pack · no testFT # 225, JFK-TPA. FAILED EMERG LIGHT TEST; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES AT 11WL, 12WL & 13WL PER AMM 33-51-38. P/N OFF/ON 3214-31 S/N OFF094878 ON 831693. P/N OFF/ON 3214-31 S/N OFF 094867 ON 805202. P/N OFF/ON 3214-31 S/N OFF 094868 ON 9SDR YENA2018120610807Battery Pack · no testFT # 225, JFK-TPA. FAILED EMERG LIGHT TEST; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES AT 11WL, 12WL & 13WL PER AMM 33-51-38. P/N OFF/ON 3214-31 S/N OFF094878 ON 831693. P/N OFF/ON 3214-31 S/N OFF 094867 ON 805202. P/N OFF/ON 3214-31 S/N OFF 094868 ON 9SDR REXA2018120101176Light · inoperativeNR 3 CEILING EMERGENCY FLOOD LIGHT INOP. R&R NR 3 CEILING EMERGENCY FLOOD LIGHT BULB IAW AMM 33-51-16. OPS CK'S GOOD. OK FOR SERVICE.SDR SWAA2018120427307Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK M1674 FAILED TO ILLUMINATE. R&R BATTERY PACK IAW AMM.SDR SWAA2018120427282Fuse · blownR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R FUSE PER SIP.SDR IPXA2018120536517Lamp · inoperativeEXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMPS IAW M/M 33-51-16-962-001, OPS NORMAL.SDR ASOA201812051323Battery Pack · dischargedDURING MX INSPECTION THE FIRST 3 SETS OF INTERIOR EMERGENCY LIGHTS AND RH LOWER EXTERIOR EMERGENCY LIGHT TURNS ON AND FADES OFF. MX REMOVED AND REPLACED #2 EMERGENCY BATTERY WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2018120307033Battery Pack · dischargedOVERHEAD EMERGENCY EXIT SIGN AT ROW 17 DOES NOT SHUT OFF. REPLACED BATTERY PACK M737. SYSTEM OPERATION IS NORMAL.SDR AALA201812049029Battery · no testEMERGENCY LIGHT POWER SUPPLY 10WL DOES NOT PASS A TEST DUE TO A BATTERY FAULT. REPLACED THE BATTERY IAW AMM 33-51-38-400-002-A.SDR AALA201812049037Battery Pack · inoperativeTHE R2 DOOR FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY WAS INOPERATIVE. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY PACK AND SEAL IAW AMM 25-64-00, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201812049036Cover · brokenEMERGENCY LIGHT COVER WAS BROKEN AT THE L1 DOOR. MAINTENANCE REPLACED THE LIGHT COVER AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR HALA2018120300623Light · unsecureFIRST CLASS FLOOR PATH LIGHT(AIRCRAFT LEFT) LOOSE.// RE-SECURED FIRST CLASS PATH LIGHT COVER. GOOD FOR SERVICE.SDR AALA201812039036Charger · inoperativeSEAT EMERGENCY LIGHTS IN THE AFT LEFT CABIN WERE INOPERATIVE. FOUND NO OUTPUT FROM THE CHARGER. REPLACED THE CHARGER.SDR AALA201812039033Power Supply · faultyBITE CIDS FAULTS FOR THE EMERGENCY POWER SUPPLY UNITS 15WL &14WL. REPLACED THE POWER SUPPLY 15WL IAW AMM 33-51-38.SDR AALA201812039030Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT THE LOWER LEFT OF THE L1 DOOR. INSTALLED A NEW LENS IAW AMM 33-50-00.SDR AALA201812032001Battery · no testSEAT AISLE LIGHTS IN AFT LEFT CABIN WERE INOPERATIVE. FOUND NO OUTPUT FROM THE CHARGER. REPLACED BOTH THE BATTERY AND CHARGER,SDR IPXA2018120396517Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM 33-51-16-962-001, OPS NORMAL.SDR DALA2018120316963Lamp · inoperativeL1 & R1 DOOR EMERGENCY LIGHTS INOP. RELAMPED EMERGENCY LIGHTS AT L1 & R1 DOOR PER MD88 33-51 OPS CK NML. (LP5037658)SDR DALA2018120316962Battery Pack · inoperativeAFT OVERWING OVERHEAD EXIT LIGHTS INOP. REMOVED AND REPLACED AFT OVERWING EMERGENCY LIGHT BATTERIES PER MD88 AMM 33-53 CKS GOOD. (LP4808226)SDR SIMA201812031003Lamp · inoperativeEMERGENCY AREA LIGHT AT EXIT ROW INOP-C/A-REMOVED AND REPLACED EMERGENCY AREA LIGHT AT EXIT ROW LIGHT BULB IAW EMB 145 AMM 33-50-08 OPS CHECK GOODSDR SIMA201812031004Light · inoperativeEMERGENCY LIGHT ABOVE FA SEAT FOUND TO BE INOP DURING PS2 CHECK-C/A-REMOVED AND REPLACED PANEL SIGN ASSEMBLY OF FWD EXIT SIGN IAW EMB140 AMM 33-50-14. OPC FAIL. ITEM REQUIRES FURTHER T/S. REMOVED AND REPLACED INVERTER FROM FWD CABIN CLOSET IAW EMB140 AMM 33-5SDR SWAA2018120427352Lens · unsecureMID CABIN CEILING EMERGENCY EXIT SIGN FELL OUT. SECURED LENS PER SIP.SDR SWAA2018120427337Light · inoperativeAFT ENTRY DOOR EXTERNAL EMERGENCY EGRESS LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018120427285Cover · missingR2 DOOR EMERGENCY EXIT LIGHTS "EXIT" COVER MISSING. R&R LAV LIGHT ASSEMBLY PER MM.SDR SWAA2018120427283Sign · missingFORWARD GALLEY EMERGENCY EXIT SIGN MISSING. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2018120537041Lens · missing(AIRCRAFT 7101, L/P 5252439) 1L DOOR EXIT LIGHT COVER MISSING. LOCATED LIGHT COVER & REFITTED, SATISFACTORY.SDR DALA2018120537040Lens · damaged(AIRCRAFT 7105, L/P 0846154) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:604 / INTERIOR. INSTALLED LENS OPS CHECK GOOD.SDR AALA201812049034Lens · brokenBROKEN EMERGENCY LIGHT LENS RIGHT SIDE IN THE PASSENGER CABIN. REPLACED THE LENS IAW AMM 33-51-16-400-001-A, STEP 4, ITEM B(5).SDR AALA201812041004Fuse · blownEXTERIOR LOWER RIGHT EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE FUSE IN THE POWER SUPPLY M01671, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA2018120430010Fuse · blownTWO INTERIOR OVERWING EXIT EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE FOUND TWO BLOWN FUSES IN THE POWER SUPPLY M01695 AND ONE BLOWN FUSE IN POWER SUPPLY M01694. MAINTENANCE REPLACED THE FUSES AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA2018120430009Fuse · blownTWO INTERIOR OVERWING EXIT EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE FOUND TWO BLOWN FUSES IN THE POWER SUPPLY M01695 AND ONE BLOWN FUSE IN POWER SUPPLY M01694. MAINTENANCE REPLACED THE FUSES AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201812041002Light · crackedG4 GALLEY RIGHT EMERGENCY LIGHT ASSEMBLY WAS CRACKED. REPLACED THE RIGHT EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20181130007Charger · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY AISLE LIGHTS ARE INOPERABLE FROM ROW 22 TO AFT SEAT. REPLACED BATTERY CHARGER MODULE PER AMM 33-53-00. OPERATIONS CHECKED GOOD.SDR SWAA2018113027262Battery Pack · failedLT OVER WING EMERGENCY EXIT LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2018113027252Lens · brokenRT OVERWING EMERGENCY EXIT LOWER LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2018113027251Light · inoperativeR2 DOOR EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2018113027250Sign · unsecureL1 DOOR LAV EMERGENCY EXIT SIGN FELL OFF. R&R SIGN PER AMM.SDR SWAA2018113027244Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT PER MM.SDR AALA201812039032Power Supply · faultyBITE CIDS FAULTS FOR THE EMERGENCY POWER SUPPLY UNITS 15WL &14WL. REPLACED THE POWER SUPPLY 14WL IAW AMM 33-51-38.SDR AALA201812031001Light · inoperativeCEILING EMERGENCY LIGHT OVERWING EXITS FOUND INOPERATIVE DURING BASE MAINTENANCE TESTING. REPLACED THE LIGHT ASSEMBELY. CHECKED GOOD.SDR DALA2018120326996Light · brokenEMERGENCY LIGHT AT 20E CONNECTED TO AISLE SEAT IS BROKEN, RE SECURED LIGHT LENS TO SEATSDR DALA2018120306991Lens · detachedSHIP 675 MID DOOR EXIT LIGHT COVER FELL OFF. CORRECTIVE ACTION: REINSTALLED LIGHT COVERS. (4593733)SDR DALA2018120316986Lens · damaged(LOG 0846850) DURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. REPLACED LENSES AS REQ'D. OPS NORMAL.SDR SIMA201812030002Charger · inoperativeLAST 3 EMERGENCY LIGHT STRIPS INOP-C/A-REMOVED AND REPLACED #4 BATT AND CHARGER AND #6 INVERTER IAW EMB 140 AMM 33-50-11 AND W/C 33-700-19. OPS CHK GOOD. INVERTER P/N 7824-1 (6), EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 104958SDR SIMA201812030001Battery · inoperativeEMERGENCY EXIT SIGN AT FLIGHT ATT SEAT INOP-C/A-T/S WM 33-50-50 FOUND #1 EMERGENCY BATTERY AND CHARGER TO BE BAD REMOVED AND REPLACED IAW W/C 33-700-19 OPC GOOD NO DEFECTS NOTED AT THIS TIME END. BATTERY CHARGER ASSY P/N 11-0049 S/N 13658SDR CALA2018120202487Light · inoperativeRT AFT OVERWING EMERGENCY LIGHT INOP. RELAMPED, OPS CHECK OK. ACP IDT INSP OF RT AFT OW EPL LIGHT RELAMP REF GMM 09-10-05. OPS CK GOOD.SDR CALA2018120202486Light · detachedSEAT 1D EMERGENCY LIGHT ASSY DETACHED FROM STRUCTURE. WILL REQUIRE NEW LENS COVER OR POSSIBLY LIGHT ASSEMBLY. REMOVED AND REPLACED EMERGENCY LIGHT ASSY PER AMM 33-51-10 ON SEAT 1D. OPS TEST NOW NORMAL ACPD IDT INSPECTION REF GMM 09-25-05 AND AMM 33-51-10 AND ASDR CALA2018120202485Light · inoperativeLT AFT OVERWING EMERGENCY LIGHT INOP. RELAMPED OPS CHECK OK ACP IDT INSP OF EPL LIGHT AT L AFT OW REF GMM 09-10-05. OPS CK GOOD.SDR CALA2018120202484Light · dimSEAT 21D EMERGENCY LIGHT IS VERY DIM. NOT ACCEPTABLE WILL REQUIRE NEW LENS COVER ASSEMBLY AND POSSIBLY LIGHT ASSEMBLY. DEFERRED DUE NIL PARTS MEL 3351C APPROVED. REPLACED 21D ESCAPE PATH LIGHT ASSY REF AMM 33-51-10 AND OPS CHECKED OK. INSPECTION CARRIED OUT AS
Back to JASC 3350