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 REXA2018061900532Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED LIGHT BULB IN SERVICE DOOR EMERGENCY ASSY IAW AMM 33-51-21. OPS CHECK GOOD P/N OFF/ON 1317.SDR DALA2018062204161Light · inoperativeBOTH AFT LEFT AND RIGHT OVERWING EMERGENCY EXIT HANDLE LIGHTS INOPERATIVE. RELAMPED. OPERATION CHECKS GOOD.SDR C77A2018062100002Fuse · damagedCOCKPIT EMERGENCY CEILING LIGHT INOPERATIVE. REPLACED DAMAGED FUSE IN THE R1 ELPU SPOT F2 IAW SMPE17X-33-02. OPS CHECK GOOD.SDR AALA201806219014Cover · missingSEAT 20ABC EMERGENCY LIGHT COVER MISSING. INSTALLED THE EMERGENCY LIGHT COVER IAW MM 33-51-19. OPS CHECKED GOOD.SDR DALA201806214122Light · inoperativeSEAT 1B MOUNTED EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE EMERGENCY LIGHT.SDR SWAA2018062122946Cover · missingL2 EXIT DOOR LIGHT COVER MISSING. INSTALLED COVER IAW AMM.SDR SIMA20180619001Charger · inoperativeAFT CABIN EMERGENCY LIGHT FLOOR PANEL INOP. REMOVED AND INSTALLED NR 4 CHARGE AND BATTERY, IAW EMERGENCY LIGHTING SYSTEM POWER SUPPLIES WORKCARD 33-700-19, OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 83000SDR DALA2018062004082Lens · damagedEMERGENCY LIGHT LENS WAS DAMAGED. R & R EMERGENCY LIGHT LENS.SDR SWAA2018062022937Light · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R LIGHT PER DWG.SDR SWAA2018062022922Light · inoperativeEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R LIGHT PER DWG.SDR SWAA2018062022919Light · inoperativeRT OVERWING EMERGENCY EXIT AFT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201806209003Lens · missingEMERGENCY LIGHT LENS MISSING, ROW 1. REPLACED THE LENS.SDR HNAA2018062000125Light · inoperativeLOWER EMERGENCY LIGHT WON'T ILLUMINATE AT THE SERVICE DOOR AREA. R & R LOWER THE EMERGENCY LIGHT IAW AMM 33-50-13-000/400-801-A, OK FOR SERVICE.SDR HNAA2018062000124Wire · not seatedEMERGENCY LIGHT STRIP AT ROW 1 WOULD NOT ILLUMINATE. SEATED THE WIRES IN THE LIGHT. OK FOR SERVICE.SDR MASA2018062093332Battery Pack · inoperativeROWS 1-11 OVERHEAD EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED THE NR 2 EMERGGENCY BATTERY PACKSDR QXEA2018061900228Battery Pack · inoperativeWHILE PERFORMING AN OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM. FOUND THE AFT TWO CEILING LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS. OPS CHECK GOOD.SDR QXEA2018061900226Light · deterioratedEMERGENCY FLOOR -PATH -LIGHT ASSY BY COCKPIT DOOR IS DETERIORATED. REMOVED FROM SERVICE. REMOVED AND REPLACED EMERGENCY FLOOR-PATH-LIGHT ASSY REF Q400 AMM TASK 33-51-16-000-801 AND 33-51-16-400-801. AIRCRAFT RETURNED TO SERVICE.SDR DALA2018061904157Lamp · inoperativeDURING SERVICE CHECK, LLCR AREA AND STAIR EXIT IDENTIFIER SIGNS INOPERATIVE. ALL LAMPS REPLACED AND SYSTEM OPS NORMAL.SDR CALA2018062211493Battery Pack · dischargedR2 DOOR EMERGENCY LIGHT BATTERY PACK M33097 WAS FOUND TO HAVE LOW CAPACITY. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018062211492Battery Pack · dischargedL2 DOOR EMERGENCY LIGHT BATTERY PACK M33096 WAS FOUND TO HAVE LOW CAPACITY. THE BATTERY PACK M33096 WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018062211491Battery · dischargedR4 DOOR EMERGENCY LIGHT BATTERY PACK M33408 WAS FOUND TO HAVE LOW CAPACITY. THE BATTERY PACK M33408 REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018062211490Battery · dischargedR2 DOOR EMERGENCY LIGHT BATTERY PACK M33098 WAS FOUND TO HAVE LOW CAPACITY. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR AALA201806219024Cover · detachedEMERGENCY LIGHT PLASTIC COVER DETACHED, NEAR FIRST FLIGHT ATTENDANT JUMP SEAT. MAINTENANCE REPLACED THE COVER, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018062199020Lens · damagedSEAT MOUNTED EMERGENCY LIGHT LENSES AT ROWS 10 LEFT AND 13 LEFTARE DAMAGED. REPLACED THE LENS AT ROW 10 LT IAW AMM 33-51-19-0401.SDR AALA2018062199019Lens · missingR1 DOOR MISSING THE EMERGENCY EXIT SIGN LENS. INSTALLED THE LENS IAW AMM 25-60-00.SDR AALA2018062099023Lens · damagedSEAT MOUNTED EMERGENCY LIGHT LENSES AT ROWS 10 LEFT AND 13 LEFT ARE DAMAGED. REPLACED THE SEAT MOUNTED EMERGENCY LIGHT LENS AT ROW 13 LEFT IAW AMM 33-51-19-0401.SDR DALA2018061804118Battery · dischargedEMERGENCY CEILING LIGHTS INOP ROWS 15-20. REMOVED AND REPLACED BATTERIES AT B5-102 PER AMM 33-53. LIGHTS CK NML.SDR DALA2018062004115Battery · dischargedEMERGENCY LIGHTS AT ROWS 11, 13, AND 15 INOP. REMOVED AND REPLACED BATTERIES OF BATTERY PACK B5-101 IN REF TO AMM 33-53. CHECKS GOOD.SDR DALA2018061804113Battery · dischargedEMERGENCY LIGHTS AT L1 DOOR, COCKPIT, AND R1 DOOR INOP. REMOVED AND REPLACED BATTERIES OF BATTERY PACK B5-23 IN REF TO AMM 33-53. CHECKS GOOD.SDR DALA2018062004111Light · inoperativeRIGHT OVERWING ESCAPE HATCH HANDLE EMERGENCY LIGHT INOP, RELAMPED.SDR DALA2018061804086Light · inoperativeDURING INSPECTION FOUND 2R DOOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPAIRED 2R EMERGENCY LIGHT PER SWPM CH 20 AND INSTALLED PE AMM 33-51. OPS CK GOOD.SDR REXA2018061800521Sign · inoperativeMID CABIN EMERGENCY LIGHT FA INDICATION LIGHTS DO NOT WORK. REMOVED & REPLACED MID CABIN EMERGENCY EXIT SIGN FWD AMM 33-51-07. ALL CHECKS GOOD. P/N BF5-0820-901 QTY 2.SDR REXA2018062018520Battery Pack · inoperativeLOWER EMERGENCY LIGHT AT ROW 12CD WAS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-17, OPS CHECKED FAILED. REMOVED AND REPLACED THE EMEREGENCY LIGHT BATTERY NR 3 IAW AMM 33-51-17-400-801. OPS TESTED GOOD.SDR IPXA2018062093821Bulb · inoperativeL1 DOOR EMERGENCY LIGHT HAD TWO BULBS INOPERATIVE. REPLACED THE BULBS. OPS CHECKED GOOD IAW AMM 33-27-05SDR SWAA2018062022935Lens · unsecureAFT AISLE OVERWING EMERGENCY EXIT SIGN COVER LENS CAME OFF. SECURED LENS PER MM.SDR SWAA2018062022931Spring · brokenAFT EMERGENCY LIGHT SWITCH GUARD SPRING BROKEN. R&R SPRING PER SIP.SDR SWAA2018062022921Battery Pack · failedLT FORWARD EMERGENCY BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR AALA201806199015Sign · damagedOVERHEAD EMERGENCY EXIT SIGN AT THE L3 DOOR WAS FOUND DAMAGED. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-17. OPS CHECKED GOOD.SDR SWAA2018061922912Battery · dischargedL2 DOOR EXTERIOR EMERGENCY LIGHTS INOP. R&R BATTERY PER AMM.SDR SWAA2018061922890Battery · dischargedR2 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PER AMM.SDR R61A2018061980699Battery · inoperativeCOCKPIT EMERGENCY LIGHT DOES NOT ILLUMINATE. R & R THE NR 1 EMERGENCY LIGHT BATTERY IAW AMM 33-50-01.SDR SWAA2018061922885Ballast · inoperativeLT OVERWING EXIT SIDEWALL LIGHT INOP. R&R LIGHT BALLAST PER AMM.SDR YENA2018061980258Power Supply · failedLOWER RT EMERGENCY LIGHT WAS INOPERATIVE. REMOVED & REPLACED THE POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED NORMAL.SDR YENA2018061980257Power Supply · failedLOWER RT EMERGENCY LIGHT WAS INOPERATIVE. REMOVED & REPLACED THE POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED NORMAL.SDR SIMA20180618002Light · inoperativeDURING PS-2 CHECK, OVERWING EMERGENCY EXIT FLOOR LIGHTING STRIP FOUND TO BE INOP. REMOVED AND REPLACED OVERWING EMERGENCY EXIT FLOOR LIGHTING STRIP IAW AMM TASK 33-50-12. OP CHECK GOOD.SDR SIMA20180618001Light · inoperativeRT AFT OVERWING EMERGENCY LIGHT INOP. R&R RT AFT OVERWING EMERGENCY LIGHT LAMP IAW AMM 33-51-15 OPC GOOD.SDR QXEA2018061800224Fastener · looseEMERGENCY EXIT SIGN AT THE GALLEY SERVICE DOOR WAS DETACHED. REMOVED FROM SERVICE. AFTER INSPECTION, FOUND A LOOSE FASTENER. SECURED THE FASTENER. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR QXEA2018061800223Bulb · inoperativeF/A EMERGENCY LIGHT SWITCH, THE GREEN NORMAL BULB WAS INOPERATIVE. REMOVED FROM SERVICE. REPLACED THE BULB. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED. THE AIRCRAFT RETURNED TO SERVICE.SDR DALA2018061804046Power Supply · inoperativeTHE B5-260 EMERGENCY LIGHT POWER SUPPLY WAS FOUND INOPERATIVE. REPLACED THE POWER SUPPLY, ALL TESTS WERE NORMAL AND THE AIRCRAFT IS OK FOR SERVICE.SDR YENA201806180252Battery Pack · failedCABIN EMERGENCY LIGHTS FAILED A BITE TEST. REMOVED AND REPLACED THE POWER SUPPLY BATTERIES AT 10WL, 11WL, AND 13WL, IAW AMM 33-51-38. EMERGENCY LIGHTS CHECKED GOOD.
Back to JASC 3350