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 CALA2017101303607Lens · missingEMERGENCY EXIT SIGN LENS MISSING AT ROW 21R. REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017101303606Light · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON 20A. RESET THE LIGHT ASSY.SDR CALA2017101303602Lens · missingLEFT FWD EMERGENCY EXIT DOOR LIGHT LENS MISSING. REPLACED THE LENS.SDR CALA2017101303596Light · inoperativeR2 DOOR SLIDE LIGHT INOPERATIVE. REMOVED & REPLACED THE SLIDE LIGHT ASSY IAW MM 33-51-00. OPS CHECKED GOOD.SDR CALA2017101303591Lamp · inoperativeEMERGENCY LIGHT AT THE MID GALLEY WAS FOUND INOPERATIVE NEAR THE LOWER STAIR CASE. REPLACED THE LAMP, OP CHECKED OK,SDR CALA2017101303579Light · brokenEMERGENCY LIGHT COVER ON DOOR OF CLOSET 712 IS BROKEN. REPLACED THE EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR DALA2017101307499Battery · no testBATTERY CHARGERS M11081 FAILED A DEEP CYCLE TEST FOR EMERGENCY LIGHTS. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51.SDR IPXA2017101322560Battery Pack · inoperativeINSPECTION TYPE: 18FO, FOUND THE EMERGENCY LIGHT INOPERATIVE. REPLACED THE POWER SUPPLY BATTERY IAW AMM 33-51-04-902-001-001, REV 90.02. PERFORMED POWER SUPPLY TEST IAW AMM 33-51-04-902-001-001, REV 90.02.SDR DALA2017101307477Battery Pack · inoperativeBOTH AFT (RT & LT) OVERWING EMERGENCY EXIT CABIN LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REPLACED THE AFT OVERWING EMERGENCY LIGHT BATTERY IAW AMM 33-51. THE AIRCRAFT IS OK FOR SERVICE.SDR CNMA201710250002Power Supply · inoperativeL2 AFT EMERGENCY LIGHT INOP. REPLACE POWER SUPPLY IAW AMM 33-51. OPS CHECK GOOD.SDR IPXA2017101222534Relay · inoperativeEMERGENCY EXIT LIGHT OVER THE L1 DOOR FOUND INOPERATIVE. R & R THE EXIT SIGN RELAY IAW AMM 33-51-00, OPS CHECKED GOOD.SDR AALA201710169043Lens · detachedEMERGENCY LIGHT LENS BY THE L1 DOOR, DETACHED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201710139023Light · missingEMERGENCY LIGHT AT THE BOTTOM OF THE FIRST CLASS CLOSET DOOR IS MISSING. REPLACED THE LIGHT ASSEMBLY IAW ESO 20632, AND CMM 25-02-43. OPS CHECKED GOOD.SDR AALA201710139022Sign · detachedEMERGENCY EXIT SIGN BY THE R4 DOOR HAS DETACHED. REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20171013003Power Supply · no testEMERGENCY LIGHTS AT ROWS 7 - 12 FAILED. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR SWAA2017101717150Light · missingLEFT AFT CABIN AISLE EMERGENCY LIGHT MISSING. INSTALLED THE LIGHT IAW DWG.SDR AALA20171013001Battery · no testEMERGENCY LIGHT BATTERY BITE TEST FAILED (12WL). REPLACED THE BATTERY PACK IAW AMM 33-51-38.SDR SWAA2017101617129Lens · looseLEFT EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2017101617096Lens · detachedLEFT FORWARD EMERGENCY SIGN LENS DETACHED. R & R THE SIGN ASSEMBLY IAW AMM.SDR SWAA2017101617088Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017101617086Sign · destroyedCENTER CABIN EXIT SIGN DESTROYED. R & R THE SIGN IAW AMM.SDR SWAA2017101617081Light · inoperativeRT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW MM.SDR SWAA2017101617061Switch · faultyCABIN EMERGENCY EXIT LIGHTS ILLUMINATED ON TAKEOFF. R & R THE SWITCH IAW WDM AND AMM.SDR DALA2017101607541Light · inoperativeROWS 18D AND 32D. AISLE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT ASSY. OPS NORMAL. OK FOR SERVICE.SDR DALA2017101300245Lens · looseEMERGENCY EXIT SIGN COVER LOOSE. SECURED EXIT SIGN LENS.SDR DALA2017101300242Battery · failedDURING A R3 DOOR SLIDE CHANGE, CIDS FAULTED BCCR, EPSU BATTERY. REPLACED THE BATTERY.SDR DALA2017101200240Power Supply · no testEPCU AT THE R2 DOOR FAILED TO TEST. REPLACED THE POWER SUPPLY.SDR DALA2017101200239Power Supply · no testEPCU AT THE L2 DOOR FAILED TO TEST. REPLACED POWER SUPPLY AND REPAIRED SHORTED PIN AT SEAT 17A.SDR QXEA2017101300614Light · looseEMERGENCY LIGHT NEAR THE FWD GALLEY IS COMING LOOSE. SECURED THE LIGHT. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR DALA2017101307503Light · detachedL2 DOOR EMERGENCY EXIT SIGN WAS KNOCKED OFF. REINSTALLED THE LIGHT CHECKED GOOD.SDR IPXA2017101222554Power Supply · overheatedELECTRICAL BURNING ODOR IN THE COCKPIT WITH NO APU RUNNING. FOUND EPSU AND BATTERY MELTED. REMOVED EPSU & BATTERY IAW AMM 33-51-14-0401. INSTALLED A NEW ESPU AND BATTERY IAW AMM 33-51-14-0401. OPS CHECKED GOOD.SDR AALA201710139006Power Supply · failedDURING EMERGENCY LIGHT TEST, THE LEFT OVERWING EXIT 11WL EMERGENCY POWER SUPPLY UNIT BATTERY FAULTED.SDR AALA201710139002Power Supply · failedEMERGENCY LIGHT TEST FAILED. REPLACED FORWARD LEFT ESPU.SDR AALA201710139001Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS IS MISSING. REPLACED THE LENS, OK FOR SERVICE.SDR DALA2017101307470Battery Pack · inoperativeEMERGENCY LIGHTS IN CEILING BETWEEN ROWS 16-23 FOUND INOPERATIVE. REPLACED THE BATTERY PACK B5-102. CHECKED GOOD.SDR REXA2017101201086Light · corrodedDURING WALK AROUND, NOTICED EMERGENCY LIGHT ABOVE WING CORRODED. REPLACED THE LAMP EMERGENCY LIGHT IAW CRJ 200 AMM 33-51-21-04. OPS CHECKS GOOD. P/N ON/OFF: 1317SDR YENA201710120834Power Supply · failedSEAT ROWS 1 AND 5 EMERGENCY LIGHTS INOPERATIVE. R & R EPSU IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SWAA2017111517777Light · brokenAFT LAVATORY EMERGENCY LIGHT BROKEN. R & R THE LIGHT IAW AMM.SDR SWAA2017101617092Light · inoperativeRIGHT EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR AALA201710139010Lens · detachedR1 DOOR EMERGENCY EXIT LIGHT LENS DETACHED AT BOTTOM. SECURED THE LENS. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201710139018Light · damagedEMERGENCY LIGHT BY THE R2 DOOR IS DAMAGED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SIMA20171011003Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMPS IAW AMM 33-50-09-000-801-A, AND 33-50-09-400-801-A.. OPS CHECKED GOOD.SDR DALA2017101207488Lens · missingEMERGENCY EXIT ROW AT SEAT 9C RED LENS MISSING. INSTALLED THE LENS WITH PROPER RED LENS IAW AMM 33-51-04, OK FOR SERVICE.SDR IPXA2017101222530Battery Pack · dischargedFOUND THE EXIT SIGN AFT OF COCKPIT NOT ILLUMINATED. REPLACED THE BATTERY PACK M5169 IAW AMM 33-51-04-902-001-001, REV 90.02.SDR AALA201710129010Lens · unsecureR1 DOOR FLOOR LEVEL EXIT SIGN LENS DETACHED. SECURED THE LENS IAW AMM.SDR AALA201710129009Lens · missingEMERGENCY EXIT LIGHT LENS MISSING FROM THE L4 DOOR. REPLACED EMERGENCY LIGHT LENS IAW AMM.SDR AALA201710129007Power Supply · faultyEMERGENCY POWER SUPPLY UNIT BATTERY FAULT ON CIDS PANEL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY.SDR AALA201710129006Lamp · intermittentL3 DOOR EXIT LIGHT BLINKS INTERMITTENTLY. REPLACED THE LAMPS IAW AMM.SDR ASAA2017101122177Lens · damagedEMERGENCY EXIT SIGN ADJACENT TO RIGHT FORWARD OVERWING EXIT HAS A DAMAGED LENS. ACFT GROUNDED. REMOVED AND REPLACED THE LENS AND TESTED THE LIGHT ASSEMBLY IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2017101122176Bulb · failedEXTERIOR SLIDE EMERGENCY LIGHT ON OUTSIDE FUSELAGE, ADJACENT TO L2 DOOR IS INOPERATIVE. ACFT GROUNDED. REPLACED THE BULB AND TESTED IAW AMM 33-51-04-960-801. OPS NORMAL.
Back to JASC 3350