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 AALA201612259002Lens · missingMISSING EMERGENCY EXIT LIGHT LENS AT L1 DOOR. REPLACED LENS PER AMM 33-51-18SDR DALA2016122610088Lamp · inoperativeLEFT WING AFT OVERWING HATCH EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51.SDR R61A201612240756Battery Pack · inoperativeMAINTENANCE REPORTED THAT THE AFT GALLEY EXIT SIGN WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR DALA2016122610070Lamp · inoperativeRT AFT OVERWING HANDLE EMERGENCY LIGHT INOPERATIVE, REPLACED THE LAMP.SDR DALA2016122610069Lamp · inoperativeRT FWD EMERGENCY OVERWING HANDLE EMERGENCY LIGHT INOPERATIVE, REPLACED THE LAMP.SDR SIMA20161224001Bulb · burned outMAIN EXIT EMERGENCY LIGHTS HAS TWO BURNED OUT BULBS. R & R THE BULBS IAW 33-51-05. NO DEFECTS NOTED.SDR JJBA20161224021Bulb · inoperativeEMERGENCY LIGHT AT ROW 18 INOPERATIVE. ADJUSTED THE BULB. OPS CHECK GOOD.SDR JJBA20161224020Bulb · inoperativeGALLEY EMERGENCY LIGHT INOPERATIVE. ADJUSTED THE LIGHT BULB. OPS CHECK GOOD.SDR SWAA2017010410937Battery Pack · inoperativeEMERGENCY OVERWING ESCAPE GROUND ILLUMINATION LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SIMA20161223003Battery Pack · failedFOUND LEFT FWD EXTIRIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW 33-50-04.SDR SWAA2016122910868Lens · wrong partR1 DOOR EXIT SIGN MISSING RED ARROW. R & R EXIT SIGN IAW MM.SDR SWAA2016122910862Lens · wrong partL2 DOOR EMERGENCY EXIT LIGHT LENS MISSING RED ARROW. R & R LIGHT LENS IAW MM.SDR AALA20161227003Power Supply · failedEMERGENCY EXIT LIGHTS FAILED TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 12WL IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR DALA2016122710104Battery Pack · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHTS OVER L1 DOOR INOPERATIVE. MAINTENANCE REMOVED AND REPLACED LEFT BATTERY PACK M1674 IAW AMM 33-51. CHECKED GOOD.SDR SWAA2016122810818Battery Pack · inoperativeEMERGENCY LIGHT M1670 INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR SWAA2016122810817Lens · looseEMERGENCY EXIT LIGHT LENS LOOSE AT R1 DOOR. R & R THE LIGHT ASSY IAW MM.SDR AALA201612249002Lens · brokenR4 DOOR EMERGENCY EXIT LENS COVER BROKEN. REPLACED LENS COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161227007Lens · missingEMERGENCY EXIT SIGN AT L2 DOOR MISSING LENS COVER. REPLACED EXIT SIGN LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161227005Battery Pack · inoperativeCABIN EMERGENCY EXIT LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IN COCKPIT IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR ASOA201612234113Light · dischargedTHE FLIGHT CREW REPORTED THAT THE EMERGENCY LIGHT STRIPS AT SEATS 18 A & D WERE NOT ILLUMINATING. MAINTENANCE CHARGED THE EMERGENCY LIGHT STRIOS, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR JJBA20161223019Bulb · inoperativeCENTER OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. R & R EMERGENCY LIGHT BULB. OPS CHECKED GOOD.SDR AALA20161223016Lens · detachedL1 DOOR EMERGENCY EXIT SIGN LENS COVER IS DETACHED. REINSTALLED EXIT SIGN LENS COVER IAW AMM 33-51-09. OPERATIONAL CHECK GOOD.SDR AALA20161223013Battery · no testFLIGHT ATTENDANT EMERGENCY FLASHLIGHT BY L1 DOOR FAILED TEST. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECKED GOOD.SDR AALA20161223003Lens · missingEMERGENCY EXIT SEAT MOUNTED LIGHT AT SEAT 18D IS MISSING RED LENS COVER. REPLACED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR CALA2016122301165Light · inoperativeDOOR 3 LEFT, DOOR MOUNTED SLIDE LIGHT FAILED TO ILLUMINATE DURING EMERGENCY LIGHTS TEST. REF "A" CHECK JOB CARD 74-3351-1-7105. RELAMPED AND DOOR MOUNTED EMERGENCY LIGHT TEST GOOD AT DOOR 3L PER AMM TASK 33-51-06-962-040.SDR CALA2016122301166Light · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON 111 EMERGENCY EXIT LIGHT 1L BURNT OUT. RELAMPED OPS OKSDR MASA2016122312768Battery Pack · dischargedMULTIPLE EMERGENCY LIGHTS IN GALLEY ARE INOPERATIVE. CHARGED THE BATTERIESSDR VQIA2017080800026Power Supply · inoperativeTHE EMERGENCY LIGHTS CYCLED ON AND OFF UNCOMMANDED. UPON TROUBLESHOOTING, TECHNICIANS ALSO DISCOVERED EMERGENCY LIGHTS ABOVE L1 DOOR & R1 DOOR, ROW 1, 3, & 4 INOPERATIVE. R & R EPSU BATTERY AT 10WL. OPS CHECKED GOOD IAW AMM 33-15-138 PB401. NO FURTHER REPOSDR ASOA201612223090Power Supply · inoperativeTHE CREW REPORTED THE EMERGENCY EXIT LIGHTS BY ROW 18 WERE NOT WORKING. MAINTENANCE INSPECTED AND REPLACED THE NR 3 POWER SUPPLY. OPERATIONAL CHECKED GOOD.SDR SWAA2016122810860Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK M1672 FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2016122810821Power Supply · inoperativeRIGHT MID CABIN EXIT LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW MM.SDR SWAA2016122810802Battery Pack · no testFWD GALLEY LH EMERGENCY LIGHT FAILED CAPACITY TEST. R & R BATTERY PACK IAW MM.SDR SWAA2016122810800Lens · missingL1 DOOR LOWER EXIT LIGHT LENS MISSING. R & R THE LENS IAW MM.SDR SWAA2016122810799Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK M1673 FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW MM.SDR HALA2016122300221Light · unsecureLIGHT STRIP AT R1 DOOR WAS LOOSE. SECURED LIGHT STRIP.SDR AALA20161227001Light · inoperativeLEFT FORWARD OVERWING EXIT LIGHT ASSEMBLY IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-21-00. OPERATIONAL CHECKED GOOD.SDR AALA20161222018Battery Pack · no testEMERGENCY EXIT LIGHTS BATTERY B5-101 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY. OPERATIONAL CHECK GOOD.SDR AALA20161222017Battery Pack · no testEMERGENCY EXIT LIGHTS BATTERY B5-107 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY. OPERATIONAL CHECK GOOD.SDR ASOA201612225092Light · inoperativeCREW REPORTED MOST AFT CABIN EMERGENCY LIGHTS ARE INOPERATIVE. MX REMOVED AND REPLACED THE LIGHT AND OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201612223088Battery Pack · inoperativeDURING ROUTINE MAINTENANCE THE LEFT AND RIGHT OVERWING AFT EMERENGENCY LIGHTS WERE FOUND INOPERATIVE. MAINTENANCE REPLACED THE NR 4 EMERGENCY LIGHT BATTERY POWER SUPPLY. OPERATIONAL CHECKS WERE GOOD.SDR SWAA2016122710796Sign · fadedRIGHT OVERWING EXIT LENS FADED. R & R EXIT SIGN IAW MM.SDR SWAA2016122710786Lens · missingFWD ENTRY EXIT LIGHT LENS MISSING. R & R THE LIGHT ASSY IAW MM.SDR SWAA2016122710769Lens · crackedR1 DOOR EMERGENCY EXIT LIGHTED SIGN LENS CRACKED. R & R THE LENS IAW MM.SDR SWAA2016122710768Light · inoperativeFWD CABIN EMERGENCY LIGHTING AT 1 DEF TO 2 DEF INOPERATIVE. R & R LIGHT STRIP IAW MM.SDR AALA201612239014Light · looseDAMAGE TO HOUSING ASSEMBLY OF CABIN EMERGENCY LIGHT AT SEAT 9C, LIGHT ASSEMBLY HANGING LOOSE FROM FRAME. MAINTENANCE REPLACED DAMAGED HOUSING AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612239013Cover · missingMISSING EMERGENCY LIGHT COVER FOR FLOOR LIGHTING AT 1C. REPLACED LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612239012Power Supply · inoperativeEMERGENCY EXIT SIGN AT LEFT AFT PASSENGER DOOR INOPERABLE. AIRCRAFT WAS GROUNDED. REPLACED EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR AALA201612239009Battery Pack · no testALL FIRST CLASS EMERGENCY LIGHTS WILL NOT TEST IAW PERIODIC CHECK. REPLACED FORWARD LEFT BATTERY PACK IAW AMM 33-50-18.SDR AALA201612239003Lens · missingL4 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECKED..SDR AALA20161223011Battery · failedFLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT L4 DOOR JUMPSEAT LEFT SIDE FAILED BATTERY TEST. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECKED GOOD.
Back to JASC 3350