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 AALA201707189008Panel · mislocatedRIGHT OVERWING EMERGENCY EXIT LIGHT CAME ON IN FLIGHT. INSTALLED THE RT EMERGENCY OVERWING EXIT PANEL.SDR SIMA20170717002Light · inoperativeCABIN EMER LTS FLR LVL TRACK EXIT SIGN LT EMERGENCY EXIT FLOOR LIGHT HAS BULBS BURNT OUT. RELAMPED LT EMERGENCY EXIT ROW FLOOR LIGHTING MARKER IAW AMM 33-51-05. OPC GOOD IAW AMM 33-51-00-710-802. NO OTHER DEFECTS NOTED. MEL RESTORED.SDR AALA201707199018Lens · crackedTHE AIRCRAFT WAS NOT GROUNDED. LEFT SIDE AFT GALLEY AREAS EMERGENCY LIGHT ASSY. EXIT LENS COVER CRACKED - LIGHT TEST AND WORK OK. REMOVED AND REPLACED LENS ON EMERGENCY LIGHT ASSY. AFT GALLEY LEFT SIDE AS REQUIRED. OPS CHECK OK IAW AMM 33-51-01, OK FOR SDR AALA201707199007Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. CENTER EXIT SIGN ACCESS COVER. REPLACED MISSING COVER IAW AMM 33-51-01.SDR AALA201707189018Lens · brokenTHE AIRCRAFT WAS NOT GROUNDED. 14F EXIT SIGN LENS BROKEN. REPLACED EXIT LIGHT ASSY PER AMM 33-51-01. OPS CHECKS OK.SDR DALA2017071805539Power Supply · inoperativeRT EXTERIOR EMERGENCY LIGHT WILL NOT TEST. REPLACED THE EMER LIGHT POWER SUPPLY & CHECKED OK.SDR SWAA2017071915158Lens · looseRT OVERWING DOOR EMERGENCY EXIT LENS LOOSE. SECURED LENS PER EA.SDR SWAA2017071915157Light · inoperativeLT EMERGENCY ESCAPE HATCH AFT LIGHT INOP. RELAMPED PER AMM.SDR SWAA2017071915152Cover · missingLT OVERHEAD EMERGENCY LIGHT LENS COVER MISSING AT ROW 19. R&R COVER ASSEMBLY PER SIP.SDR AALA201707199014Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT SYSTEM TEST FAILS BATTERY PACK AT 15WL. REPLACED BATTERY PACK 15WL PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707199013Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT SYSTEM TEST FAILS BATTERY PACK AT 12WL. REPLACED BATTERY PACK AT 12WL PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR F3LA2017071900186Battery · failedEPSU 10WL BATTERY FAILED TO TEST. REMOVED & REPLACED THE BATTERY AND OPERATIONAL CHECKED OK IAW AMM 33-51-38, PAGE BLOCK 401.SDR F3LA2017071900185Battery · no testEPSU 12WL BATTERY FAILED TEST. REMOVED & REPLACED EMERGENCY POWER BATTERY IAW AMM 33-51-38, PB 401. EPSU TESTED GOOD.SDR RAIA201707170001Lens · crackedPAX DOOR SWING ARM EMERGENCY LIGHT HAD A CRACKED LENS. R & R EMERGENCY LIGHT LENS, OPS CHECKED GOOD.SDR YENA201707170586Power Supply · inoperativeDURING HEAVY MAINTENNACE, EPSU EMERGENCY LIGHT FAULT ON PTP. R & R THE LT EPSU 11WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SIMA20170717001Light · inoperativeSERVICE DOOR EXIT EMERGENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10-000-801, AND 33-50-10-400-801. OPS CHECKED GOOD.SDR CALA2017071702279Battery · faultyEPSU EMERG BATT L AND EPSU EMERG BATT R MESSAGES GENERATED DURING EMERGENCY SYSTEM TEST REMOVED AND REPLACED EPSU BATTERIES AT LT AND RT OVER WING POSITIONS OP TEST PASS REF AMM 33-51-33.SDR CALA2017071702270Light · inoperativeL1 SLIDE LIGHT INOP. RELAMP L1 SLIDE LIGHT IAW AMM 33-51-04-960-801. OPS CHECK GOOD.SDR CALA2017071702267Sign · looseEMERGENCY EXIT SIGN INOP AT FIRST ROW OF COACH. SECURED EXIT SIGN, OK FOR SERVICE.SDR CALA2017071702274Lens · missingFWD CLOSET 712-EMERGENCY LIGHT COVER MISSING. REPLACED EMERGENCY LIGHT COVER LIGHT. OPS CK GOOD.SDR CALA2017071702271Power Supply · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM ROW 22ABC TO 28ABC, 7 ROWS INOP. R&R POWER SUPPLY AFT LEFT POSITION UNDER SEAT ROW 28 ABC IAW AMM 33-51-06-960-806. OPS CHECK GOOD.SDR CALA2017071702269Light · inoperativeRIGHT AFT EXTERIOR EMERGENCY LIGHT LAMP BURNED OUT. (BY R3 DOOR) R&R R3 AFT EXT EMER LAMP. CKD OK.SDR CALA2017071702268Battery Pack · dischargedWITH NO GND POWER DUE TO RAMP CLOSURE, THE EMER EXIT LIGHTS ON. SWITCH DID NOT WORK. REMOVED AND REPLACED BATTERY PACK AT M731 PER AMM 33-51-07, BATTERY PACK CAPACITY TEST GOOD.SDR CALA2017071702266Light · inoperativeEMERGENCY LIGHT LAMP OUTSIDE DOOR 2R IS BURNED OUT. REMOVED AND REPLACED LAMP IAW AMM 33-51-04.SDR CALA2017071702281Light · inoperative2L DOOR SLIDE ARMED LITE INOP. RELAMPED 2L DOOR SLIDE LIGHT. OPS CHECK NORMAL.SDR CALA2017071702277Cover · unsecureLEFT WING EMERG EXIT COVER FELL OFF. RE-INSTALLED PANEL.SDR CALA2017071702272Sign · unsecureEMERGENCY EXIT SIGN HAS FALLEN OFF. PLACED EMERGENCY SIGN BACK TO ITS PROPER PLACE.SDR CALA2017071702264Light · inoperativeFLOOR EMERGENCY LIGHT DOES NOT TURN ON AT 24C. REPLACED HOUSING AND BACK PLATE, TESTED OKSDR DALA2017071705509Battery Pack · inoperativeEMERGENCY LIGHTS IN FLIGHT DECK AND FWD GALLY INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-53. LIGHTS TESTED GOOD. ACFT OK FOR SERVICE.SDR MASA2017071712468Light · malfunctionedAFT CABIN EMERGENCY LIGHT FLICKERING. NO DEFECTS NOTEDSDR YENA201707160575Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R THE BATTERY PACK 13WL . EMERGENCY LIGHT TESTED OK IAW AMM 33-51-38.SDR JJBA20170717020Light · unknownEMERGENCY CEILING LIGHT AT MID CABIN IS INOPERATIVE ON AFT SIDE. OPS CHECKED GOOD.SDR SWAA2018060522539Light · brokenFORWARD ENTRY EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY IAW MM.SDR HALA2017072000202Light · detachedFC EMERGENCY LIGHT IS UNSECURE. SECURED THE EMERGENCY LIGHT. SECURITY CHECKED GOOD. OK TO CONTINUE.SDR HALA2017071700201Light · unsecureFIRST CLASS EMERGENCY LIGHTING IS OFF TRACK. SECURED THE EMERGENCY LIGH.SDR DALA2017071705545Light · looseSEAT 39DEF SEAT MOUNTED EMERGENCY LIGHT ASSY LOOSE. SECURED SEAT MOUNTED EMERGENCY LIGHT ASSY.SDR DALA2017071705543Lens · brokenR2 DOOR EXIT SIGN BROKEN. REATTACHED THE LENS.SDR SWAA2017071915155Lens · unsecureR1 DOOR EXIT LIGHT LENS FELL OFF. R&R LIGHT ASSEMBLY PER AMM.SDR AALA201707189004Sign · brokenEMERGENCY EXIT SIGN AT R4 DOOR IS BROKEN OFF LOWER FASTNERS. MAINTENANCE REPLACED THE EXIT SIGN IAW AMM 33-51-13.SDR AALA201707189003Sign · brokenEMERGENCY EXIT SIGN AT THE L4 DOOR IS BROKEN OFF LOWER FASTNERS. MAINTENANCE TO REPLACE EXIT SIGN IAW AMM 33-51-13. REPLACED EXIT SIGN PER MM 33-51-13.SDR AALA201707179062Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT PLASTIC COVER BY AFT RIGHT SERVICE DOOR IS MISSING. REPLACED EMERGENCY EXIT SIGN ASSEMBLY PER AMM 33-51-01, OPERATION CHECK NORMAL.SDR AALA201707179061Cover · brokenTHE AIRCRAFT WAS NOT GROUNDED. F/C GALLEY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED F/C GALLEY EXIT EMERGENCY LIGHT ASSY PER AMM 33-50-00. OPS CKS NORMAL.SDR AALA201707179060Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. RIGHT AFT DOOR EMERGENCY EXIT SIGN COVER MISSING. REPLACED RIGHT AFT DOOR (GALLEY) EMERGENCY EXIT SIGN IAW AMM 33-51-00 OK FOR SVC.SDR AALA201707179059Sign · damagedTHE AIRCRAFT WAS GROUNDED. R1 EMERGENCY EXIT LENS MISSING AND LIGHT ASSEMBLY DAMAGED (LENS MISSING AND LIGHT ASSEMBLY CRACKED) UPON LANDING. REPLACED R1 ENTRY DOOR EMERGENCY EXIT SIGN ASSEMBLY AND LENS TEST GOOD PER AMM33-51-01.SDR AALA201707179058Power Supply · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BATTERY PACK M1695 INOP. REPLACED POWER SUPPLY AND OPS CHECKED IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2017071815151Light · brokenFORWARD ENTRY EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017071815146Battery Pack · dischargedLT EMERGENCY EXIT LIGHT INOP BETWEEN SEAT ROWS 14 TO ROW 24. R&R BATTERY PACK PER AMM & WDM.SDR AALA201707179052Light · damagedSEAT MOUNTED EMERGENCY PATH LIGHTS AT SEATS 6A DAMAGED. REPLACED SEAT MOUNTED EMERGENCY PATH LIGHTS AT SEATS 6A.SDR AALA201707179051Lens · missingCABIN DOOR 1R EMERGENCY EXIT LIGHT LENS BROKEN/MISSING AT SLIDE FLOOR LIGHT. INSTALLED MISSING LENS COVER AT EXIT 1R EXIT AS REQUIRED.SDR AALA201707179048Lens · missingR4 DOOR WALL MOUNTED EXIT SIGN LENS MISSING. REPLACED LENS PER AMM
Back to JASC 3350