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 DALA2018102606310Lens · missing(AIRCRAFT 7104, L/P 0789766) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / INTERIOR. INSTALLED MISSING LENS COVER. CKS GOOD.SDR SWAA2018102226121Lens · unsecureOVERWING CEILING EXIT SIGN FELL OFF. REINSTALLED LENS PER AMM.SDR SWAA2018102226110Cover · unsecureLT OVERWING EMERGENCY EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2018102226082Lens · looseLT AISLE EMERGENCY BULLNOSE BINS LIGHT LOOSE BETWEEN ROW 17 TO ROW 20. REINSTALLED LENS PER AMM.SDR AALA201810239032Power Supply · no testEMERGENCY LIGHTS FAILED AN OPERATIONAL TEST WITH BATTERY , AND POWER SUPPLY UNIT 14WL MIRROR FAULT. REPLACED THE POWER SUPPLY AND AFTER MDCU EMERGENCY LIGHTS TEST PAGE 19/20 OF PS, TESTED OK.SDR DALA2018102106236Light · brokenEMERGENCY EXIT LIGHT 31C BROKEN. REPLACED EMERGENCY EXIT LIGHT.SDR SWAA2018102226081Lens · missingLT OVERHEAD BIN EMERGENCY LIGHT LENS COVER MISSING AT ROW 8. INSTALLED COVER PER SIP.SDR SWAA2018102226079Battery · dischargedRT FORWARD CABIN EMERGENCY LIGHT INOP AT LOCATION M01674. R&R BATTERY ASSEMBLY IAW AMM OD.SDR SWAA2018102226066Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK FAILED CAPACITY TEST AT M1668. R&R BATTERY PACK PER AMM.SDR AALA201810199034Sign · inoperativeBOS - R1 LOWER EMERGENCY LIGHT INOP. MAINTENANCE REPLACED R1 LOWER EXIT IDENTIFIER SIGN IAW AMM 33-50-15 OPS CHECK GOOD.SDR CALA2018101902142Battery Pack · dischargedOPERATION CHK FND DR4 4EA EMERGENCY LT NO ILLUMINATE. REPLACED THE DOOR 4R BATT PACK M33408 AND C/O TEST FND EMERGENCY LIGHT ''NORMAL'' REF AMM 33-51-06-960-802 REV 83.SDR CALA2018101902141Battery Pack · dischargedEMERGENCY LIGHT TEST FND L3 EMERGENCY AREA LT NO ILLUMINATE. THE BATTERY PACK REPLACED AND CONDITION CHK, TEST ''OK'' REF AMM 33-51-06-960-802 AMM 33-51-06-960-802 REV 83.SDR DALA2018101806183Fuse · blownEMERGENCY LIGHTS AT ROWS 24-30 ARE INOPERATIVE. MAINTENANCE FOUND A FUSE ON BATTERY PACK B5-212 TO BE BAD. THE BAD FUSE WAS REPLACED AND THE LIGHTS NOW OPERATE NORMALLY REF AMM 33-50.SDR SIMA201810198001Inverter · inoperativeEMERGENCY EXIT LIGHT ABOVE SERVICE DOOR INOP. C/A-REMOVED AND REPLACED NR 2 EMERGENCY LIGHT INVERTER OPS CHECK GOOD IAW AMM 33-50-11.SDR AALA201810199016Panel · inoperativeAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY LIGHTS AT OVERWING EXITS INOPERATIVE. REPLACED CEILING PANEL ASSEMBLY AT OVERWING EXITS PER AMM 25-23-41. OPERATIONS CHECK ON EMERGENCY LIGHTS NORMAL.SDR AALA201810199015Cover · missingAIRCRAFT WAS NOT GROUNDED. 2L EMERGENCY EXIT LIGHT COVER MISSING. REPLACED COVER.SDR AALA201810199026Epsu · faultedTHE AIRCRAFT WAS NOT GROUNDED. DURING L1 SLIDE CHANGE FOUND EPSU FAULTS. SLIDE OK. RESET EMERGENCY LIGHTING SYSTEM PER AMM 33-51-00. OPERATIONS CHECK OK.SDR AALA201810199011Power Supply · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. FORWARD CABIN EMERGENCY POWER SUPPLY IS INOPERATIVE. NO TEST AVAILABLE. REPLACED CABIN EMERGENCY POWER FORWARD POWER SUPPLY UNIT PER AMM 33-51-38. OPERATIONS CHECK GOOD.SDR AALA201810199010Battery · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EPSU LEFT AFT FAULT DURING EMERGENCY LIGHT SYSTEM TEST. INSTALLED SERVICEABLE ESPU BATTERY PER AMM 33-51-38-400-002A. OPERATIONS TEST GOOD.SDR AALA201810199009Light · missingTHE AIRCRAFT WAS NOT GROUNDED. FORWARD CABIN EMERGENCY LIGHT, WALL MOUNTED (RED), MISSING. INSTALLED FORWARD CABIN EMERGENCY LIGHT, WALL MOUNTED (RED), ASSEMBLY PER AMM 33-51-00.SDR I5EA20181007Battery Pack · dischargedRT OVERHEAD BIN AT STA 727 EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK AT STA 727 FOR OVERHEAD BIN LIGHTS RT AFT IAW AMM 33-51-06.SDR R61A201810191051Sign · inoperative***WHILE AIRCRAFT WAS IN HEAVY CHECK*** MAINTENANCE REPORTED EMERGENCY EXIT LIGHTED SIGNS AT L1 DOOR AND R1 DOORS TO BE NOT COMPLETELY ILLUMINATED. BOTH EMERGENCY EXIT LIGHTS WERE REMOVED AND REPLACED WITH PART NUMBERS 4028-23 AND 4028-13. OPERATIONAL CHECK GOSDR R61A201810191050Sign · inoperative***WHILE AIRCRAFT WAS IN HEAVY CHECK*** MAINTENANCE REPORTED EMERGENCY EXIT LIGHTED SIGNS AT L1 DOOR AND R1 DOORS TO BE NOT COMPLETELY ILLUMINATED. BOTH EMERGENCY EXIT LIGHTS WERE REMOVED AND REPLACED WITH PART NUMBERS 4028-23 AND 4028-13. OPERATIONAL CHECK GOSDR AALA201810239034Cids · malfunctionedUNABLE TO COMPLETE AN EMERGENCY POWER SUPPLY UNIT TEST DUE TO NO RESPONSE MESSAGE. DE-ENERGIZED AND RE-ENERGIZED CIDS IAW AMM 23-73-00. TEST PASSED WITH NO FAULTS, OK FOR CONTINUED SERVICE.SDR DALA2018101906238Light · inoperativeALL FOUR OVERWING DOOR PULL HANDLE LIGHTS INOPERATIVE. RELAMPED. OPERATION CHECKS OKAY.SDR DALA2018102206218Battery Pack · defectiveFORWARD GALLEY EMERGENCY LIGHT BATTERY PACK FOUND BAD AND REPLACED SAME.SDR SWAA2018102226071Light · inoperativeLT EMERGENCY STOW BIN LIGHT INOP AT SEAT ROW 24. R&R BULB IAW AMM.SDR DALA2018102206213Power Supply · inoperative(AIRCRAFT 6814, L/P 4476664) ON SERVICE CHECK FOUND EMERGENCY LIGHTS AT SEATS 27 DEF TO 35 DEF INOP. REPLACED POWER SUPPLY AND BATTERY PACK LOCATED ABOVE 35DEF IN REF TO AMM REF 33-51 OPS CHECK GOOD.SDR CALA2018101902137Battery · dischargedDOOR R3 EMER LIGHT POWER SUPPLY M33404 BATTERY CAPACITY LOW DOOR R3. EMER LIGHT POWER SUPPLY M33404 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06 AND ATTACHED FORM 44.0008 ITEM 1-2 ACCOMPLISHED.SDR CALA2018101902136Battery · dischargedDOOR L4 EMER LIGHT POWER SUPPLY M33407 BATTERY CAPACITY LOW DOOR L4. EMER LIGHT POWER SUPPLY M33407 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06 AND ATTACHED FORM 44.0008 ITEM 1-2 ACCOMPLISHED.SDR CALA2018101902135Battery · dischargedEMERGENCY LIGHT BATTERY PACK M33401 CAPACITY LOW. REPLACED EMERGENCY LIGHT BATTERY PACK M33401 C/OUT A TEST FND THE RESULT NORMAL AS PER AMM 33-51-06-960-802 REV 83 & SUBTASK 33-51-06-710-002 REV 83.SDR AALA201810198003Battery Pack · inoperativeOVERWING EMERGENCY EXIT LIGHTS FORWARD RIGHT SIDE WERE INOPERATIVE. REPLACED THE BATTERY PACK M1695 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201810189018Power Supply · faultedSEAT 1AC EMERGENCY LIGHT INOPERATIVE. FOUND THE POWER SUPPLY TO HAVE A FAULT. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR ASAA2018101726516Battery · lowAFT RIGHT EMERGENCY LIGHTS DO NOT REMAIN ON FOR 15 MINS. GROUNDED - YES. REMOVED AND REPLACED AFT RIGHT EMGR LIGHT BATT PACK OPS NML REQ ENDURANCE TEST. AFT RIGHT EMERGENCY LIGHTS OPS CHECK GOOD IAW AMM 33-51-06.SDR SIMA20181017003Light · inoperativeRT OVERWING PANEL EMERGENCY LIGHT INOP. REMOVED AND REPLACED RT OVERWING PANEL EMERGENCY LIGHT LAMP IAW AMM 33-50-10 OPS CK GOOD.SDR SWAA2018101826063Sign · incorrectR2 DOOR EMERGENCY EXIT SIGN INCORRECT. CORRECTED SIGN PER AMM.SDR SWAA2018101826054Sign · incorrectL2 DOOR EMERGENCY EXIT SIGN INCORRECT. CORRECTED SIGN PER AMM.SDR AALA201810189004Power Supply · faultedAIRCRAFT WAS NOT GROUNDED. FORWARD EMERGENCY LIGHT POWER SUPPLY HAS "EXT LOADS" FAULT MESSAGE. REPLACED EMERGENCY LIGHT POWER SUPPLY (10WL) PER AMM 33-51-38-401. OPERATIONS CHECK GOOD.SDR KCSA201810171238Light · inoperativeL1 DOOR SILL EMERGENCY LIGHTS DOES NOT ILLUMINATE.SDR DALA2018101706133Battery · dischargedROW 16-20 ABC OVERHEAD E-LIGHTS INOP. R+R BATTERIES IN B5-102. OPS CK SAT. PER AMM 33-50. (LP4414850)SDR XMXR20191211019Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR XMXR20191211018Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR SIMA20181016005Light · crackedNR 6 FLOOR LIGHTING STRIP IS CRACKED AT THE HOLES. C/A-COMPLETE:INSTALLED NEW NR 6 FLOOR LIGHT STRIP IAW AMM 33-50-12.SDR SIMA20181016004Light · crackedNR 4 FLOOR LIGHT STRIP IS CRACKS BY THE HOLES. C/A-COMPLETE:INSTALLED NEW NR 4 FLOOR LIGHT STRIP IAW AMM 33-50-12.SDR SIMA20181016007Light · cracked1 EACH EMERGENCY LIGHT STRIP CRACKED. C/A-COMPLETE:INSTALLED 2 EACH NEW FLOOR PROXIMITY LIGHT STRIPS ON LIGHT STRIP EXTRUSION IAW AMM 33-50-12.SDR SIMA20181016008Light · crackedNR 5 FLOOR LIGHT STRIP IS CRACKS BY THE HOLES. C/A-COMPLETE: INSTALLED NEW EMERGENCY LIGHT STRIP FOR NR 5 POSITION IAW 33-50-12.SDR DALA2018102606314Sign · unsecure(AIRCRAFT 7102, L/P 5172594) EXIT SIGN AT EXIT 3L HAS FALLEN OFF. RE-INSTALLED EXIT SIGN.SDR CALA2018102302178Battery Pack · dischargedREF NR L/P 9463738 SPEC NO. B777-33-3-6019 EMERGENCY LIGHT BATTERY PACK M33407 CAPACITY LOW (P/N D717-01-100). REPLACED EMERGENCY LIGHT BATTERY PACK M33407 & C/OUT A TEST FND THE NORMAL AS PER AMM 33-51-06-960-802 REV 83 & SUBTASK 33-51-06-710-002 REV 83. LOCASDR CALA2018102302177Battery Pack · dischargedREF NR L/P 9463736 SPEC NO. B777-33-3-6019 EMERGENCY LT BATTERY PACK M33406 CAPACITY LOW (P/N D717-01-100). REPLACED EMERGENCY LIGHT BATTERY PACK M33406 & C/OUT A TEST OF THE NEW BATTERY AS PER AMM 33-51-06-960-802 REV 83 & SUBTASK 710-002 REV 83. LOCATION:DR3SDR CALA2018102302176Battery Pack · dischargedREF NR L/P 9463740 SPEC NO. B777-33-3-6019 EMERGENCY LIGHT BATTERY PACK M33099 CAPACITY LOW (P/N D717-01-100). REPLACED EMERGENCY LIGHT BATTERY PACK M33099 & C/OUT TEST FND NORMAL AS PER AMM 33-51-06-960-802 REV 83 & SUBTASK 33-51-06-710-002 REV 83. LOCATION:D
Back to JASC 3350