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 AALA201706269049Lens · brokenTHE AIRCRAFT WAS NOT GROUNDED. WHITE EMERGENCY LIGHT LENS BROKEN IN Y C GALLEY. REPLACED EMERGENCY LIGHT LENS IN FWD GALLEY IAW AMM 33-51-01. OPS CHECK OK.SDR SIMA20170623003Charger · failedEXTERIOR EMERGENCY LIGHT NR 4, JUST AFT OF THE RT OVERWING EXIT IS ALWAYS ILLUMINATED. REMOVED AND REPLACED THR NR 3 EPSU IAW AMM 33-51-17. OPS CHECKED GOOD.SDR IPXA2017062318552Bulb · inoperativeFOUR BULBS INOPERATIVE IN EMERGENCY LIGHT. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR JJBA20170623014Inverter · failedCABIN RED EXIT SIGN INOPERATIVE. R & R THE INVERTER. OPS CHECKED SATISFACTORY.SDR DALA2017062504936Epsu · defectiveDURING A CHECK, FOUND EPSU BAD AT DOOR 2R. REPLACED EPSU AT DOOR 2R.SDR CALA2017062301971Battery Pack · malfunctionedWHEN DOING CIDS TEST, MESSAGE IWT LOAD EMERG L WAS GIVEN. RESET BATTERY PACK. CIDS TEST PASS REF MM 33-51-38-401.SDR CALA2017062301968Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK AT M1673 CHARGER FAILS CAPACITY CHECK. REPLACED BATTERY PACK AT M1673 CHARGER AND RE-TESTED CAPACITY, CHECKS GOOD IAW AMM 33-51-06.SDR CALA2017062301967Light · inoperativeEXTERIOR EMERGENCY LIGHT LEFT SIDE BETWEEN EXIT HATCHES INOP. REMOVED AND REPLACED LAMP ON EXT EMERGENCY LIGHT LEFT SIDE BETWEEN EXIT HATCHES REF AMM 33-51-04, OPS CHECK GOOD.SDR CALA2017062301966Fuse · faultyEMERGENCY LIGHTS OUT FROM ROW 15-23. REPLACED FUSE IN EMERGENCY BATTERY PACK CHARGER AT SIDEWALL FWD OF LEFT FWD EMERGENCY EXIT. OPS CK GOOD.SDR CALA2017062301965Light · inoperativeEMERGENCY LIGHT OVERHEAD ROW 11ABC INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT IAW MM 33-51-03.SDR CALA2017062301964Battery · inoperativeEMERGENCY LIGHTS ABOVE L1 DOOR INOPERATIVE. REPLACED THE BATTERY. OP CHECKED GOOD IAW AMM 33-51-06.SDR CALA2017062301960Lamp · inoperativeRIGHT AFT OVERWING EMERGENCY EXIT INTERIOR FORWARD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED OKSDR CALA2017062301959Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED OK.SDR CALA2017062301958Lens · brokenAISLE EMERGENCY LIGHT BROKEN AT SEAT 7ABC. INSTALLED NEW LENS. OPS NORMAL.SDR CALA2017062301957Battery Pack · inoperativeDURING CHECK, FOUND THE R1 DOOR EMERGENCY EXIT SIGN ABOVE FLIGHT DECK DOOR INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-51-06-960-805. OPS CHECKED GOOD. OK FOR SERVICE.SDR CALA2017062301956Lens · wrong partEMERGENCY EXIT SIGN ON LOWER WALL BY THE L4 DOOR MAY BE INCORRECT TYPE APPEARS TO BE OVERWING TYPE. REPLACED THE LENS.SDR CALA2017062301954Cover · missingEXIT ROW SEAT 21F EXIT SIGN COVER IS MISSING. INSTALLED THE COVER AS REQUIRED.SDR CALA2017062301953Cover · detachedEMERGENCY EXIT SIGN COVER AT ROW 21 ABC FELL OFF AND WAS LAYING IN SEAT. I NSTALLED THE COVER. NO FURTHER ISSUESSDR CALA2017062301950Sign · detachedEMERGENCY LIGHT MID ACFT, CAME DOWN AFTER LANDING. SECURED THE SIGN IAW AMM 33-15-02, OPS CHECKED GOOD.SDR CALA2017062301949Lens · missingROW 8E SIDE EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS .SDR CALA2017062301948Light · inoperativeEMERGENCY LIGHT AT SEAT 19KJA INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED GOOD IAW AMM 33-50-00.SDR CALA2017062301947Socket · dirtyEMERGENCY LIGHT AT RT FAIRING SECOND LIGHT ASSY AFT INOPERATIVE. CLEANED LIGHT SOCKET AND REPLACED THE LAMP IAW AMM 33-51-03-962-001. OPS CHECKED GOOD.SDR CALA2017062301945Light · missingSEAT 3E FWD EMERGENCY LIGHT ASSY MISSING. REPLACED SEAT 3E EMERGENCY LIGHT ASSY, OPS CHECKED GOOD.SDR CALA2017062301944Lens · missingEMERGENCY LIGHT ON DIVIDER IN FRONT OF SEAT 16D LENS IS MISSING . REPLACED THE LENS, OK TO CONTINUESDR CALA2017062301935Charger · inoperativeR3 DOOR EMERGENCY LIGHT FOUND DIM. THE BATTERY PACK AND CHARGER WERE REPLACED, OPS TESTED NORMAL IAW AMM 33-51-01.SDR CALA2017062301934Battery · failedR1 DOOR EMERGENCY LIGHT FOUND DIM. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2017062301933Battery · no testR1 DOOR EMERGENCY LIGHT FOUND DIM. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR FDEA201706231747Power Supply · damagedFORWARD CABIN OVERHEAD EMERGENCY EXIT LIGHTS FLICKER ON AND OFF DURING TURBULENT CONDITIONS, CLIMB, AND DESCENT. REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY AND BATTERY IAW AMM 33-51-14-04. OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2017062304896Battery · dischargedEMERGENCY CEILING LIGHTS FROM ROWS 15 THRU 19 AND EMERGENCY CEILING EXIT SIGN INOP. MAINTENANCE REPLACED EMERGENCY LIGHTS BATTERY POWER SUPPLY B5-120 PER AMM 33-51-03, OPS CK GOOD.SDR SWAA2017071715062Light · brokenG1 GALLEY EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT IAW AMM.SDR SWAA2017062714632Battery · failedEMERGENCY EXIT LIGHT BATTERY M1672 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2017062714627Battery · failedEMERGENCY EXIT LIGHT BATTERY M1669 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2017062714620Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR AALA201706269030Module · not seatedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 2A AFT IS INOPERATIVE. SEATED THE LIGHT MODULE IAW AMM 33-51-10. OPERATIONAL CHECKED GOOD.SDR AALA201706269048Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. PLASTIC COVER ON EMERGENCY EXIT LIGHT IS MISSING AFT LAV E. INSTALLED NEW E EXIT COVER AT AFT LAV E WALL PER AMM 33-50-00. OPS CHECKS NORMAL.SDR SWAA2017062614607Light · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 1. R & R THE EMERGENCY LIGHT IAW MM.SDR SWAA2017062614605Lamp · inoperativeL1 EMERGENCY EXIT SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017062614584Lamp · inoperativeR1 EMERGENCY EXIT SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017062614583Lens · looseL2 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. R & R THE LIGHT IAW AMM.SDR AALA201706239030Battery Pack · failedEMERGENCY EXIT LIGHTS OVER THE R2 DOOR, BESIDE THE L2 DOOR, AND AT THE BULLNOSE OVER ROW 13 RIGHT ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA201706239023Power Supply · failedEMERGENCY EXIT LIGHTS OVER THE R2 DOOR, BESIDE THE L2 DOOR, AND AT THE BULLNOSE OVER ROW 13 RIGHT ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK (AALA201706239030) IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201706239002Lens · brokenR3 DOOR EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS IAW MM 33-51-13.SDR AALA201706249013Cover · brokenTHE AIRCRAFT WAS NOT GROUNDED. THE EMERGENCY EXIT SIGN COVER AT THE FWD ENTRY HAS DOOR HAS FALLEN DOWN AND APPEARS TO BE BROKEN. REPLACED EMERGENCY EXIT SIGN COVER WITH NEW AT FWD ENTRY DOOR . OPS CHECK NORMAL.SDR CALA2017062301932Lens · wrong partR3 DOOR UPPER EXIT SIGN ARROW FOUND WRONG. REPLACED AND CHECKED, FOUND NORMAL IAW AMM 33-51-01-960-802, REV 80.SDR AALA201706239020Lens · missingEMERGENCY LIGHT LENS MISSING OUTSIDE LAVATORY L38. REPLACED THE LENS.SDR AALA201706239018Lens · missingEMERGENCY LIGHT LENS MISSING OUTSIDE LAVATORY L53. REPLACED THE LENS.SDR AALA20170622006Lens · missingEMERGENCY EXIT CEILING LIGHT NEAR SEATS 26G AND 25H HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR AALA201706239011Lens · missingEMERGENCY EXIT SIGN LENS MISSING. INSTALLED THE LENS.SDR AALA201706239010Lens · missingEMERGENCY LIGHT LENS MISSING AT THE L1 DOOR. REPLACED THE LENS IAW AMM 33-51-18.SDR AALA201706239007Light · inoperativePAX SEAT AT ROW 1, EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT.
Back to JASC 3350