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 CALA2016121901111Fuse · faultyTWO LOWER OVERWING EMERGENCY LIGHTS INOP. LT LOWER TWO OVERWING SLIDE LIGHTS INOP, FOUND 5A FUSE BAD ON POWER SUPPLY. REPLACED FUSE AND OPS CHECKED EMERGENCY LIGHTS. ALL LIGHTS ILLUMINATED. REF AMM 33-51-04/201.SDR CALA2016121901109Light · inoperativeDOOR 4L EMERGENCY LIGHT (FWD GREEN) INOP REF JC 74-3351-1-7105. REPLACED 2 EA GALLEY EEL LIGHTS REF WDM 33-51-52, OPS CHECK OKSDR CALA2016121901108Light · inoperativeNR 4 RT AFT EMERGENCY LIGHT INOP REF JC 74-3351-1-7105. REPLACED 2 EA GALLEY EEL LIGHTS REF WDM 33-51-52. OPS CHECK GOOD.SDR CALA2016121901107Light · inoperativeEMERGENCY EXIT LIGHT AT DOOR 2L (AFT GREEN EXIT) INOP REF JC 74-3351-1-7105. REPLACED MARKER LIGHT REF WDM 33-51-33.SDR CALA2016121901105Light · damaged19ABC SEAT EEL LT ASSY FOUND DAMAGED. REPLACED 19ABC SEAT EEL LT ASSY AND C/O OP CHK FOUND ''SATIS'' REF TO AMM 33-51-12 REV 182.SDR CALA2016121901104Light · damaged57HJK SEAT EMERGENCY MOUNT LT ASSY FOUND DAMAGED. REPLACED 57HJK SEAT EMERGENCY MOUNT LT ASSY AND C/O OP CHK FOUND ''SATIS'' PER AMM 33-51-12 REV 182.SDR CALA2016121901101Light · inoperativeAFT GALLEY EMERGENCY EXIT LIGHT O/B OF DOOR 402 HAS 1 EA BAD BULBS. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY, OPS CHECK GOOD IAW AMM 33-51-01-960-802.SDR CALA2016121901100Light · inoperativeR2 EMERGENCY EXIT LIGHT HAS 1 EA BAD BULB. REMOVED AND REPLACED AND OPS CHECK GOOD FOR EMERGENCY EXIT LIGHT AT R-2 DOOR IAW AMM 33-51-01.SDR CALA2016121901099Light · inoperativeLT AFT EXTERIOR EMERGENCY SLIDE LIGHT INOP. REMOVED AND REPLACED LAMP IAW AMM 33-51-04. OPS CHK GOOD.SDR CALA2016121901098Light · defectiveAFT CREW REST EMERGENCY LT ASSY FOUND LOW VOLTAGE. REPLACED AFT CREW REST EMERGENCY LT ASSY AND C/O OP CHK FOUND ''SATIS'' REF TO AMM 33-51-07 REV 182 AND AMM 33-51-00 REV 182.SDR CALA2016121901130Battery · failedEEL BATTERY PACK 11WL FAILS BATTERY CAPACITY TEST REF AMM 33-51-00-710-003. REPLACED BATTERY REF AMM 33-51-38-000-002A AND 38-51-38-000-002A . OPS CHECKED OKSDR CALA2016121901129Battery · faultedEPSU FWD AND RT BATTERY FAULT LIGHT DURING TEST. REPLACED EMERGENCY BATTERIES PER AMM 33-51-38.SDR CALA2016121901128Battery · failedEMERGENCY EXIT LIGHT BATTERY PACK 12WL FAILED CAPACITY CHECK. REPLACED BATTERY PACK 12WL REF AMM 33-51-00-710-001-01A. OPS CHECKED OK.LSDR CALA2016121901127Battery · failedEMERGENCY EXIT LIGHT BATTERY 10WL FAILS CAPACITY CHECK. REPLACED BATTERY REF AMM 33-51-00-710-001-A01. OPS CHECKED OKSDR CALA2016121901126Power Supply · inoperativeEMERGENCY LIGHT TEST FAILED. MSG EPSU AFT L RESETS NO HELP. NEEDS POWER UNIT AND BATTERY RPL'D. EPSU BATTERY AND UNIT REF AMM 33-51-38 GRD TEST NORM NO DEFECTS NOTED.SDR CALA2016121900001Battery · faultedCIDS REPORTED LEFT AND RIGHT BATT PACK FAULTS. REMOVED AND REPLACED LEFT AND RIGHT EMERGENCY LIGHT BATTERY PACKS. OPS CHECK GOOD.SDR CALA2016121901125Battery Pack · failedLEFT OVERWING EMER BATTERY AND AFT LEFT BATTERY FAILED. REMOVED AND REPLACED LT OVERWING AND AFT LEFT EMER BATTERY PACKS REF AMM 33-51-38 PB 0401, OPS CHK GOOD, A/C OK FOR SERVICE.SDR CALA2016121901124Pcu · faultedCABIN EMERGENCY LIGHT TEST FAILS. MESSAGE IS AFT L PSCU IS AT FAULT. REPLACED EMERGENCY POWER CONTROL UNIT IAW 33-51-39.SDR CALA2016121901123Unknown · malfunctionedEMER EXIT LIGHT ON CONSTANTLY. CYCLED SWITCH NO HELP. NOTED FASTEN SEATBELT SWITCH ON, SWITCHED OFF. EMERGENCY EXIT LIGHTS ARE OFF NOW.SDR CALA2016121901114Light · inoperativeEMERGENCY LIGHT ON EXTERIOR AT DOOR 4R INOP. RELAMPED, OPS CK GOOD REF AMM 33-51-04.SDR HNAA20161200344Control Box · malfunctionedEMERGENCY LIGHTS ARE FLICKERING DURING TAKEOFF AND LANDINGS. REMOVED AND REPLACED EMERGENCY LIGHT CONTROL BOX. OPS CHECKED FOO AT THIS TIME IN ACCORDANCE WITH MM 33-52-00. OK FOR SERVICE.SDR HNAA2016121900342Battery · dischargedRIGHT HAND AFT EGRESS LIGHT IS INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT 3351-P4 IN ACCORDANCE WITH 33-51-00. OPS CHECKED GOOD.SDR HNAA2016121900341Unknown · malfunctionedFIRST AND THIRD FORWARD MOST EMERGENCY FLOOR LIGHTS ARE OUT. CYCLED EMERGENCY LIGHT SWITCH. BOTH EMERGENCY FLOOR LIGHTS OPERATED FORMAL AT THIS TIME.SDR DALA2016121910038Wire · pulled19C SEAT EMERGENCY LIGHT INOPERATIVE, REPAIRED A PULLED WIRE, INSTALLED NEW PIN AND PLUGED.SDR AALA20161221018Nut Plate · detachedEXTERIOR EMERGENCY LIGHT LEFT SIDE HAS A NUT PLATE FOR LENS COVER DETACHED. SECURED THE NUT PLATE. OPERATIONAL CHECKED GOOD.SDR AALA20161220017Light · brokenEMERGENCY LIGHTING AT FIRST CLASS G3 CLOSET IS BROKEN. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR ASOA201612181314Battery Pack · dischargedRT FWD EMERGENCY LIGHT INOP. REMOVED AND REPLACED EPSU BATTERY PACK IAW AMM 33-51-17. OPS CHECKED GOOD.SDR HALA2016121909977Sign · detachedL3 DOOR EXIT SIGN DETACHED. INSTALLED EXIT SIGN.SDR DALA2016122009981Power Supply · inoperativeEMERGENCY LIGHTS ARE SEAT 1A, 2A, AND 3A ARE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY M9008. SYSTEM OPERATION IS NORMAL.SDR SCNA20161220331Cover · detachedREAR GALLEY EMERGENCY EXIT SIGN IS BROKEN. COVERS HAVE FALLEN OFF AND NEED TO BE ATTACHED. ATTACHED COVERS. OPS CHECKED GOOD.SDR AALA201612199003Lens · brokenAISLE EMERGENCY LIGHT AT 4C LENS BROKEN OFF. REPLACED EMERGENCY LIGHT AND ACCOMPLISHED SATISFATORY OPERATIONAL CHECK.SDR AALA201612199001Light · looseEMERGENCY EXIT LIGHT 9D LOOSE. SECURED EMERGENCY LIGHT IAW AMM 33-51-18.SDR DALA2016121909978Sign · missingL3 DOOR EXIT SIGN MISSING. INSTALLED DOOR 3L EXIT SIGN.SDR R61A201612180741Battery · inoperativeCREW REPORTED THAT THE ROW 12 AND 13 EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR SIMA20161218003Light · inoperativeROW 12 CIELING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACEDTHE EMERGENCY LIGHT. OPS CHECKED GOOD IAW AMM 33-50-07.SDR SIMA20161218004Bulb · inoperativeRT EXTERIOR OVER THE WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10 SUBTASK 020-004-A.OPS CHECKED GOOD.SDR SIMA20161218005Inverter · failedEMERGENCY LIGHT ABOVE SERVICE DOOR INOPERATIVE. REMOVED AND REPLACED THE INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD IAW AMM 33-50-00.SDR MASA2016121812762Light · inoperative18AD EXIT SIGN 1 BULB EACH INOP. REPLACED BULBS.SDR MASA2016121812760Light · inoperativeROW 14 CEILING EMERGENCY FLOODLIGHT INOP. PLACED ON MELSDR MASA2016121812759Battery · dischargedALL CABIN EMER LIGHTS INOP. CHARGED BATTERIES.SDR MASA2016121812758Battery · dischargedROW 13 AND 14 CABIN EXIT LIGHTS WILL NOT ILLUMINATE. CHARGED BATTERIES.SDR QXEA2016122100807Switch · looseEMERGENCY LIGHT SWITCH COVER BROKEN AT FORWARD FA POSITION. SECURED SWITCH. CHECKS GOOD RETURNED TO SERVICE.SDR SWAA2016121910682Cover · missingCENTER AISLE OVERWING EMERGENCY EXIT OVERHEAD SIGN COVER MISSING. INSTALLED COVER PER SIP.SDR SWAA2016121910648Lens · missingR1 DOOR PLASTIC "EXIT" COVER LENS MISSING. INSTALLED LENS PER M/M.SDR SWAA2016121910617Sign · brokenL2 DOOR EMERGENCY EXIT SIGN ASSEMBLY BROKEN. R&R SIGN ASSEMBLY PER MM.SDR SWAA2016121910580Lens · missingRT OVERWING EXIT LIGHT LENS COVER MISSING LOCATED LOWER LEFT OF THE DOOR. INSTALLED COVER PER AMM.SDR AALA20161220003Lens · detachedEMERGENCY EXIT SIGN AT R1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-53-01. OPERATIONAL CHECKED GOOD.SDR AALA20161218002Power Supply · failedEMERGENCY POWER SUPPLY UNIT FAILED CIDS TEST AT 10WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 10WL BATTERY IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR AALA201612189006Lens · looseEXIT LENS BELOW DOOR HANDLE ON LOWER LEFT SIDE OF L4 DOOR IS LOOSE. MAINTENANCE REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2016121909970Light · inoperativeFWD RED EMER LIGHT INOP. RELAMPED PER AMM 33-53.
Back to JASC 3350