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 CALA2016091400649Warning Light · false activationEMERGENCY LIGHTS EICAS DISPLAYED. ACCOMPLISHED INTENT OF FIM TASK 33-51 TASK 801. OPS NORMAL . EICAS APPEARS AND CLEARS ALL NORMAL.SDR CALA2016091400648Light · inoperativeDURING CABIN CHECK FOUND SEAT 34C EMERGENCY LIGHT NOT ILLUMINATE . EMERGENCY LIGHT REPLACED AND OPS CHECKED NORMAL.SDR IPXA2016091308231Light · no testL1 DOOR AFT EMRGENCY LIGHT DOES NOT TEST. REPLACED THE LAMP IAW AMM 33-52-01-000-805, 33-52-01-400-805, AND 33-52-01-700-803SDR IPXA2016091308235Power Supply · inoperativeEMERGENCY LIGHT TEST DID NOT PASS. R & R THE POWER SUPPLY IAW AMM 33-51-01. OPS CHECKED NORMAL ESR 33-51-01- 05.SDR IPXA2016091308227Power Supply · no testEMERGENCY LIGHT TEST DID NOT PASS. R & R THE POWER SUPPLY IAW AMM 33-51-01. OPS CHECKED NORMAL.SDR R61A201609130537Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT SECTION NEAR THE COAT CLOSET WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LIGHT AMM AND OPS CHECKED GOOD.SDR SIMA20160913003Fuse · inoperativeMAIN CABIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R FUSE FOR EMERGENCY LIGHT ON PASSENGER DOOR AT POWER SUPPLY. OPS CHECKED GOOD.SDR DALA2016091406658Lens · detachedFOUND EMERGENCY LIGHT 22DEF BROKEN FROM SEAT. SECURED THE LENS. OPS NORMAL IAW AMM 33-50.SDR AALA201609149017Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 3C EMERGENCY LIGHT BROKEN. REPLACED EMERGENCY LIGHT AT SEAT 3C AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-19.SDR ASOA20160912050CLight · inoperativeDURING ROUTINE MAINTENANCE THE EMERGENCY LIGHT STRIP BY ROW 9 AND 10 WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT STRIP AND OPS CHECKS WERE GOOD.SDR MASA2016091212383Battery Pack · inoperativeAFT LEFT DOOR EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY.SDR MASA2016091212382Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY.SDR MASA2016091212381Battery Pack · dischargedALL CABIN EXIT LIGHTS WILL NOT STAY ILLUM. CHARGED BATTERIES.SDR MASA2016091212380Power Supply · inoperativeL1 DOOR EMERGENCY EXIT SIGN INOPERATIVE. REPLACED EMERGENCY LIGHT POWER UNIT 2.SDR MASA2016091212379Bulb · inoperativeROW 13AC EMERGENCY EXIT SIGN 2 BULBS INOP. REPLACED BULBS.SDR AALA20160914005Battery Pack · dischargedFOUND SEAT MOUNTED EMERGENCY LIGHTS AT SEATS 9-16 AND 27-36 DIM DURING TEST. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AND PERFORMED OPERATIONS TEST NORMAL IAW AMM 33-51-07 AND 33-51-00.SDR AALA20160913002Battery · dischargedFOUND SEAT MOUNTED EMERGENCY LIGHTS AT SEATS 9-16 AND 27-36 DIM DURING TEST. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS AND PERFORMED OPERATIONS TEST NORMAL IAW AMM 33-51-07 AND 33-51-00.SDR HNAA2016091400279Battery Pack · dischargedFIRST 2 RED EMERGENCY FLOOR LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW STANDARD PRACTICES. FWD FLOOR LIGHTS NOW OPS NORMALSDR HNAA2016091400278Bulb · dimEMERGENCY EXIT SIGN ABOVE PAX DOOR DIM. R & R THE BULBS.SDR ASAA2016091217998Light · failedRIGHT EMERGENCY AISLE LIGHT INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-03. OPS CHECKED GOOD.SDR YENA20160912791Battery Pack · no testWHILE ACCOMPLISHING OPS CHECK OF THE EMERGENCY LIGHTS FOR A WEEKLY CHECK, FAULT MESSAGE ILLUMINATED FOR EPSU BATTERY. TROUBLESHOT IAW TSM 33-51-00-810-802-A. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED OK.SDR SWAA2016091355738Lens · looseOVERWING OVERHEAD EMERGENCY EXIT LIGHT COVER LENS LOOSE. SECURED THE LENS IAW SIP.SDR R61A201609120530Battery Pack · inoperativeCREW REPORTED THAT THE AFT EMERGENCY LIGHT ASSEMBLY WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR ASOA20160912048Battery · dischargedDURING ROUTINE MAINTENANCE THE LT FORWARD EXTERNAL EMERGENCY LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE NR 1 EMERGENCY BATTERY POWER SUPPLY AND THE NR 1 EMERGENCY BATTERY. OPS CHECKS WERE GOOD.SDR AALA20160912005Sign · brokenAFT RIGHT EXIT LOCATION LIGHT IS BROKEN. REPLACED EXIT LOCATION SIGN PER AMM 33-51-01.SDR A6WA201644324Inverter · inoperativeFLIGHT NUMBER 4041. EMERGENCY LIGHTS BETWEEN ROWS 5D AND 8D, AND EMERGENCY EXIT ROW 8F LOWER GREEN EXIT SIDEWALL SIGN NOT ILLUMINATING. R & R THE NR 3 INVERTER IAW AMM 33-51-07. OPS CHECKED GOOD.SDR DALA2016091306661Lens · detachedEMERGENCY EXIT LIGHTED SIGN LENS ABOVE R2 DOOR CAME OFF. SECURED THE LENS.SDR DALA2016091206617Battery Pack · inoperativeFIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY ASSEMBLY. OPERATION CHECKS OK.SDR QXEA2016091100578Battery Pack · inoperativeEMERGENCY LIGHTS IN THE AFT FUSELAGE AND AFT DOOR ARE INOPERATIVE. REPLACED THE RT NR 4 EPSU BATTERY PACK IAW AMM 33-51-00-820-801. OPS CHECKED GOOD.SDR QXEA2016091100576Light · looseEMERGENCY LIGHT STRIP AT ROW 2 IS DISLODGED. CLEANED AND REATTACHED WITH NEW TAPE. RETURNED TO SERVICE.SDR N6WA2016091101Light · inoperative1 OVERHEAD EMERGENCY LIGHT IN CABIN IS INOPERATIVE. PLACED 2ND TO LAST OVERHEAD EMERGENCY CEILING FLOODLIGHT ON MEL 33-51-01B-2A, CAT-C CORRECT PRIOR TO 9-22-16, OCN 70008257.SDR SWAA2016091255652Sign · damagedOVERWING CEILING EMERGENCY EXIT LIGHT SIGN DAMAGED. R & R SIGN IAW MM.SDR AALA20160911002Light · brokenMID AISLE EXIT EMERGENCY LIGHT ASSEMBLY BROKEN. REMOVED AND REPLACED AISLE EXIT ASSEMBLY IAW MM 33-25-00-020-802. OPS CHECKED OK IAW MM 33-25-00-020-802. EMERGENCY EXIT LIGHT OPS CHECK OK MM 33-51-00-501. THE AIRCRAFT WAS GROUNDED.SDR AALA201609129003Lens · missingL4 DOOR EMERGENCY LIGHT LENS COVER MISSING. INSTALLED EMERGENCY LIGHT LENS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR DALA2016091200154Battery Pack · no testEMERGENCY LIGHT BATTERY AT R3 DOOR FAILED DURING TEST. REPLACED BATTERY PACK.SDR DALA2016091200153Battery Pack · no testEPSU BATTERY CAPACITY TEST FAULTED 14WL. REPLACED THE BATTERY PACK.SDR SIMA20160911001Light · inoperativeSERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R SERVICE DOOR EXIT EMERGENCY LIGHT IAW AMM 33-50-10-000-801 AND 33-50-10-400-801. OPS
CHECK GOOD.SDR MASA2016091112375Power Supply · inoperativeAFT CABIN OVERHEAD EMERGENCY LIGHT OUT. REPLACED THE RIGHT NR 2 POWER SUPPLY UNIT.SDR MASA2016091112374Light · inoperativeLEFT AFT EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE.SDR SWAA2016091255714Light · inoperativeLEFT OVERWING EMERGENCY EXIT LATCH LOWER EXIT SIGN LAMP INOPERATIVE. RELAMPED IAW AMM.SDR SWAA2016091255710Lens · looseCEILING MOUNTED OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2016091255706Light · brokenR1 DOOR EMERGENCY EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2016091255688Battery · dischargedLEFT OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE BETWEEN ROW 3 TO ROW 6. R & R BATTERY IAW MM.SDR SWAA2016091255659Power Supply · faultyAFT ENTRY EMERGENCY LIGHT FAULTY. R & R POWER SUPPLY IAW AMM.SDR GLBA2016091200611Bulb · inoperativePILOT REPORTED THAT THE OVERHEAD EMERGENCY LIGHT AT ROW 4 IS INOPERATIVE. MAINTENANCE REPLACED THE BULB, OPS CHECKED GOOD.SDR DALA2016091206532Power Supply · inoperativeDURING SERVICE CHECK, FOUND EMERGENCY LIGHTS INOPERATIVE ROWS 18-22 AND L2 EXIT SIGNS. R & R THE BATTERY PACK AND POWER SUPPLY IAW AMM 33-51. OPS CHECKED GOOD.SDR IPXA2016091008085Battery · dischargedEMERGENCY LIGHT BATTERY 1 LOW MESSAGE DURING PREFLIGHT. R & R BATTERY EMERGENCY POWER SUPPLY. OPS TEST GOOD IAW AMM 33-51-01/401.SDR ASAA2016091017974Sign · detachedF/A REPORTS ACFT LEFT AFT EXIT SIGN NOT ILLUMINATED. ACFT GROUNDED. RE-SECURED LT AFT EXIT SIGN IAW AMM 33-51-01. OPS CHECK GOOD.SDR A6WA201644316Light · inoperativeEMERGENCY FLOOR TRACK LIGHTS INOPERATIVE BETWEEN ROWS 8-13.SDR SIMA20160910003Light · inoperativeAFT CEILING EMERGENCY LIGHT INOPERATIVE. REPLACE AFT CABIN AISLE EMERGENCY LIGHT AND OPC, GOOD, REFER TO AMM 33-50-08.
Back to JASC 3350