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 DALA2018022601190Sign · detachedL3 DOOR EXIT SIGN ASSEMBLY FELL OFF WALL, FOUND EXIT SIGN BROKEN. REPLACED THE SIGN.SDR SIMA20180225003Light · inoperativeEMERGENCY LIGHT 120 NOT WORKING. REMOVED AND REPLACED EMERGENCY LIGHT STRIP IAW AMM 33-50-12.SDR AALA201802269040Sign · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN R3 FELL OFF. CLIPS BROKEN OFF. REPLACED EXIT SIGN AT DOOR R3.SDR AALA201802269039Sign · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN R3 FELL OFF. CLIPS BROKEN OFF. REPLACED EXIT SIGN AT DOOR R3.SDR DALA2018022601169Power Supply · inoperativeTHE OVERWING EMERGENCY LIGHT DOES NOT TURN ON. TROUBLE SHOT PER 33-50-00 810-801. DURING CHECK POWER SUPPLY B5-119 REPLACEMENT BECAME REQUIRED. POWER SUPPLY WAS REPLACED PER AMM 33-51-03 AND TEST WAS PERFORMED PER AMM 33-51-00. OPERATIONAL TEST IS OK.SDR RAIA201802250001Lens · crackedPAX DOOR SWING ARM, NR 1 EMERGENCY LIGHT LENS IS CRACKED. R & R THE LENS.SDR MASA2018022513009Light · inoperativeROW 17 OVHD EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR CALA2018022500819Battery Pack · dischargedDOOR R3 M33401 EMER POWER SUPPLY BATTERY PACK LOWER CAPACITY. DOOR R3 M33401 EMER POWER SUPPLY BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018022500818Battery Pack · dischargedDOOR L1 M33093 EMER POWER SUPPLY BATTERY PACK LOWER CAPACITY. DOOR L1 M33093 EMER POWER SUPPLY BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018022500817Battery Pack · dischargedDOOR L2 M33099 EMER POWER SUPPLY FOUND INOP. DOOR L2 M33099 EMER POWER SUPPLY CHARGE AND BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018022500816Battery Pack · dischargedDOOR R2 M33097 EMER POWER SUPPLY FOUND INOP. DOOR R2 M33097 EMER POWER SUPPLY CHARGER AND BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018022500813Light · inoperativeFLIGHT CREW REPORTED NUMEROUS EMERGENCY NIGHT LIGHT BULBS INOP. REPLACED 5 BULBS, ALL WORKING.SDR CALA2018022500812Battery Pack · dischargedDOOR R1 M33094 EMER POWER SUPPLY BATTERY LOW CAPACITY DOOR R1 M33094 EMER POWER SUPPLY BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018022500810Light · inoperativeDURING A CHECK, FOUND R1 EMER LT INOP. R1 EMER LT RELAMPED AND LT CHECK OKAY IAW AMM 33-51-00.SDR CALA2018022500809Battery Pack · dischargedDOOR R2 M33098 EMER POWER SUPPLY BATTERY PACK LOW CAPACITY. DOOR R2 M33098 EMER POWER SUPPLY BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-15-06.SDR CALA2018022500803Battery · failedTHE FWD L EMERGENCY LIGHTING EPSU FAILS THE CAPACITY TEST. REMOVED AND REPLACED FWD L/M EPSU BATTERY IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A AND PERFORMED BATTERY CAPACITY TEST IAW AMM 33-51-00-710-003-A AND NO DEFECTS NOTED.SDR CALA2018022500802Battery · failedOPERATIONAL CHECK OF CABIN EMERGENCY LIGHTING BATTERY CAPACITY FAILS WITH MSG "EMR L". REMOVED AND REPLACED LT ESPU BATTERY IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A AND PERFORMED BATTERY CAPACITY TEST IAW AMM 33-51-00-710-003-A AND NO DEFECT NOTED.SDR CALA2018022500801Battery · failedOPERATIONAL CHECK OF CABIN EMERGENCY LIGHTING BATTERY CAPACITY FAILS WITH MSG "EMER AFT L". REMOVED AND REPLACED AFT L/M ESPU BATTERY IAW AMM 33-51-38- 000-002-A AND 33-51-38-400-002-A AND PERFORMED BATTERY CAPACITY TEST IAW AMM 33-51-00-710-003-A AND NO DEFESDR CALA2018022500814Lens · missingSEAT 20C EMERG LT BULB MISSING. REPLACED RED LENS COVER.SDR CALA2018022500811Lens · missingSEAT 21C AISLE RED EMERGENCY EXIT PATH LIGHT LENS MISSING. REPLACED LENS.SDR REXA2018022400187Sign · brokenMID CABIN EMERGENCY EXIT OVERHEAD SIGN HAS A MISSING LENS. REPLACE THE BULBS. OPS TESTED GOOD.SDR FDEA201802240483Battery · warning messageDURING A PREFLIGHT EMERGENCY LIGHT TEST, RECEIVED A LEVEL 1 EMERGENCY LIGHT BATTERY 1 LOW. PERFORMED EMERGENCY LIGHT TEST 3 CONSECUTIVE TIMES IAW MM 33-51-01-5. ALL GOOD IAW WRI 30-30/6329. SUSPECT MISC FAILING AND GENERATING SPURIOUS LOW BATTERYSDR AALA201802269075Light · inoperativeAIRCRAFT WAS NOT GROUNDED. CROSS AISLE OVERHEAD EMERGENCY LIGHT LEFT HAND BETWEEN BUSINESS CLASS AND TOURIST CLASS ABOVE SEAT 7A-7D INOPERATIVE. REPLACED THE SIGN LIGHT ASSEMBLY LOCATED AT M3351831 IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201802279034Sign · looseTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT LOOSE AT 3L DOOR. REINSTALLED EXIT LIGHT SIGN AT 3L DOOR.SDR AALA201802279029Control Unit · inoperativeEMERGENCY LIGHT SIGN OVER THE L3 DOOR WAS INOPERATIVE. MAINTENANCE REPLACED THE WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM A-33-51-07-01A-520A.SDR AALA201802279026Light · looseL1 DOOR EMERGENCY EXIT LIGHT LOOSE. MAINTENANCE SECURED THE EXIT LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW MM 33-51-00.SDR AALA201802269084Lens · brokenTHE EXIT LIGHT COVER FOR DOOR 1R IS BROKEN. REPLACED EXIT SIGN ASSEMBLY AT 1R DOOR PER AMM 33-51-01SDR DALA2018022601250Switch · malfunctionedCREW REST EMERGENCY LIGHTS ARE ON CONTINUOUSLY, SHOULD BE OFF. CYCLED THE EMERGENCY LIGHT SWITCH, OPS CHECKED NORMAL IAW AMM 33-51.SDR DALA2018022601228Light · inoperativeSEAT EMERGENCY LIGHTS INOPERATIVE AT ROWS 4, 5, AND 6. ATTACHED LIGHTS. OPS CHECKED NORMAL.SDR SWAA2018022720141Battery · inoperativeL2 DOOR LOWER EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2018022720140Battery Pack · inoperativeAFT 4 STOWAGE BIN EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018022720139Charger · inoperativeLEFT EMERGENCY EXIT HATCH EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE CHARGER IAW AMM.SDR SWAA2018022720116Battery · inoperativeR2 DOOR EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2018022720109Battery Pack · inoperativeLEFT EMERGENCY EXIT HATCH EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018022720099Light · inoperativeLEFT AFT SECTION EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR AALA201802269051Lens · brokenSEAT 11C EMERGENCY LIGHT LENS MISSING. ASSEMBLY BROKEN. REPLACED 11C EMERGENCY LIGHT LENS AS REQUIRED. TESTED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201802269050Power Supply · failedEMERGENCY POWER SUPPLY UNIT TEST FAILED UNIT 10WL. REPLACED POWER SUPPLY AND BATTERY IAW AMM 33-51-38. THE AIRCRAFT WAS GROUNDED.SDR ASOA201802244013Inverter · inoperativeDURING MAINTENANCE INSPECTION, THE FORWARD EMERGENCY LIGHTRS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT INVERTER, OPS TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR N6WA2018022402Light · detachedEMERGENCY LIGHT AT RT ROWS 1 AND 2 UNATTACHED. SECURED THE EMERGENCY LIGHT STRIP IAW SRM 51-22-00. OK FOR SERVICE.SDR AALA201802269057Bulb · inoperativeR2 DOOR EXIT SIGN HAS SEVERAL INOPERATIVE BULBS. REPLACED THE SIGN IAW AMM 33-50-00.SDR AALA201802269031Lens · damagedEMERGENCY LIGHT LENS DAMAGE AT SEAT 1C. REPLACED THE LENS AT SEAT 1C.SDR SWAA2018022620019Lens · missingR2 DOOR EMERGENCY EXIT LIGHT BOTTOM RT SIDE MISSING. R&R LENS PER AMM.SDR SIMA20180224004Charger · inoperativeEMERGENCY FLOOR PROXIMITY LIGHTS 2, 3, 4, AND 5 INOPERATIVE. REMOVED AND REPLACED THE NR 2 AND 3 CHARGER AND BATTERIES IAW WC 33-700-19, OPS CHECKED GOOD.SDR SIMA20180224003Battery Pack · inoperativeLEFT AND RIGHT EXTERIOR AFT OVERWING EMERGENCY LIGHTS INOPERATIVE. PERFORMED TROUBLESHOOTING OF EXTERIOR AFT OVERWING EMERGENCY LIGHTS IAW WMM 33-50-50. R & R THE NR 4 EMERGENCY LIGHT BATTERY AND CHARGER ASSY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR SIMA20180224002Charger · failedBOTH AFT OVERWING EMERGENCY LIGHTS FAILED TO ILLUMINATE. COMPLIED WITH FIM 33-50-00. REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT BATTERY AND CHARGER IAW 33-50-04. OPS CHECKED GOOD IAW AMM 33-50-04.SDR AALA201802269038Lens · unsecureAIRCRAFT WAS NOT GROUNDED. 2R DOOR EMERGENCY EXIT LIGHT COVER CAME OFF. INSTALLED 2R EXIT SIGN LENS.SDR 29GA2018022600001Power Supply · failedWITH POWER OFF AND EMERGENCY LIGHTS ARMED, EMERGENCY LIGHTS ALL NOT ON. LEFT SIDE FLOOR. R & R EMERGENCY LIGHTING POWER SUPPLY 20LN IAW AMM 33-50-10-04-1.SDR DALA2018022601127Battery Pack · dischargedEMERGENCY LIGHTS BETWEEN ROW 22-25 CEILING INOP. REPL BATTERY PACK PER AMM 33-53. OPS CHECK GOOD.SDR CALA2018022400799Fuse · faultyEMERGENCY LIGHTS OUT AT RT AFT OVERWING EXIT, RT FWD EMERGENCY EXIT DOOR, AND LT AFT EMERGENCY EXIT DOOR. RELAMPED RT FWD EMERGENCY EXIT DOOR LIGHT. RELAMPED LT AFT EMERGENCY EXIT DOOR LIGHT. BOTH OPS CHECKED NORMAL. REPLACED M1671 FUSE AND M1676 BATTERY PACK.SDR AALA201802269081Lens · missingAIRCRAFT WAS NOT GROUNDED. STA 727 EMERGENCY AISLE LIGHT LENS MISSING. INSTALLED STA 727 EMERGENCY AISLE LIGHT LENS PER AMM 25-63-00.
Back to JASC 3350