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 DALA2017101907630Battery Pack · faultedEMERGENCY LIGHTS FAULT, LT EPSU LOAD FAIL, REPLACED THE BATTERY PACK.SDR SWAA2017110217498Light · inoperativeR1 DOOR EXTERIOR SLIDE LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2017102317309Lens · missingL2 DOOR "EXIT" LIGHT LENS COVER MISSING. INSTALLED LENS PER AMM.SDR SWAA2017102317299Sign · missingR1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN PER AMM.SDR AALA20171018008Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE L2 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT/SIGN ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20171018007Power Supply · failedAIRCRAFT WAS GROUNDED. ON TAXI IN, FLIGHT ATTENDANT REPORTED THE CEILING EMERGENCY EXIT LIGHTS AT THE AFT GALLEY ILLUMINATED. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20171018003Lens · missingAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT AFT LIGHT AT SEAT 14G HAS A MISSING LENS COVER. REPLACED LENS COVER PER ECO 21376. OPERATIONAL CHECK PER AMM 33-51-00-710-802.SDR CALA2017102003685Light · brokenPARTITION EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY AND TESTED NORMAL IAW AMM 33-51-05-960-802, REV 80.SDR CALA2017102003684Sign · damagedSIGN BASE FOUND BROKEN. REPLACED THE SIGN AND TESTED NORMAL IAW AMM 33-51-01-960-802, REV 80.SDR HNAA2017102000354Light · intermittentEMERGENCY LIGHTS INTERMITTEN DURINB FLIGHT. R & R EMERGENCY LIGHT CONTROL BOX. R & R THE EMERGENCY LIGHT BASE AT PS4. R & R PS 1 THRU 7 BATTERIES. OPS CHECKED GOOD IAW 33-51-05.SDR DALA2017101907683Lamp · inoperativeROW 30 AND 33 OVERHEAD BIN MOUNTED EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD. OK FOR SERVICE.SDR R61A201710180768Light · inoperativeEMERGENCY LIGHT AT R1 DOOR SURROUND BOTTOM SIDE INOP. R & R THE EMERGENCY LIGHT IAW AMM 33-50-19.SDR R61A201710180767Power Supply · inoperativeEMERGENCY LIGHT AT THE R1 DOOR SURROUND BOTTOM SIDE INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-50-01.SDR IPXA2017101922764Sign · detachedEXIT SIGN OVER THE L1 DOOR FELL OFF DURING LANDING. INSTALLED THE SIGN.SDR SWAA2017101917190Lens · looseCENTER AISLE EMERGENCY EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW SIP.SDR AALA201710199010Lens · unknownEMERGENCY LIGHTS IN LAVS INOPERATIVE. REPLACED EMERGENCY LIGHT LENS.SDR AALA201710199007Light · false activationRIGHT FOWARD EMERGENCY EXIT ILLUMINATED ON ECAM IN FLIGHT ALTITUDE 3000 FT. CHECKED RIGHT FOWARD EMERGENCY EXIT DOOR IAW AMM 52-20-00.NO FAULTS NOTED. NO HISTORY LAST 90 DAYS.SDR AALA201710199005Lens · brokenEMERGENCY LIGHT LENS BROKEN ABOVE THE 1L DOOR. REPLACED THE LENS.SDR ASAA2017101822246Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY M1675 AND M1695 BATTERY PACKS FAILED A CAPACITY CHECK. ACFT GROUNDED. REMOVED, REPLACED, AND TESTED THE BATTERY PACK IAW AMM 33-51-06-960-805. OPS NORMAL.SDR ASAA2017101822245Lamp · burned outEMERGENCY LIGHT INOPERATIVE AT ROW 7 RIGHT. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-03-960-801. OPS NORMAL.SDR DALA2017101807633Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE 4L, 51 ABC - 60ABC AISLE LIGHTS. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33- 51-04, OPS NORMAL. OK FOR SERVICE.SDR MASA2017101812704Bulb · inoperativeROW 18 OVERHEAD EMERGENCY FLOODLIGHT.SDR DALA2017101807625Battery Pack · abnormalLEFT AFT OVERWING EXIT SIGN AND RIGHT AFT OVERWING EXIT SIGN INOPERATIVE. REPLACED THE BATTERY PACKS.SDR DALA2017101807623Battery · dischargedDURING A SERVICE CHECK, FOUND THE EMERGENCY LIGHT BATTERIES LOW. R & R THE BATTERIES IAW MM 33-51.SDR DALA2017101807617Battery Pack · inoperativeWHILE PERFORMING SERVICE CHECK, FOUND BOTH EXTERIOR EMERGENCY LIGHTS ARE INOPERATIVE. INSTALLED A NEW BATTERY IN THE POWER SUPPLY AND FUNCTIONAL CHECKED GOOD.SDR SWAA2017110817645Mount · brokenCEILING PANEL OVERWING EMERGENCY EXIT LIGHT MOUNT BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR DALA2017102507796Light · damagedDURING INSPECTION FOUND EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. MAINTENANCE R&R PROXIMITY MONUMENT LIGHT PER AMM 33-51. OPS CHK NML.SDR SWAA2017102317283Light · delaminatedFORWARD ENTRY WAY EGRESS LIGHT STRIPS DELAMINATED AT ROW 1. R&R STRIPS PER DWG.SDR SWAA2017102317282Lens · crackedR1 DOOR LOWER EMERGENCY LIGHT LENS CRACKED. R&R LENS PER AMM.SDR AALA201710209015Power Supply · no testDURING CHECK, EMERGENCY LIGHT TEST REVEALED EMERGENCY POWER SUPPLY UNIT 10WL FAILED. REPLACED THE POWER SUPPLY IAW TSM 33-51-00-810-830, AND AMM 33-51-38. THE AIRCRAFT WAS GROUNDED.SDR SWAA2017101917230Lens · crackedLT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 17. R&R LENS PER SIP.SDR SWAA2017101917229Lens · crackedLT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 4. R&R LENS PER SIP.SDR SWAA2017101917228Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017101917221Light · looseMID CABIN CEILING EMERGENCY EXIT LIGHT LOOSE. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017101917217Lens · crackedRT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 13. R&R LENS PER SIP.SDR SWAA2017101917216Lens · crackedLT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 14. R&R LENS PER SIP.SDR SWAA2017101917215Lens · crackedRT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 16. R&R LENS PER SIP.SDR SWAA2017101917214Lens · crackedRT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 19. R&R LENS PER SIP.SDR SWAA2017101917213Lens · crackedLT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 20. R&R LENS PER SIP.SDR SWAA2017101917212Lens · crackedRT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 22. R&R LENS PER SIP.SDR SWAA2017101917211Lens · crackedLEFT OVERHEAD EMERGENCY EXIT BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 23. R & R THE LENS IAW SIP.SDR SWAA2017101917210Lens · crackedLT OVERHEAD EMERGENCY EXIT BIN BULLNOSE PATHWAY LIGHT LENS CRACKED AT ROW 1. R&R LENS PER SIP.SDR SWAA2017101917209Lens · crackedLEFT OVERHEAD EMERGENCY EXIT BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 6. R & R THE LENS IAW SIP.SDR SWAA2017101917202Lens · crackedLEFT OVERHEAD EMERGENCY EXIT BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 9. R&R LENS IAW SIP.SDR SWAA2017101917201Lens · crackedRIGHT OVERHEAD EMERGENCY EXIT BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 11. R & R LENS IAW SIP.SDR SWAA2017101917200Lens · crackedRIGHT OVERHEAD EMERGENCY EXIT BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 8. R & R LENS IAW SIP.SDR SWAA2017101917199Lens · crackedRIGHT OVERHEAD EMERGENCY EXIT BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 6. R & R LENS IAW SIP.SDR SWAA2017101917198Lens · looseRIGHT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS LOOSE AT ROW 3. R & R THE LENS IAW SIP.SDR SWAA2017101917196Spring · brokenAFT EMERGENCY LIGHT SWITCH SPRING BROKEN. R & R THE SWITCH GUARD IAW SWPM.SDR DALA2017101807632Battery Pack · failedEMERGENCY LIGHT 38F-45F INOPERATIVE. CONFIRMED A FAILED BATTERY PACK AT SEAT SIDEWALL 43F IAW FIM 33-51. R & R THE BATTERY PACK, OPS NORMAL IAW AMM 33-51.
Back to JASC 3350