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 AALA201802079005Lens · missingR3 EXIT SIGN LENS MISSING. INSTALLED THE LENS AND SECURED THE SIGN. OK FOR SERVICE.SDR AALA20180206003Light · inoperativeDURING AN OVER NIGHT INSPECTION, FOUND THE EMERGENCY LIGHT INOPERATIVE AT SEAT 30D. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201802079010Lens · missingEXIT SIGN LENS IS MISSING, AT THE LEFT AFT GALLEY DOOR. REPLACED THE EXIT SIGN LENS IAW 33-51-01.SDR DALA2018020600749Lens · detachedAMBER LENS ON THE EMERGENCY LIGHT CAME OFF AND WAS LOST IN THE FLT DECK. REPLACED THE LENS.SDR DALA2018020600744Battery Pack · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK.SDR DALA2018020600733Charger · inoperativeEMERGENCY ISLE LIGHTS INOPERATIVE AT ROWS 15 FG TO 20 FG. REMOVED AND REPLACED THE BATTERY AND CHARGER IAW AMM 33-51. OPS CHECKED NORMAL.SDR DALA2018020600715Battery Pack · dischargedAFT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-230 IAW MM. OPERATION CHECKS GOOD.SDR DALA2018020600714Battery Pack · dischargedCEILING EMERGENCY LIGHTS INOPERATIVE. REPLACE BATTERY PACK B5-227 IAW MM. OPERATION CHECKS GOOD.SDR SWAA2018020619540Cover · brokenAFT EMERGENCY EXIT LIGHT COVER BROKEN OFF. R&R LIGHT ASSEMBLY PER AMM.SDR AALA201802059044Housing · brokenSEAT 19C AISLE EMERGENCY LIGHT HOUSING BROKEN. REPLACED THE EMERGENCY LIGHT HOUSING IAWAMM 33-51-18.SDR ASAA2018020423392Light · inoperativeR-2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. GROUNDED - YES. RELAMPED PER AMM 33-51-04-960-801. OPS CHECK GOOD.SDR FDEA201802040302Light · inoperativeON POST FLT FOUND L1 DOORWAY FWD EMERGENCY EXIT LIGHT HALF LED'S BURNED OUT. REMOVED AND REPLACED L1 DOORWAY FWD EMERGENCY EXIT LIGHT IAW AMM 33-51-01-2 AND OPS CHECK GOOD. A/C OK FOR SERVICESDR AALA201802059028Lens · brokenROW 16 LEFT EMERGENCY LIGHT HAD BROKEN LENS. REPAIRED IAW AMM 33-51-19.SDR AALA201802059022Sign · brokenR4 DOOR EXIT SIGN BROKEN OFF. REPLACED THE SIGN IAW AMM 33-51-03.SDR DALA2018020400669Light · damagedSEAT 1C, MOUNTED EMERGENCY LIGHT PUSHED INTO THE SEAT. SECURED THE EMERGENCY LIGHT AND LENS.SDR Q2SA20180204388Battery · inoperativeEMERGENCY LIGHTS WILL NOT TEST. AIRCRAFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW MM 33-51-51, OPS TESTED GOOD.SDR CALA2018020400480Light · inoperativeFLIGHT DECK DOME LIGHT EEL BULB IS INOP. REPLACED EEL BULB IN FLT DECK DOME LIGHT ASSY. REF AMM 33-14-960 -804, OPS. CHK GOOD. IPC REF 33-17-00-02, ITEM 65.SDR CALA2018020400479Lens · out of positionEMERGENCY LIGHT COVER BEHIND LEFT 1ST CLASS CLOSET IS BROKEN. LENS NOT BROKEN WAS OUT OF PLACE SECURED LENS OK TO CONTINUE.SDR CALA2018020400476Cover · missingSEAT 20C EMERGENCY LIGHT LENS COVER MISSING RPL EMERGENCY LIGHT.SDR CALA2018020400475Cover · missingDOOR 1L SLIDE LITE COVER MISSING. REPLACED MISSING SLIDE LIGHT AT DOOR 1L.SDR SWAA2018030120164Light · brokenEMERGENCY EXIT LIGHT FIXTURE ATTACH MOUNTS BROKEN AT BS 616+11. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2018020819605Switch · brokenFLIGHT COMPARTMENT EMERGENCY LIGHT SWITCH COVER BROKEN. R&R SWITCH GUARD PER SIP.SDR SWAA2018020819599Battery Pack · dischargedFORWARD CABIN EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018020819596Cover · missingRT AFT OF OVERWING EXIT ROW EXIT SIGN LENS COVER MISSING. INSTALLED COVER PER AMM.SDR SWAA2018020819583Lens · missingRIGHT EMERGENCY EXIT SIGN LENS MISSING. INSTALLED A NEW LENS IAW AMM.SDR SWAA2018020819564Lens · looseLEFT OVERWING LOWER EMERGENCY LIGHT LENS FOUND LOOSE. R & R THE LENS IAW AMM.SDR AALA201802079009Lens · looseEXIT DOOR EMERGENCY LIGHT LENS IS LOOSE. REPLACED THE EXIT SIGN IAW 33-51-01.SDR DALA2018020500737Lens · brokenROW 26DEF HAS ONE RED EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS, OPS CHECKED NORMAL.SDR R61A201802030136Battery · inoperativeBATTERY FAULT ON EICAS COMES ON ONLY IN THE ON POSITION. R & R THE AFT EMERGENCY BATTERY IAW AMM 33-50-00.SDR R61A201802030135Battery · inoperativeL2 EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY IAW AMM 33-50-00. OPS CHECKED GOOD.SDR R61A201802030134Battery · inoperativeCOCKPIT DOME EMERGENCY LIGHT DOES ILLUMINATE WHEN EMERGENCY LIGHT SYSTEM TESTED. R & R THE BATTERY. LIGHT CAME ON IAW AMM 33-50-00.SDR AALA201802059052Housing · brokenSEAT 25 AISLE PATH LIGHT HOUSING BROKEN. AIRCRAFT WAS GROUNDED. REPLACED THE EMERGENCY LIGHT HOUSING.SDR ASAA2018020323398Lens · detachedPLASTIC COVER FOR EXIT LIGHT AT R2 DOOR IS DETACHED. GROUNDED - YES. INSTALLED NEW EMERGENCY EXIT LIGHT LENS AT R2 DOOR. OPS CHECKS GOOD.SDR AALA201802059048Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY FAILED TEST. REPLACED POWER SUPPLY UNIT (12WL) PER AMM 33-51-38.SDR SIMA20180203002Lamp · abnormalPAX DOOR EXT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMPS IAW AMM 33-51-15. OPS CHECKED GOOD IAW AMM 33-51-15-710-801-A01.SDR AALA201802059023Sign · detachedR1 DOOR EXIT MARKER BROKEN OFF LOWER FASTENER. THE AIRCRAFT WAS GROUNDED. REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-13.SDR REXA2018020300079Bulb · inoperativeRIGHT NR 2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM 33-51-21. OPS CHECKED GOOD.SDR REXA2018020300078Bulb · inoperativeLEFT NR 1 EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM 33-51-21. OPS CHECKED GOOD.SDR AALA201802059043Housing · brokenAIRCRAFT WAS GROUNDED. SEAT 22 AISLE PATH LIGHT HOUSING BROKEN. REPLACED SEAT 22 AISLE PATH LIGHT HOUSING. (SEE CONTROL #AALA201802059052)SDR AALA201802059042Housing · brokenAIRCRAFT WAS GROUNDED. SEAT 17C EMERGENCY LIGHT HOUSING BROKEN. REPLACED THE EMERGENCY LIGHT HOUSING AT SEAT 17C PER CMM 25-22-52.SDR AALA201802059037Cover · detachedR4 EXIT LIGHT COVER FELL OFF. REPLACED THE EMERGENCY LIGHT COVER.SDR IPXA2018020326141Battery Pack · no testEMERGENCY LIGHT TEST FAILED. R & R THE EMERGENCY LIGHT BATTERY IAW MM 33-51-01 AND OPS CHECKED IAW MM 33-51-01. OK FOR SERVICE.SDR DALA2018020500635Battery Pack · defectiveDURING SVC FOUND 5 OVERHEAD EMERGENCY LIGHTS INOP IN FIRST CLASS. RELAMPED. NO HELP. R&R BATTERIES IN BATTERY PACK B5-100. NO HELP. R&R BATTERY PACK ASSY B5-100 PER WDM 33-51-12. EMERGENCY LIGHTS NOW OPS OK.SDR CALA2018020300468Unknown · malfunctionedEMERGENCY LIGHTS WILL NOT SHUT OFF IN ANY POSITION OF SWITCH. CIDS RESET NO HELP. POWER DOWN NO HELP. CYCLED NO SMOKING SWITCH LIGHTS WENT OFF EMERGENCY LIGHTS TESTS GOOD.SDR CALA2018020300467Lens · missingEMER LIGHT FWD CUPBOARD MISSING COVER. REPLACED MISSING EMERGENCY LIGHT LENS ON FORWARD CABINET.SDR CALA2018020200428Sign · crackedSPEC NO.B777-53-3-6219 - DOOR 1R, 2L, 3R, 4R AFT EMERGENCY EXIT IDENTIFIERS BASE FOUND CRACK MARK. THE DEFECTIVE EXIT IDENTIFIERS REPLACED THE LIGHT TEST PERFORMED AND THE RESULT WAS NORMAL AS PER AMM 33-51-01-960-802 REV.81.SDR SWAA2018020819609Battery Pack · dischargedAFT RT EMERGENCY LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA2018020819603Light · inoperativeRT OVERWING EXIT DOOR LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018020819597Lens · brokenL1 DOOR LOWER FORWARD EMERGENCY LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2018020819577Cover · damagedL2 DOOR EMERGENCY LIGHT COVER DAMAGED. R&R COVER AMM.
Back to JASC 3350