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 AALA201704059020Lens · missingL2 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201704059019Lens · brokenFWD ENTRY DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED THE LENS.SDR FDEA201704041072Power Supply · defectiveTHE CABIN EMERGENCY EXIT LIGHTS AND COCKPIT DOME LIGHT INTERMITTENTLY CAME ON AND OFF DURING TURBULENCE. THE PROBLEM STOPPED WHEN THE EMERGENCY EXIT LIGHT SWITCH WAS TURNED OFF. REMOVED AND REPLACED EMERGENCY POWER SUPPLY IN FWD DROP CEILING IAW AMM 33-51-01-4SDR AALA201704059026Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING BY 4R DOOR. INSTALLED EMERGENCY LIGHT LENS.SDR IPXA2017040515826Lamp · inoperativeEMERGENCY LIGHT ASSY HAS FOUR INOPERATIVE LAMPS. REPLACED THE LAMPS IAW AMM 33-51-01-2.SDR HNAA2017040500109Bulb · inoperativeROW 8DF EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR DALA2017040502753Battery Pack · inoperativeFOUND OVERWING EXIT LIGHTS INOPERATIVE. REPLACED THE BATTERIES IAW AMM 33-53, LIGHTS CHECKED GOOD.SDR JJBA20170404004Light · unknownFRONT SERVICE DOOR EMERGENCY LIGHTS FLICKERED. PERFORMED EXTENSIVE OPS CHECK OF EMERGENCY LIGHTS, OPS TEST GOOD. NO DEFECTS NOTED AT THIS TIME.SDR DALA2017040502748Battery · dischargedDURING SERVICE CHECK MAINTENANCE FOUND THAT THE TAIL CONE EMERGENCY LIGHTS WERE INOPERATIVE. THE TAIL CONE EMERGENCY LIGHT BATTERY WAS REPLACED PER AMM 33-55. ALL CHECKS ARE GOOD.SDR MASA2017040412717Light · inoperativePAX DOOR FLOOR LEVEL EMER SIGN 2 BULBS INOP. REPLACED BULBS.SDR CALA2017040400851Power Supply · faultyFOUND CABIN EEL LIGHTS INOP DURING 2 SERVICE CHECK. REPLACED 1 EACH POWER SUPPLY AND 4 EA BATTERIES.SDR CALA2017040400849Battery · faultyBATTERY EMER R FAULT APPEARED ON CIDS PANEL AFTER PERFORMING EMERGENCY LIGHTS TEST. REPLACED BATTERY EMER R. OPS CHECKS GOOD. REF AMM 33-51-38.SDR CALA2017040400845Power Supply · faultySEATS 20-24 EMERGENCY LIGHTS ARE INOP. REPLACED POWER SUPPLY M10567 IAW MM33-51-07, OPS CK OK.SDR CALA2017040400840Light · missingEMERGENCY EXIT ISLE PATH LIGHT AT ROW 20ABC MISSING. R&R EPL/PROXIMITY LIGHT ASSY AT ROW 20ABC IAW AMM 33-51-01-960-802. OPS CHK GOOD.SDR CALA2017040400839Battery Pack · dischargedEMERGENCY EXIT LIGHTS AT RIGHT SEATS 22-27 INOP. REPLACED BATTERY PACK AT SEAT 27 RT, REFERENCE AMM TASK 33-51-06-960-805. OPERATIONAL CHECK SATISFACTORY.SDR CALA2017040400838Light · inoperative21C SEAT LIGHT INOP. REMOVED AND REPLACED INOP SEAT EMERG LIGHT AT SEAT 21C. OPS CK NORMAL REF AMM 33-51-11.SDR CALA2017040400837Light · broken15C EEL LITE BROKEN. REMOVED AND REPLACED BROKEN EEL LIGHT ON SEAT 15C. REF AMM 33-51 -11. OPS CK NORMAL.SDR CALA2017040400835Battery Pack · dischargedEMERGENCY LIGHTS IN FIRST CLASS AND R1 AREA INOP. R&R EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06.SDR CALA2017040400834Light · inoperativeEXTERIOR SLIDE EMERGENCY LIGHT INOP AT AFT LEFT. REPLACED LAMP AND OPS CKD NORMAL PER AMM 33-51-04-990-801.SDR CALA2017040400832Light · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON. 122 SIGN ABOVE 2R FELL NEEDS REINSTALL. REPLACED LIGHT AND LENS. OPS NORMAL. OK FOR SERVICE.SDR CALA2017040400831Sign · looseEMERGENCY EXIT SIGN DOES NOT TURN OFF. 4R AFT EXIT SIGN 4R COVER FELL OFF. REINSTALLED EMERGENCY EXIT 4R.SDR CALA2017040400829Power Supply · inoperativeAFT OVERWING LOWER INTERIOR EMERGENCY EXIT LIGHT SIGNS NOT ILLUMINATED AT END OF EMERGENCY BATTERY CAPACITANCE CHECK JC 29-0550-8-0124. REMOVED AND REPLACED POWER SUPPLY FOR AFT OVERWING LOWER INTERIOR EMERGENCY EXIT LIGHTED SIGNS IAW AMM 33-51-06 OPS CHECK GOSDR CALA2017040400825Battery Pack · dischargedL1 DOOR EXTERIOR, INTERIOR O/H, AND FWD AISLE EMERGENCY LIGHTS ARE INOP. T/S, RPLCD BATTERY PACK AS NEEDED. OPS GOOD.SDR CALA2017040400824Light · brokenEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON 2A. 1 LENS BROKEN 2AB. REMOVED AND REPLACED SEAT 2AB EMERGENCY FLOOR PROXIMITY LIGHT ASSY. OPS CHECKS GOOD.SDR CALA2017040400823Light · inoperativeEMERGENCY LIGHT AT SEAT 4B INOP. REMOVED AND REPLACED BULB IN CABIN CEILING EMERGENCY LIGHT IAW MM 33-51-01.SDR CALA2017040400821Light · inoperativePASSENGER SERVICE DOOR R3 HAS EXTERIOR ESCAPE SLIDE LIGHT OUT. RELAMPED R3 DOOR ESCAPE SLIDE LIGHT. OP CHK GOOD. REF AMM 33-51-06.SDR CALA2017040400820Light · unsecure2L ENTRY DOOR SLIDE LIGHT CAME OUT. LIGHT LEFT IN COCKPIT REINSTALLED L2 SLIDE LIGHT ASSY LIGHT CKS GOOD.SDR CALA2017040400819Light · inoperativeDOOR 2L SLIDE LIGHT WILL NOT ILLUMINATE RELAMPED DOOR 2L SLIDE LIGHT AT DOOR, OPS CKD GOOD,SDR CALA2017040400813Light · brokenEXIT LIGHTS ON CORNER OF 1R LAV 101 BROKEN. REF IPC 33-51-12-67 FOR LOCATION. EMERGENCY LIGHTS SECURED & OPS CHKS ACCOMPLISHED PER AMM33-51-00.SDR CALA2017040400811Light · unsecureLAV 101 AT DOOR 1R EMERG LIGHT STRIP NEEDS TO BE SECURED. IT HAS POPPED OUT RESECURED LIGHT.SDR CALA2017040400843Light · malfunctionedEMER FLOOR LIGHTS AT ROW 28-34 WILL NOT EXTINGUISH. RESET ELT AT AFT FLT ATT STATION. OPS GOOD.SDR CALA2017040400842Light · inoperativeRT FWD EMERGENCY EXIT EXTERIOR LIGHT INOP. RELAMPED OPS CHECK OK. OK TO CONTINUE.SDR CALA2017040400833Light · inoperativeL2 DOOR EMER LIGHT INOP. RELAMP L2 DOOR EMER LIGHT PER AMM 33-51-04, OPS CHECK GOOD.SDR MASA2017040412716Light · inoperativeROW 20 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017040412715Light · inoperativeROW 18 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017040412714Lamp · inoperativeONE LAMP INOPERATIVE ROW 18 LOWER EXIT SIGN.SDR DALA2017040402718Lamp · inoperativeEXTERIOR EMERGENCY LIGHTS RIGHT SIDE OVERWING OUT. REPLACED THE LAMP AND CHECKED OK.SDR DALA2017040402832Light · brokenTAIL COMPARTMENT EMERGENCY LIGHT LENS AND BASE BROKEN. INSTALLED A NEW LIGHT. OPERATION CHECKED GOOD.SDR QXEA2017040700222Light · detachedEMERGENCY LIGHT BY FWD GALLEY CUPBOARD COMING UP. SECURED THE LIGHT. RETURNED TO SERVICE.SDR DALA2017040402818Light · unknownEMERGENCY LIGHTS AT L2 DOOR AND OVERWING EMERGENCY EXIT DOORS TEMPORARILY ILLUMINATED IN FLIGHT. OPS CHECKED EMERGENCY LIGHTS TO BE NORMAL AT THIS TIME, NO DEFECTS NOTED, OK FOR SERVICE.SDR DALA2017040402815Sign · looseEXIT SIGN AT THE L2 DOOR, FELL OFF INSIDE CABIN. SECURED THE SIGN.SDR ASAA2017040320355Lens · detachedR1 DOOR EXIT SIGN LENS FELL OFF. ACFT GROUNDED. SECURED A NEW LENS IAW AMM 33-51-01.SDR ASOA201704034017Bulb · burned outDURING MAINTENANCE INSPECTION, THE EXTERIOR EMERGENCY LIGHT BY THE SERVICE DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT BULB, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICSDR AALA201704069012Sign · damagedLT AISLE SPANNING EMERGENCY EXIT SIGN HAS BROKEN TIEWRAPS. MAINTENANCE REPLACED EMERGENCY TIEWRAPS IAW AARD 33-51-02. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704059017Cover · brokenEMERGENCY EXIT LIGHT COVER (3L) BROKEN (FELL OFF). INSTALLED EMERGENCY EXIT LIGHT COVER AT 3L DOOR IAW 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704059016Sign · damagedLT AISLE SPANNING EMERGENCY EXIT SIGN HAS BROKEN TIEWRAPS. LT AISLE SPANNING EMERGENCY EXIT SIGN HAS BROKEN TIEWRAPS. REPLACE EMERGENCY TIEWRAPS IAW AARD 33-51-02. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704059015Sign · damagedEMERGENCY EXIT ASSY DAMAGED FWD GALLEY R1 DOOR. REMOVED AND REPLACED EMERGENCY EXIT ASSY IAW AMM 33-51-01. OPS CHECK OK. A/C OK FOR CONTINUED SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704059013Power Supply · dischargedEMERGENCY POWER SUPPLY M33097. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06-960-803 AND 33-51-06-960-802, TEST OK. AC OK FOR SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704059012Power Supply · dischargedEMERGENCY PWR SUPPLY M33098 WITH LOW BATTERY. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06-960-803 AND 33-51-06-960-802 TEST OK, OK FOR SVC. AIRCRAFT WAS NOT GROUNDED.SDR AALA201704059011Lens · missingSERVICE GALLEY BY L2 & R2 DOOR (BETWEEN) FWD WALL EMERGENCY LIGHTS MISSING LENS. MAINTENANCE INSTALLED LENS PER 33-50-00, OK FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.
Back to JASC 3350