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 ASAA2017042020509Cover · missingFA REPORTS EXIT SIGN COVER FOR L2 DOOR MISSING. EXIT IDENTIFIER LIGHT. GROUNDED - YES. REMOVED & REPLACED L2 DOOR EXIT SIGN.SDR AALA201704219019Lens · missingLENS FOR EMERGENCY EXIT LIGHT IS MISSING. REPLACED LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704219013Battery · no testDURING A SERVICE CHECK, RECIEVED FAULTS INDICATIONS FOR EMERGENCY POWER SUPPLY UNIT 12WL. REPLACED BATTERY AT 12WL IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL TESTSDR AALA201704219012Battery · no testDURING A SERVICE CHECK, RECIEVED FAULTS INDICATIONS FOR EMERGENCY POWER SUPPLY UNIT 11WL. REPLACED BATTERY AT 11WL IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA201704219009Sign · detachedFLIGHT ATTENDANTS REPORT THE ROW 9 EXIT SIGN DETACHED. MAINTENANCE SECURED EXIT LIGHT PER 33-50-00.SDR AALA201704219008Lens · missingMISSING CEILING MOUNTED EMERGENCY EXIT LIGHT AT THE R4 DOOR. MAINTENANCE INSTALLED EXIT LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704219007Lens · missingMISSING EMERGENCY LIGHT LENS COVER. INSTALLED THE LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704219005Cover · missingMISSING COVER ON EXIT LIGHT AT THE L4 DOOR. REPLACED EXIT LIGHT COVER IAW AMM 33-50-00.SDR SIMA20170420001Battery Pack · inoperativeDURING PS-2 INSPECTION FOUND LT EXTERIOR AFT OVERWING LIGHT INOPERATIVE. REMOVED AND REPLACED NR3 BATTERY AND CHARGER IAW AMM 33-50-04. REMOVED AND REPLACED LT EXTERIOR AFT OVERWING LIGHT BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR REXA2017042000528Battery Pack · inoperativeAFT EMERGENCY LIGHTS INOPERATIVE. R & R AFT EMERGENCY BATTERY PACK IAW AMM 33-51-17. OPS CHECKED GOOD.SDR VNAA2017042000024Light · malfunctionedEMERGENCY LIGHTS FLASHING IN CABIN AND EXTERIOR.SDR DALA2017042103296Lens · unknownEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. SECURED PLASTIC EXIT COVER OVER 2R DOOR.SDR CALA2017042101075Light · inoperativeRIGHT WING TRAILING EDGE OVAL EMERGENCY LIGHT HAS ONE LAMP OF TWO OUT. REMOVED AND REPLACED THE LIGHT ASSY IAW SRM 51-010-02, PARA 7, FIG 12. OPS CHECKED GOOD.SDR DALA2017042103294Light · inoperativeDURING ENAC INSPECTION, FOUND FLOOR PROXIMITY EMERGENCY LIGHTS AT SEATS 23AB AND 30AB INOPERATIVE. REPLACED THE EMERGENCY LIGHTS.SDR DALA2017042103293Battery Pack · no testDURING INSPECTION, FOUND EMERGENCY LIGHT BATTERIES FAILED CAP CHECK IAW WC 0591-0204. REPLACED THE BATTERY PACKS IAW AMM 33-512.SDR AALA201704219025Lens · detachedEMERGENCY EXIT LIGHT AT L2 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR HNAA2017042100130Light · crackedEMERGENCY EXIT LIGHT AT THE BOTTOM OF F/A BULKHEAD CRACKED.SDR UIEA2017042000613Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT THE RT EMERGENCY ESCAPE HATCH AND AT SEAT 1J. REMOVED AND REPLACED EMERGENCY LIGHT ASSY IAW AMM 33-51-05, OPS CHECKED GOOD.SDR AALA20170420002Power Supply · inoperativeZONE C LT ROW EMERGENCY CEILING LT FOUND INOP. ZONE C LT ROW EMERGENCY POWER SUPPLY REPLACED (M33405) AND EMERGENCY LT OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR QXEA2017042000297Lamp · inoperative"ON" BACKLIGHTING OF EMERGENCY LIGHT SWITCH BY FWD FA SEAT WILL NOT REMAIN ILLUMINATED. REPLACED THE LAMP.SDR QXEA2017042000296Light · detachedDURING WALK THROUGH, FOUND THREE PIECES OF EMERGENCY LIGHT STRIPS DETACHED FROM FLOOR NEAR MCD AND FWD GALLEY AREA, SECURED THE LIGHT.SDR ASOA201704197007Battery · defectiveA/C IN FOR A 3A INSPECTION AND WE FOUND THE NR 1 EMERGEENCY CEILING LIGHT FLASH ON AND OFF. MAINTENANCE REMOVED AND REPLACED THE NR 1 BATTERY TRAY IAW AMM 33-50-04. OPS CHECK GOOD. IPC REFERENCE IPC 33-50-04 FIG 01A ITEM 50. A/C RELEASED TO SERVICE.SDR SWAA2017042613295Lens · crackedL1 EMERGENCY EXIT SIGN LIGHT LENS CRACKED. R & R THE LENS IAW AMM.SDR AALA20170421004Power Supply · inoperativeONE EMERGENCY LIGHT INOP ABOVE SEAT 2L. ALSO FOUND MASTER CALL/EXIT SIGN INOP M33432. REPLACED POWER SUPPLY M33093 IAW 33-51-06. EMERGENCY LIGHT ABOVE SEAT 2L AND CALL LIGHT/EXIT SIGN M33432 OP"S NORMAL. THE AIRCRAFT WAS GROUNDED.SDR SWAA2017042513357Cover · brokenAFT EMERGENCY LIGHT SWITCH COVER BROKEN. R & R THE COVER IAW AMM.SDR SWAA2017042513323Battery · no testRIGHT FORWARD BATTERY FAILED A TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2017042513322Battery · no testLEFT AFT BATTERY FAILED A TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2017042513321Battery · no testRIGHT AFT BATTERY FAILED A TIME TEST. R & R BATTERY IAW AMM.SDR SWAA2017042513293Battery · no testLEFT CENTER BATTERY FAILED TIME TEST. R & R BATTERY IAW AMM.SDR AALA201704219017Power Supply · no testCABIN EMERGENCY EXIT LIGHTS FAILED TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AT 11WL IAW AMM 33-51-38-400-001A. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704219016Power Supply · no testCABIN EMERGENCY EXIT LIGHTS FAILED TO TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AT 10WL IAW AMM 33-51-38-400-001A. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704219015Lens · brokenEMERGENCY EXIT LIGHT AT FORWARD GALLEY DOOR HAS A BROKEN LENS COVER. REPLACED LENS COVER IAW AMM 33-51-13-400-001-A. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704219014Lens · looseFORWARD BULKHEAD, FLOOR EMERGENCY EXIT LIGHT WILL NOT STAY INSTALLED, HANGING LOOSE. REPLACED EMERGENCY LIGHT LENS COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704219010Power Supply · no testEMERGENCY LIGHTS WILL NOT CHECK ON CIDS. REPLACED CABIN POWER SUPPLY UNIT.SDR DALA2017042003292Power Supply · no testDURING INSPECTION, EPSU TEST FAILED DURING HFA CHECK. REPLACED THE EPSU 17WL.SDR AALA201704219027Power Supply · failedEMERGENCY LIGHTS FROM 21 DEF TO 30 DEF ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IN THE AFT GALLEY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201704219026Lens · missingEMERGENCY LIGHT AT SEAT 14A HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201704209011Power Supply · faultyONE EMERGENCY LIGHT INOP ABOVE SEAT 2L. REPLACED POWER SUPPLY M33093 IAW AMM 33-51-06. EMERGENCY LIGHT ABOVE SEAT 2L OPS. CHECKS NORMAL.SDR AALA201704209010Lens · detachedEXIT LENS IN AFT GALLEY RH SIDE IS DETACHED. REMOVED AND REPLACED EXIT IDENTIFIER ASSY AT R2 SERVICE DOOR IAW AMM 33-51-01 OPS CHECK GOOD.SDR AALA20170420005Light · inoperativeDURING TEST OF EMERGENCY LIGHT TEST IN CABIN FOUND NUMEROUS LIGHTS INOPERATIVE. REPAIRED EMERGENCY LIGHTS IN CABIN TO INCLUDE, OVER-WING EXITS AND ESCAPE PATH LIGHTING. AIRCRAFT IN BASE MAINTENANCE.SDR AALA201704219023Bulb · looseEMERGENCY EVACUATION SLIDE EXTERIOR LIGHT AT L2 DOOR IS INOPERATIVE. SECURED BULB IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201704219001Light · inoperativeROW 12 LEFT, SEAT MOUNTED EMERGENCY LIGHT OUT. REPLACED THE EMERGENDY LIGHT IAW AMM 33-51-18.SDR IPXA2017042016304Bulb · inoperativeTHREE BULBS NOT ILLUMINATED IN THE EXIT SIGN MODULE ABOVE L1 DOOR. REPLACED THE BULBS IAW AMM 33-51-13-04. OPS CHECKED GOOD.SDR IPXA2017041916284Bulb · inoperativeTHREE BULBS NOT ILLUMINATED IN DOOR EXIT SIGN MODULE ABOVE L1 DOOR. REPLACED THE BULBS FOR DOOR EXIT SIGN MODULE 21WL IAW AMM 33-51-13-04. OPS CHECKED GOOD.SDR HNAA2017042100131Light · inoperativeCABIN EMERGENCY LIGHT INOPERATIVE.SDR SWAA2017042113280Light · inoperativeLEFT OVERWING EXIT LIGHT INOPERATIVE. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017042113277Battery · no testEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017042113276Sign · brokenFWD ENTRY LOWER EXIT SIGN BROKEN. R & R THE SIGN IAW MM.SDR SWAA2017042113275Lens · missingRIGHT OVERWING EMERGENCY EXIT SIGN LENS MISSING. REPLACED THE LENS IAW MM.SDR ASOA201704194020Light · inoperativeTHE CREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT THE GALLEY WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT STRIP, OPS TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.
Back to JASC 3350