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 AALA201703099009Lens · looseAIRCRAFT WAS NOT GROUNDED. LOOSE PLASTIC COVER ON DOOR 4R WHITE SLIDE WARNING LIGHT. MAINTENANCE REATTACHED DOOR 4R LIGHT LENS COVER PER 52-73-00.SDR DALA2017030800090Lens · missingDOOR 3R EMERGENCY FLOOR LIGHT (CLEAR LENS) MISSING AND ASSEMBLY CRACKED. REPLACED LIGHT ASSEMBLY AT DOOR 3R.SDR DALA2017030801911Light · intermittentEMERGENCY LIGHTS FLICKERING. T/S PER FIM 33-51-00-815-802 AND WDM 33-51-12. REPLACED M731 OPS AND TEST OK PER AMM 33-51.SDR DALA2017030901908Sign · missingOVERWING EMERGENCY EXIT SIGN MISSING. LOCATED EXIT SIGN COVER AND INSTALLED.SDR DALA2017030801907Fuse · blownEMERGENCY LIGHTS AT SEAT ROWS 33-37 INOP. REPLACED FUSES AT BP M11648 PER AMM 33-51. CKS OK.SDR AALA201703089010Lens · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT COVER BROKEN. REPLACED EMERGENCY EXIT COVER AS REQUIRED.SDR N6WA2017030702Light · inoperativeEMERGENCY LIGHT IN CEILING ABOVE ROW 4 BURNED OUT.SDR ASAA2017030720077Battery Pack · failedWHILE PERFORMING T/C 78233001, FOUND THE L2 DOOR BATTERY PACK FAULTY AS WELL AS BOTH LEFT AND RIGHT AFT OVERWING EXIT BATTERY PACKS FAULTY. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805. OPS CHECKED OK.SDR DALA2017030901904Light · malfunctionedAFT EMERGENCY LIGHTS ILLUMINATED WITH POWER REMOVED FROM ACFT. PERFORMED EMERGENCY LIGHT CHECK IAW AMM 33-53. RECYCLED ARM SWITCH WITH POWER OFF, OPS CHECKED GOOD.SDR SWAA2017030912419Light · inoperativeLT EMERGENCY EXIT SIGN LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2017030912418Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR DALA2017030801901Light · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHT CENTER FORWARD GALLEY INOPERATIVE. MAINTENANCE REMOVED LIGHT ASSY L108 AND INSTALLED A NEW LIGHT ASSY IAW AMM 33-51.SDR AALA201703089003Lens · missingSEAT ROW 5ABC EMERGENCY LIGHT LENS COVER MISSING. REMOVED AND REPLACED SEAT ROW 5ABC EMERGENCY LIGHT LENS.SDR AALA201703089002Lens · missingCOVER MISSING FROM R2 DOOR EMERGENCY LIGHT. INSTALLED A NEW COVER.SDR AALA201703089006Lens · missingAFT L, DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR IPXA2017030714826Light · inoperativeEMER LIGHT FOR LAV IS BURNT OUT REMOVED AND REPLACED BULB PER MIM 33-51-00 OPS CHECK GOOD. ESR: IPC 33-51-21-02SDR DALA2017030801886Light · damagedFLOOR EMERGENCY LIGHT DAMAGED. THE EMERGENCY LIGHT WAS REPAIRED IAW AMM 33-51.SDR DALA2017030801885Lens · unsecureEMERGENCY EXIT SIGN LENS LOOSE. SECURED THE LENS AND CHECKED OK IAW AMM 33-51.SDR MASA2017030712649Light · inoperativeEMERGENCY LIGHTS IN FRONT OF COAT CLOSET INOPERATIVE.SDR SIMA20170307002Charger · failedEMERGENCY LIGHTS FOR SERVCIE DOOR, SEAT 3B, EXIT SIGN, AND FLOOR ROW 3 TO 7 INOPERATIVE. R & R THE NR 2 EMERGENCY LIGHT BATTERY AND CHARGER IAW W/C 33-700-19, OPS CHECKED GOOD.SDR DALA2017030801878Socket · damagedEMERGENCY LIGHT INOPERATIVE IN CEILING JUST AFT OF AFT CABIN DOOR. FOUND THE SOCKET DAMAGED. REPAIRED THE SOCKET. LIGHT OPS NORMAL. 6)SDR A6WA2017030844838Light · inoperativeFLOOR EMERGENCY LIGHTS DO NOT ILLUMINATE BEYOND ROW 8. ADJUSTED THE LIGHT, OPS CHECKED GOOD IAW AMM 33-50-00SDR DALA2017030701854Switch · failedL1 AND R1 DOOR EMERGENCY LIGHTS FLICKERING. TROUBLESHOT IAW WDM, FOUND EMERGENCY LIGHT SWITCH ON P-5 PANEL FAILED. REPLACEDD THE SWITCH IAW AMM 33-51. OP CHECKED GOOD.SDR AALA201703099040Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L1 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA201703099037Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS AT SEATS 25H TO 29H ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK M00732. OPERATIONAL CHECK GOOD.SDR DALA2017031001936Mount · damaged4C FORWARD SEAT MOUNTED EMERGENCY LIGHT IS HANGING FREELY. REPAIRED MOUNT AND SECURED EMERGENCY LIGHT.SDR REXA2017030600329Light · inoperativeRIGHT 2 CONSECUTIVE EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE EMERGENCY LIGHTS.SDR DALA2017030701919Battery Pack · inoperativeOVERWING EMERGENCY LIGHT BATTERY PACK INOPERATIVE.SDR AALA201703099007Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT TEST FAILS AT FORWARD 10WL, BATTERY PACK. REPLACED BATTERY PACK AMM 33-51-06.SDR DALA2017030701910Sign · missingBACK SIDE OF CENTER AISLE OVERHEAD "EXIT SIGN MISSING BY ROW 38. REPLACED MISSING OVERHEAD EXIT SIGN AT ROW 38.SDR SWAA2017030912423Cover · looseFORWARD EMERGENCY EXIT LIGHT COVER LOOSE. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017030912422Cover · unsecureL1 DOOR EXIT LIGHT COVER CAME OFF. SECURED COVER IAW SIP.SDR SWAA2017030912415Cover · looseL1 DOOR EMERGENCY EXIT LIGHT COVER LOOSE. SECURED THE COVER IAW AMM.SDR AALA201703079025Lens · brokenROW 22C SEAT MOUNTED EMERGENCY LIGHT HAS A BROKEN LENS. REPLACED THE EMERGENCY LIGHT.SDR AALA201703079023Lens · missingR2 DOOR LOWER EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR DALA2017030701887Lens · damagedEMERGENCY EXIT DIFFUSER LENS DAMAGED. INSTALLED A NEW LENS.SDR DALA2017030801883Lamp · inoperativeTHE EMERGENCY LIGHT AT 10B INOPERATIVE AND LENS MISSING. REPLACED THE LAMPED AND LENS.SDR SWAA2017030812411Lamp · inoperativeL2 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017030812404Lens · missingAFT CENTER OVERHEAD EXIT SIGN LENS MISSING AT ROW 23. INSTALLED THE LENS IAW SOPM.SDR SWAA2017030812393Light · looseAFT AISLE EMERGENCY FLOOD LIGHT LOOSE. SECURED THE LIGHT IAW AMM.SDR ASAA2017030620036Lens · brokenEMERGENCY LIGHT EXIT SIGN TO THE L2 DOOR IS BROKEN. ACFT GROUNDED. REMOVED, REPLACED, AND TESTED THE SIGN IAW AMM 33-51-01-960-802. OPS NORMAL.SDR REXA2017030600323Lamp · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-00, OPS TESTED NORMAL.SDR DALA2017030701861Circuit Board · burnedOVERWING EMERGENCY LIGHT BATTERY POWER SUPPLY CIRCUIT BOARD BURNT. REPLACED OVERWING EMERGENCY LIGHT BATTERY POWER SUPPLY PER AMM 33-51-03 OPS CHECK GOOD. AC OK FOR SERVICE.SDR DALA2017030701852Lens · missingEMERGENCY EXIT IDENTIFIER AT CEILING BETWEEN OVERWING EMERGENCY EXIT FWD LENS MISSING. INSTALLED THE LENS. OK FOR SERVICE.SDR DALA2017030701851Lens · missingMISSING EMERGENCY LIGHT LENS AT L2 ENTRY. REPLACED THE LENS, CHECKED GOOD IAW AMM 33-51-10. OK FOR SERVICE.SDR YENA201703060162Battery · no testEMERGENCY LIGHT BATTERY 13WL FAILED TEST. REMOVED AND REPLACED THE BATTERY. OPS CHECKED GOOD.SDR YENA201703060160Battery Pack · no testEMERGENCY LIGHT FAILS TO TEST. EMERGENCY LIGHTS FAILED THE BATTERY TEST AT 10WL, 11WL, AND 12WL R & R THE BATTERY PACKS LIGHT. OPS CHECKED GOOD IAW AMM 33-51-38.SDR YENA201703060159Battery Pack · no testEMERGENCY LIGHT FAILS TO TEST. EMERGENCY LIGHT FAILED THE BATTERY TEST AT 10WL, 11WL, AND 12WL . R & R THE BATTERY PACKS, LIGHT OPS CHECKED GOOD IAW AMM 33-51-38.SDR YENA201703060161Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. FAILED THE BATTERY TEST AT 10WL, 11WL, AND 12WL. R & R THE BATTERY PACKS, LIGHT OPS CHECKED GOOD IAW AMM 33-51-38.SDR N6WA2017030601Light · inoperativeOVERHEAD EMERGENCY LIGHT NOT WORKING AT ROW 15.
Back to JASC 3350