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 CALA2016090600630Fuse · inoperativeEMERGENCY LIGHTS L1117 AND L892 INOPERATIVE. REPLACED THE FUSE ON M731 IAW AMM 31-51-07-962 -017-002 AND CHARGER M730 IAW AMM 33-51-07-862-029-002, OPS CHECKED OK.SDR CALA2016090600629Cover · missingEMERGENCY LIGHT IN RT AFT GALLEY. COVER MISSING AND WIRES EXPOSED. SECURED LIGHT ASSY.SDR SWAA2016091907971Lens · brokenFORWARD GALLEY LAVATORY A WALL HAS A BROKEN EMERGENCY EXIT LIGHT LENS. R & R THE LENS IAW AMM.SDR AALA20160905010Power Supply · low voltageL3 DOOR OVERHEAD PANEL EMERGENCY POWER PACK FOUND VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR AALA20160905008Power Supply · low voltageL3 DOOR OVERHEAD PANEL EMERGENCY POWER PACK VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR AALA20160905006Power Supply · low voltageR4 DOOR OVERHEAD PANEL EMERGENCY POWER PACK VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-50-00 AND 33-51-00 AND 33-51-06.SDR AALA20160905004Power Supply · low voltageR3 DOOR OVERHEAD PANEL EMERGENCY POWER PACK VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR AALA20160905003Lens · looseL1 DOOR ONE EXTERNAL EMERGENCY LIGHT LENS FOUND LOOSE. THE LENS SECURED IAW AMM 33-50-00 AND 33-51-04.SDR ASAA2016090517937Lens · unsecureFA REPORT FWD GALLEY R1 EXIT LIGHT COVER IS UNATTACHED. ACFT GROUNDED. REPLACED THE LENS AND LIGHTS TESTED GOOD IAW AMM 33-51-00/501.SDR AALA201609069006Battery · faultyAIRCRAFT WAS NOT GROUNDED: DURING OPS TEST OF EMERGENCY LIGHTS RECEIVED FAULT EPSU BATTERY FWD LT. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 10WL AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-38-0000/400-002.SDR AALA201609069005Battery · faultyAIRCRAFT WAS NOT GROUNDED, WHILE ACCOMPLISHING TASK CARD 33C2203302, FOUND R1 EMERGENCY LIGHT BATTERY FAULT. REPLACED R1 EMERGENCY LIGHT BATTERY IAW AMM 33-51-58-400-802-A.SDR AALA201609069004Battery · faultyAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING TASK CARD 33C2203302, FOUND L3 EMERGENCY LIGHT BATTERY FAULT. REPLACED L3 EMERGENCY LIGHT BATTERY IAW AMM 33-51-58-400-802-A.SDR AALA201609069003Battery · failedACFT WAS NOT GROUNDED, EMERGENCY POWER SUPPLY UNIT 15WL BATTERY WILL NOT PASS TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-38.SDR AALA201609069002Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 14WL BATTERY WILL NOT PASS TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-38.SDR U2RA201609050001Control Module · inoperativeSEVERAL AREAS OF EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS AND CONTROL MODULES IAW MM 33-51-07.SDR AALA201609079016Power Supply · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY POWER SUPPLY UNIT 10WL WILL NOT TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 10WL AND BATTERY IAW AMM 33-51-38.SDR AALA201609069025Lens · missingAIRCRAFT WAS NOT GROUNDED: SEAT 9D EMERGENCY LIGHT COVER LENS MISSING. INSTALLED LENS AT SEAT 9D.SDR AALA201609069023Battery · dischargedAIRCRAFT WAS GROUNDED: EMERGENCY POWER SUPPLY UNIT 10WL WILL NOT TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 10WL AND BATTERY IAW AMM 33-51-38.SDR ASOA2016090515357Lens · brokenLEFT SIDE EXTERIOR EMERGENCY LIGHT LENS COVER IS BROKEN. REMOVED AND REPLACED THE LENS COVER IAW AMM 33-51-15, OPS CHECKED GOOD.SDR HNAA2016090700271Light · inoperative4TH EMERGENCY FLOOR LIGHT FROM FRONT IS INOPERATIVE. R & R 4TH EMERGENCY FLOOR LIGHT.SDR ASAA2016090517940Sign · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO LT FORWARD OVERWING EXIT HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. RELAMP IAW AMM 33-51-01-960-801, NO HELP. REF 900 WDM 33-51-13-2, REMOVED, REPLACED, AND TESTED L1365 EXIT LOCATOR SIGN IAW AMM 33-51-01-96SDR ASAA2016090517939Light · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN AT L-2 DOOR HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. RELAMPED AND TESTED IAW AMM 33-51-01-960-801, OPS NORMAL.SDR SWAA2016090655384Sign · looseR2 DOOR EMERGENCY EXIT SIGN LOOSE. SECURED THE SIGN IAW AMM.SDR N6WA2016090501Light · inoperativeEMERGENCY EXIT FLOOD LIGHT AT ROW 11 INOPERATIVE. DEFFERED CEILING EMERGENCY FLOOD LIGHT AT ROW 11 IAW MEL 33-51-01B.SDR UHLA201609050430Ecu · inoperativeEMERGENCY LIGHT IN FLIGHT DECK NOT WORKING. R & R BATTERY EMERGENCY CONTROL UNIT IAW AMM 33-50-80. OPS CHECK GOOD.SDR R61A201609050518Battery · dischargedCREW REPORTED THAT THE EMERGENCY LIGHT IN THE AFT CABIN WAS INOPERATIVE. MAINTENANCE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR ASOA20160905070HLight · inoperativeTHE CREW REPORTED THAT THE FIRST SEGMENT OF AISLE PATH LIGHTING WAS INOPERATIVE. MAINTENANCE R & R THE AFFECTED LIGHT STRIP, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR MASA2016090512359Battery · dischargedROW 3-4 EXIT SIGN INOPERATIVE. CHARGED BATTERIES.SDR DALA2016091406769Battery Pack · dischargedFOUND EMERGENCY LIGHT AT R1 DOOR INOPERATIVE. MAINTENANCE REPLACED THE BATTERY CHARGER. SYSTEM OPERATION IS NORMAL.SDR DALA2016090606611Battery Pack · unsecureEMERGENCY EXIT SIGN AT UPPER DECK RIGHT DOOR INOPERATIVE. RESEATED BATTERY AT POWER SUPPLY. SYSTEM OPERATION NORMAL.SDR SWAA2016091255658Sign · brokenAFT CABIN CEILING ACCESS PANEL EMERGENCY EXIT SIGN MOUNTS BROKEN. R & R SIGN IAW AMM.SDR AALA20160905011Power Supply · low voltageL2 DOOR OVERHEAD PANEL EMERGENCY POWER PACK FOUND WITH VOLTAGE TOO LOW AND CANNOT RECHARGE. 9 REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR AALA20160905009Power Supply · low voltageL1 DOOR OVERHEAD PANEL POWER PACK VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR AALA20160905007Power Supply · low voltageR4 DOOR OVERHEAD PANEL EMERGENCY POWER PACK VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR AALA20160905005Power Supply · low voltageL4 DOOR OVERHEAD PANEL EMERGENCY POWER PACK VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR AALA20160905002Power Supply · low voltageL2 DOOR OVERHEAD PANEL EMERGENCY POWER PACK M33096 FOUND VOLTAGE TOO LOW AND CANNOT RECHARGE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR DALA2016090706499Lens · detachedEMERGENCY EXIT SIGN LENS DETACHED. SECURED THE LENS.SDR UIEA2016090600746Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-51-04, OPS CHECKED GOOD.SDR UIEA2016090600747Battery Pack · inoperativeDURING INSPECTION, FOUND LUD POWER ASSIST BATTERY INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-04, OPS OK.SDR SWAA2016090755568Cover · detachedL1 DOOR EXIT SIGN COVER FELL OFF. REINSTALLED THE SIGN COVER IAW AMM.SDR AALA201609059001Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER MISSING AT SEAT 1C. REPLACED MISSING LIGHT COVER AT SEAT 1C AND ACCOMPLISHED A SATISFACTORY OPS CHECK.SDR SWAA2016090655541Bulb · inoperativeL2 DOOR OVERHEAD EMERGENCY EXIT LIGHT BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2016090655540Bulb · inoperativeL1 DOOR OVERHEAD EMERGENCY EXIT LIGHT BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2016090655536Lens · missingR1 DOOR LOWER EMERGENCY LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR ASOA2016090415351Light · inoperativeLEFT EXIT ROW EMERGENCY EXIT MARKER INOPERATIVE. R & R LT EXIT ROW EMERGENCY EXIT MARKER IAW AMM 33-51-13. OPS CHECK GOOD. SDR CLOSED.SDR SWAA2016090655430Cover · unsecureFORWARD CENTER AISLE EXIT LIGHT COVER FELL OFF. R & R LIGHT ASSEMBLY IAW MM.SDR F3LA2016090600054Light · no testDURING ROUTINE HEAVY SERVICE CHECK, THE L1 DOOR FAILED THE EMERGENCY LIGHT TEST. REMOVED AND REPLACED L1 DOOR SLIDE IAW TC25831-02. TESTED EMERGENCY LIGHTS IAW WORK CARD, OPS CHECKED GOOD.SDR ASAA2016090417904Sign · detachedFA REPORTED R2 DOOR EMERGENCY EXIT SIGN FELL OFF. ACFT GROUNDED. RESECURED R-2 EXIT SIGN IAW AMM 33-51-01SDR N6WA2016090402Battery Pack · dischargedGALLEY EMERGENCY LIGHTS NOT WORKING. R & R EMERGENCY LIGHT BATTERY PACK NR 1 IAW AMM 33-51-17.SDR UHLA201609040429Light · inoperativeEMERGENCY EXIT STRIP INOPERATIVE RT FORWARD SIDE OF CABIN. R & R EMERGENCY EXIT STRIP RT FORWARD SIDE OF CABIN IAW MM 33-50-21.
Back to JASC 3350