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 ASAA2017040120317Lens · damagedCREW REPORTS EXIT SIGN LENS TAPED ON AT R1 DOOR. GROUNDED - YES. REPLACED DAMAGED R1 DOOR FLOOR EXIT SIGN, REF AMM 33-51-01. OPS CHECK NORMAL, REF AMM 33-51-00.SDR SWAA2017040412874Fuse · inoperativeAFT GALLEY, AND LAVATORY AREA EMERGENCY LIGHT INOPERATIVE. R & R THE FUSE IAW AMM.SDR DALA2017040402727Light · missingEMERGENCY LIGHT MISSING.SDR QXEA2017040300211Lens · looseEMERGENCY EXIT SIGN LENS COVER AT THE FORWARD EMERGENCY EXIT FELL OFF. REPLACED THE LENS COVER. CHECKS GOOD. RETURNED TO SERVICE.SDR SIMA20170401002Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. SEE IPC 33-50-10 FIGURE 25 FOR LOCATION. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT IAW AMM 25-23-04. OPS CK GOOD.SDR SIMA20170401001Battery · dischargedEMERGENCY LIGHT DON'T WORK PROPERLY. REMOVED AND REPLACED ALL EMERGENCY LIGHT BATTERIES IAW AMM 33-51-17 OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 73055 NR 3, 109938 NR 4, 73049 NR 1SDR AALA201704029003Cover · detachedR4 DOOR EXIT LIGHT COVER DETACHED. REPLACED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR HNAA2017040300103Bulb · inoperativeMULTIPLE EMERGENCY LIGHTS WERE DIM. R & R THE BULBS AND OPS CHECKED GOOD.SDR HNAA2017040300102Bulb · inoperativeMULTIPLE CELING EMERGENCY LIGHTS DURING FIM. R & R THE BULBS, OP CHECKED GOOD.SDR MASA2017040112712Light · inoperativePHOTO LUM FLOOR STRIP ROW 8 INOP. PLACED ON MEL.SDR ASOA201703313069Lamp · inoperativeTHE CREW REPORTED EMERGENCY LIGHT ON RIGHT SIDE OF SERVICE DOOR NEAR THE FLOOR WOULD NOT ILLUMINATE. MAINTENANCE REPLACED THE LAMP AND OPERATIONAL CHECKED GOOD.SDR AALA20170406003Guard · damagedCABIN - R4 DOOR AREA CONTROL PANEL "EMER LIGHT TEST" SWITCH GUARD FOUND DAMAGED. R4 DOOR AREA CONTROL PANEL "EMER LIGHT TEST" SWITCH GUARD REPLACED IAW SWPM 20-84-15 AND AMM 33-22-06 & AMM 33-51-00. AIRCRAFT IN BASE MAINTENANCE.SDR SWAA2017040512951Battery Pack · no testEMERGENCY LIGHT FAILED CAPACITY TEST AT M01670. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017040512950Battery Pack · no testEMERGENCY LIGHT FAILED CAPACITY TEST AT M01669. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017040512949Battery Pack · no testEMERGENCY LIGHT FAILED CAPACITY TEST AT M01672. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017040512940Battery Pack · no testEMERGENCY LIGHT FAILED CAPACITY TEST AT M01668. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017040512937Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 9. REPLACED THE LAMPS IAW WDM & AMM.SDR SWAA2017040512933Cover · crackedLEFT EMERGENCY LIGHT LENS COVER CRACKED AT BETWEEN ROWS 4 TO 27. R & R THE COVER IAW AMM.SDR SWAA2017040512932Cover · crackedRIGHT EMERGENCY LIGHT LENS COVER CRACKED BETWEEN ROW 6 TO ROW 25. R & R THE COVER IAW MM.SDR SWAA2017040512901Lens · brokenFORWARD ENTRY EMERGENCY LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR SWAA2017040512886Cover · looseR1 DOOR EXIT SIGN LIGHT COVER LOOSE. SECURED THE COVER IAW AMM.SDR AALA201704039034Sign · brokenEXIT SIGN COVER OVER THE 2R DOOR IS BROKEN AT THE SCREW HOLE AND WILL NOT STAY ON. INSTALLED NEW BASE FOR EXIT SIGN. OPS CHECK OF LIGHT GOOD IAW MM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704039033Cover · missingEMERGENCY DOOR EXIT SIGN LIGHT COVER MISSING AT 1R. REPLACED MISSING EXIT SIGN COVER AT 1R. ALL OPS OK IAW M/M 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704039032Cover · missingEXIT SIGN COVER IS MISSING AT 578. REPLACED LIGHT ASSY L1190 IAW AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR ASAA2017033120323Lens · brokenF/A REPORTS R1 EXIT LIGHT LENS IS BROKEN. GROUNDED - YES. INSTALLED NEW R1 DOOR EXIT LIGHT LENS.SDR SWAA2017040412867Sign · brokenR2 DOOR EXIT SIGN BY AFT GALLEY BROKEN. R & R THE SIGN IAW AMM.SDR DALA2017040402730Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR DALA2017040402729Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR DALA2017040402728Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. CHECKED NORMAL.SDR AALA20170331012Cover · missingEMERGENCY DOOR EXIT MISSING LIGHT COVER AT 1R. REPLACED MISSING COVER AT 1R ALL, OPS OK PER M/M 33-53-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704039031Sign · damagedLIGHT LENS/COVER/BEZEL DAMAGED. LIGHT FUNCTIONS ARE NORMAL EMERGENCY EXIT SIGN IS MISSING OUTER COVER AND BULB. LOCATED ACROSS FROM FWD COAT CLOSET. PERFORMED REPLACE EMERGENCY EXIT SIGN ASSY LIGHT IAW AMM25-63-00, GOOD TO SERVICE, REMOVED PLACARD. THE AIRCRASDR SIMA20170331003Charger · failedDURING PS-2 FOUND LT AND RT OVERWING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED LT SIDE CENTER FAIRING EXTERNAL EMERGENCY LIGHT ASSEMBLY IAW AMM 33-50-10. REMOVED AND REPLACED BATTERY POWER SUPPLY 3 AND 4 IAW AMM 33-50-04. R&R BATTERY CHARGER 4 IAW AMM 33-50-SDR SIMA20170331001Inverter · inoperativeEMERGENCY LIGHT ON AFT GALLEY WALL INOP. REMOVED AND REPLACED 3 EMERGENCY LIGHT INVERTER, OPC GOOD IAW AMM 33-50-11.SDR AALA20170401003Lens · crackedAIRCRAFT WAS NOT GROUNDED. BROKEN EMERGENCY LIGHT COVER AT BOTTOM OF R1 DOOR. REMOVED AND REPLACED EXIT MARKER, FLOOR PROXIMITY EMERGENCY ESCAPE PATH SIGN, AT R1 DOOR PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170401002Lens · crackedAIRCRAFT WAS NOT GROUNDED. BROKEN EMERGENCY LIGHT COVER AT BOTTOM OF L-1 DOOR. REPLACED EXIT LIGHT COVER, FLOOR PROXIMITY EMERGENCY ESCAPE PATH SIGN, PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201704029002Flashlight · no testL1 DOOR JUMPSEAT OTBD SIDE, EMERGENCY FLASHLIGHT DOES NOT TEST. REINSTALLED EMERGENCY FLASHLIGHT IAW AMM 25-65-00. ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST.SDR AALA201704039011Cover · missingL4 DOOR EMERGENCY LIGHT COVER MISSING. REPLACED THE LIGHT COVER.SDR AALA201704039007Lens · missingEMERGENCY LIGHT LENS AT ROWS 23L MISSING. INSTALLED THE LENS.SDR DALA2017040302699Light · inoperativeLEFT AFT EXTERIOR OVERWING LIGHT INOPERATIVE. THE LIGHT WAS REPLACED.SDR N6WA2017033102Relay · malfunctionedEMERGENCY LIGHTS WON'T TURN OFF. R & R THE JB-11, PCB5 RELAY K-135 IAW AMM 24-06-11. OPS CHECKED GOOD.SDR YENA201703310232Power Supply · failedDURING ROUTINE MAINTENANCE, AFT EPSU 13WL SHOWED UNIT FAULT. R & R EPSU & BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201703310231Battery Pack · failedDURING ROUTINE MAINTENANCE, AFT EPSU 13WL SHOWED UNIT FAULT. R & R EPSU & BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201703310229Power Supply · failedDURING ROUTINE MAINTENANCE, DISCOVERED THAT EMERGENCY LIGHT IN CEILING PANEL NR 5 WILL NOT ILLUMINATE. R & R EMERGENCY LIGHT POWER SUPPLY NR 2 IAW AMM 33-50-01. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR MASA2017033112708Light · inoperativeEMERGENCY FLOOD LIGHT ROW 18 INOPERATIVE.SDR MASA2017033112707Light · inoperativeAFT CABIN CEILING FLOOD LIGHT INOPERATIVE.SDR CALA2017033100782Light · inoperative35AC 40AC SEAT EMER LT INOP. REPLACE 35AC 40AC SEAT EMER LT ASSY AND C/O OP CHK FOUND ''STATIC'' REF TO AMM 33-51-12-332-001-002 REV 87.SDR SWAA2017040512938Lens · crackedLEFT EMERGENCY LIGHT LENS CRACKED AT ROW 23. R & R THE LENS IAW AMM.SDR SWAA2017040512935Light · delaminatedRIGHT EMERGENCY LIGHT DELAMINATED AT ROW 1. R & R THE EMERGENCY LIGHT IAW SIP.SDR SWAA2017040512916Lens · looseL1 DOOR SLIDE EMERGENCY LIGHT LENS LOOSE. R & R THE LENS IAW AMM & MT.SDR SWAA2017040512899Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.
Back to JASC 3350