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 AALA20170113022Sign · brokenEMERGENCY LIGHT AT R1 DOOR IS BROKEN. REMOVED AND REPLACED SIGN IAW AMM 33-51-13. OPERATIONAL CHECKED GOOD.SDR AALA20170113020Lens · missingEMERGENCY EXIT LIGHT AT R1 DOOR HAS A MISSING LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170113018Lens · missingEMERGENCY EXIT LIGHT OUTSIDE OF GALLEY WALL IS MISSING IT`S LENS. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170113014Lens · brokenEMERGENCY EXIT LIGHT AT R2 DOOR HAS A BROKEN LENS. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170113013Lens · damagedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 14D HAS A DAMAGED LENS. REMOVED AND REPLACED THE LENS IAW 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20170113012Lens · damagedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 12C HAS A DAMAGED LENS. REMOVED AND REPLACED THE LENS IAW 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20170113011Lens · damagedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 15C HAS A DAMAGED LENS. REMOVED AND REPLACED THE LENS IAW 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20170113010Lens · damagedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 25D HAS A DAMAGED LENS. REMOVED AND REPLACED LENS IAW 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20170113008Battery Pack · failedSEAT MOUNTED EMERGENCY LIGHTS FOR ROWS 26 THROUGH 36 ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR RAIA201701110001Light · inoperativeFWD CABIN EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT AND OPS CHECKED GOOD.SDR AALA201701139004Lens · missingMISSING EMERGENCY EXIT LENS COVER ON 4R EXIT DOOR. REINSTALLED THE LENS. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017011300303Light · unsecureEMERGENCY LIGHT DAMAGED. SECURED THE LIGHT. OPERATION CHECKED GOOD.SDR AALA201701129024Lens · missingMISSING EMERGENCY EXIT LIGHT LENS AT THE L4 DOOR. MAINTENANCE REPLACED THE LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701129020Lens · missingMISSING SEAT MOUNTED EMERGENCY LIGHT LENS AT ROW 10 A,B,C. REPLACED LIGHT ASSEMBLY PER AMM 33-51-18.SDR AALA201701129019Cover · missingMISSING EMERGENCY LIGHT COVER AT AFT R2 DOOR. REPLACED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701129018Cover · missingMISSING EMERGENCY LIGHT COVER AT AFT 2L CABIN DOOR. REPLACED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701129017Cover · missingMISSING LIGHT COVER AT RIGHT EMERGENCY EXIT HATCH. REPLACED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017011200273Light · inoperativeSEAT 22 EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW MM 33-52.SDR HALA2017010110014Power Supply · inoperativeEMERGENCY LIGHTS INOP, A/C LEFT ROW 20-31. REPLACED POWER SUPPLY W BATTERY AND FEEDER CABLE ASSY. P/N'S BPS7-3 , 58822-40 POWER SUPPLIES A/C OK FOR SERVICESDR HNAA2017011100013Bulb · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT ROW 5. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR REXA2017011000083Light · inoperativeROW 1-5 CD EMERGENCY LIGHTS INOPERATIVE. R & R THE CABLE ASSY AND LAMP IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2017011811230Lens · detachedR2 DOOR OVERHEAD EMERGENCY EXIT SIGN LENS FELL OFF. INSTALLED LENS PER EA.SDR SWAA2017011611194Lens · unsecureL1 DOOR EMERGENCY EXIT SIGN LENS FELL OFF. SECURED LENS PER AMM.SDR AALA20170113027Battery Pack · inoperativeTWO LEFT OVERWING EMERGENCY EXIT LIGHTS AND THE L4 EXTERIOR DOOR LIGHT ARE INOPERATIVE. REMOVED AND REPLACED THE CHARGER ASSEMBLY AND BATTERY PACK IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170113026Battery Pack · inoperativeSEAT MOUNTED LIGHTS BETWEEN SEATS 20HJ AND 21HF ARE INOPERATIVE. REMOVED AND REPLACED THE CHARGER ASSEMBLY AND BATTERY ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA20170111013Charger · inoperativeTWO LEFT OVERWING EMERGENCY EXIT LIGHTS AND THE L4 EXTERIOR DOOR LIGHT ARE INOPERATIVE. REMOVED AND REPLACED THE CHARGER AND BATTERY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170111006Charger · inoperativeSEAT MOUNTED EMERGENCY LIGHTS ON SEATS 20HJ AND 21HF ARE INOPERATIVE. REMOVED AND REPLACED THE CHARGER ASSEMBLY & BATTERY ASSEMBL IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR RAIA201701100001Bulb · inoperativePAX DOOR SWING ARM EMERGENCY LIGHT IS INOPERATIVE AND LENS IS CRACKED. REMOVED AND REPLACED THE BULB AND LENS OPS CHECKED GOOD.SDR JJBA20170110005Bulb · inoperativeROW 18C EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR QXEA2017011000007Lens · missingMISSING EMERGENCY EXIT COVER RT FWD EMERGENCY EXIT. INSTALLED NEW LENS. CHECKS GOOD OK FOR CONTINUED SERVICE.SDR AALA20170112007Battery · dischargedAIRCRAFT NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AFT GALLEY RIGHT SIDE FAILED TEST. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECK GOOD. SEE ALSO AALA20170112008 AND AALA20170112009SDR AALA20170112006Lens · damagedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT NEAR BAGGAGE BIN BY SEAT 6L HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LENS COVER IAW 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170112005Lens · missingAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 35G IS MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-20-51. OPERATIONAL CHECK GOOD.SDR AALA20170112004Lens · missingAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 44C IS MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-20-51. OPERATIONAL CHECK GOOD.SDR AALA20170112003Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R5 DOOR IS DETACHED. REFITTED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR SWAA2017011211120Cover · looseL1 DOOR EXIT LIGHT COVER LOOSE. R&R BASE IAW SIP.SDR DALA2017011100269Power Supply · inoperativeDURING EMERGENCY LIGHT SYSTEM TEST, FOUND RIGHT POWER SUPPLY UNIT INOPERATIVE. REPLACED THE BATTERY PACK AND POWER SUPPLY.SDR DALA2017011100265Light · inoperativeRIGHT OVERWING EMERGENCY EXIT HANDLE LED LIGHT INOPERATIVE, REPLACED LIGHTSDR AALA201701119010Cover · missingAIRCRAFT WAS NOT GROUNDED. 2L DOOR EXIT SIGN, LOWER LEVEL LEFT OF DOOR IS MISSING SIGNAGE COVER. MAINTENANCE REPLACED COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017011100247Lamp · inoperativeDURING CHECK, FOUND 2 INOPERATIVE EMERGENCY LIGHTS. REPLACED THE LAMPS.SDR SWAA2017011111111Lamp · inoperativeRIGHT BULLNOSE EMERGENCY LIGHT INOPERATIVE AT ROW 5. REPLACED THE LAMPS IAW MM.SDR SWAA2017011111101Light · looseAFT LEFT EMERGENCY LIGHT STRIP LOOSE. SECURED THE LIGHT IAW SIP.SDR SWAA2017011111099Lens · brokenRIGHT BULLNOSE EMERGENCY LIGHT LENS BROKEN AT ROW 5. REPLACED THE LENS IAW MM.SDR FDEA201701100110Light · inoperativeRT EXTERIOR SLIDE LIGHT IS INOP. RELEASED FOR SERVICE PER MEL 33-51-02-02.SDR AALA20170108011Indicator · brokenAIRCRAFT WAS IN BASE MAINTENANCE. L4 DOOR AFT EXIT INDICATOR FOUND BROKEN. REMOVED AND REPLACED EXIT INDICATOR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170108010Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. R2 DOOR EMERGENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33097 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170108008Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. L3 DOOR EMERGENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33400 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR VNAA2017010900007Light · malfunctionedEMERGENCY LIGHTS FLICKERING AND EMERGENCY LIGHT ON STATUS MESSAGE IN FLIGHT. PERFORMED OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM. OPERATIONAL CHECK GOOD, COULD NOT DUPLICATE.SDR VNAA2017010900005Battery Pack · faultyOVERWING EMERGENCY EXIT LIGHT SIGN FLICKERING. REMOVED AND REPLACED THE NUMBER THREE BATTERY.SDR AALA201701109019Housing · dislodgedEMERGENCY LIGHT HOUSING ON SEAT 20C DISLODGED AND NOT SECURE TO SEAT. REPLACED HOUSING IAW AMM 33-51-04.
Back to JASC 3350