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 A6WA201644608Light · inoperativeCREW REPORTED THAT THE FLOOR LEVEL EMERGENCY LIGHTS WERE NOT ILLUMINATING FROM ROW 8 AFT. INSPECTED CONNECTIONS OF EMERGENCY LIGHTS, CLEANED BARREL CONNECTORS AT ROW 12 AND ASSEMBLED LIGHTS IAW AMM 33-51-01, EMERGENCY LIGHTS OPS CHECKED GOOD IAW AMM 33-51-00.SDR MASA2016112912508Light · inoperativeROW 15 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR DALA2016112909363Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS FOR THE AFT OVERWING EXITS WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD.SDR AALA20161128007Portable Light · brokenPORTABLE EMERGENCY LIGHT ASSEMBLY IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY.SDR SWAA2016120110136Lens · unsecureFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT COVER AT FELL OFF IN FLIGHT. REINSTALLED LENS IAW AMM.SDR SWAA2016120110123Battery · failedAFT LT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2016120110122Battery · failedAFT RT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2016120110119Lens · missingFORWARD ENTRY DOOR EXIT SIGN LENS MISSING. INSTALLED LENS PER SIP.SDR SWAA2016120110114Sign · looseRT OVERWING EMERGENCY EXIT SIGN LIGHT COVER PLATE LOOSE. R&R SIGN ASSEMBLY PER AMM.SDR AALA20161201011Lens · brokenAIRCRAFT NOT GROUNDED. AFT LEFT EMERGENCY EXIT SIGN LENS COVER BROKEN. REPLACED LENS COVER IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20161130018Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LENS MISSING AT OVERHEAD BIN ABOVE SEAT 23A. REPLACED LENS IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161130017Sign · missingAIRCRAFT NOT GROUNDED. R2 DOOR EMERGENCY EXIT SIGN IS MISSING. REPLACED EXIT SIGN IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20161130016Battery · dischargedAIRCRAFT GROUNDED. FIRST CLASS EMERGENCY LIGHTS CAME ON AT SHUTDOWN AND ARE NOW FULLY DISCHARGED. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161130014Light · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT ASSEMBLY IS DETACHED ABOVE SEAT 24ABC. SECURED LIGHT ASSEMBLY IAW AMM 33-25-01. OPERATIONAL CHECK GOOD.SDR ASOA201611283081Fuse · blownDURING ROUTINE MAINTENANCE, THE RIGHT WING EMERGENCY LIGHT AND LEFT OVERWING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. MAINTENANCE INSPECTED AND REPLACED THE FUSE IN THE NR 4 BATTERY POWER SUPPLY. OPERATIONAL CHECKS WERE GOOD.SDR DALA2016113009420Battery Pack · dischargedLT AND RT OVERHEAD, OVERWING EXIT LIGHTS W/N ILLUMINATE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53.SDR SWAA2016112910048Lens · missingRT AFT EXIT LIGHT LENS MISSING. INSTALLED LENS PER AMM.SDR SWAA2016112910045Lens · looseR1 DOOR EMERGENCY EXIT LIGHT SIGN LENS LOOSE. SECURED LENS PER AMM.SDR IPXA2016112911163Battery Pack · no testEMERGENCY LIGHTS WILL NOT TEST. R & R THE BATTERY PACK IAW AMM 33-51-07-201. OPS CHECKED NORMALSDR DALA2016112909411Battery Pack · inoperativeMID CABIN EMERGENCY EXIT LIGHT OUT COPILOT SIDE, REPLACED THE BATTERY.SDR REXA2016112802332Lens · crackedRT SIDE FWD EMERGENCY LIGHT LENS IS CRACKED JUST AFT OF SERVICE DOOR. REMOVED AND REPLACED THE LENS IAW AMM 33-51-15.SDR REXA2016112802331Lens · crackedEMERGENCY LIGHT LOCATED AT SEAT 15CD IS CRACKED. REMOVED AND REPLACED THE CAP IAW A MM 33-51-01SDR MASA2016112812507Light · inoperativeNR 1 EMERGENCY CEILING LIGHT INOPERATIVE.SDR DALA2016112909374Light · inoperativeEMERGENCY LIGHTS IN 1ST CLASS WILL NOT COME ON. DISCONNECTED AND RECONNECTED BATTERY PACKS, LIGHTS CHECKED GOOD IAW MM 33-53.SDR N6WA2016112802Light · inoperativeEMERGENCY CEILING LIGHT INOPERTIVE. R & R THE LIGHT IAW AMM 33-51-09. PERFORMED OPS CHECK IAW AMM 33-51-09. OPS CHECKED GOOD.SDR N6WA2016112901Light · looseEMERGENCY LIGHTS ROW 23CD ARE LOOSE. R & R EMERGENCY LIGHT IAW AMM 33-51-01.SDR CALA2016112800985Battery Pack · dischargedEMERGENCY LIGHTS INOP AT RT AFT CABIN FROM SEAT ROW 31DEF BACK & LT AFT CABIN FROM SEAT ROW 30ABC BACK . BATTERY PACK WAS REMOVED REPLACED AND OPERATIONAL CHECK GOOD AFTER PROPER CHARGESDR CALA2016112800984Switch · stuckRED EMERGENCY LIGHT ON IN AFT GALLEY BUT EMERGENCY LIGHTS NOT ON. FOUND EMER SWITCH PUSH IN RELEASE AND ALL CKD NORMAL REF 33-10- 00SDR CALA2016112800983Battery Pack · dischargedFOUND EMERGENCY PATH LIGHT FROM SEATS 20- 30 INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AND BATTERY CHARGER IAW AMM 33-51-07. OPS CHECK NORMAL.SDR CALA2016112800982Light · interferenceEMERGENCY EXIT LIGHTS WERE FLASHING INTERMITTENTLY BY SEAT 19A AT LAV. OVERWING EXIT NO FAULT NOTED, OPS CHK NORMAL.SDR QXEA2016112800741Power Supply · inoperativeWITH THE EMERGENCY LIGHTS SELECTED TO ON, THE FORWARD EMERGENCY LIGHTS DO NOT ILLUMINATE. REPLACED THE FORWARD EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-01-00-801 AND 33-51-01-400-801. CHECKS GOOD. RETURNED TO SERVICE.SDR AALA20161130011Sign · missingAIRCRAFT NOT GROUNDED. RIGHT AFT EMERGENCY SELF-ILLUMINATED EXIT SIGN MISSING. INSTALLED NEW EXIT LIGHTED SIGN IAW AMM 33-51-02-201. OPERATIONAL CHECK GOOD.SDR AALA20161130010Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN RIGHT SIDE AFT GALLEY HAS DETACHED LENS COVER. REINSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20161130008Lens · brokenAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY EXIT SIGN LENS COVER BROKEN. REPLACED LENS COVER IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20161128003Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. TAIL CONE VERTICAL EMERGENCY LIGHTS AND AFT CENTER CEILING EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERIES IN AFT LAVATORY OVERHEAD IAW AMM 33-53-00. SEE ALSO AALA20161128002.SDR AALA20161128002Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. TAIL CONE VERTICAL EMERGENCY LIGHTS AND AFT CENTER CEILING EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERIES IN AFT LAVATORY OVERHEAD IAW AMM 33-53-00. SEE ALSO AALA20161128003.SDR AALA20161128001Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. RIGHT AND LEFT OVERWING EXIT UPPER FORWARD EMERGENCY LIGHTS ARE DIM. EMERGENCY BATTERY WILL NOT HOLD CHARGE. REMOVED AND REPLACED BATTERY IAW AMM AMM 33-53-00.SDR SWAA2016112910079Lens · missingMID CABIN OVERHEAD EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2016112910046Light · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2016112910052Cover · brokenFORWARD ENTRY LOWER EXIT LIGHT COVER BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR AALA201611299017Lens · missingCOVER FOR LIGHT ON L1 MISSING. REPLACED LENS AT DOOR 1 LEFT EMERGENCY LIGHT. OK FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201611299016Lens · brokenEMERGENCY EXIT SIGN R4 DOOR LENS BROKEN. REMOVED AND REPLACED BROKEN LENS AT R4 DOOR, CHECKS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20161129019Sign · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN BETWEEN SEATS 21H AND 21J IS LOOSE. SECURED EXIT SIGN IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR U2RA201611270001Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHTS INOPERATIVE REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07.SDR AALA20161128013Pin · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN ABOVE SEAT 24D WAS FOUND DAMAGED. REMOVED AND REPLACED EXIT SIGN PIVOT BLOCK, BOLT AND INSTALLATION PINS IAW AMM 20-11-00. SEE ALSO AALA20161128011 AND AALA20161128012.SDR AALA20161128012Bolt · damagedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN ABOVE SEAT 24D WAS FOUND DAMAGED. REMOVED AND REPLACED EXIT SIGN PIVOT BLOCK, BOLT AND INSTALLATION PINS IAW AMM 20-11-00. SEE ALSO AALA20161128011 AND AALA20161128013.SDR AALA20161128011Block · damagedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN ABOVE SEAT 24D WAS FOUND DAMAGED. REMOVED AND REPLACED EXIT SIGN PIVOT BLOCK, BOLT AND INSTALLATION PINS IAW AMM 20-11-00. SEE ALSO AALA20161128012 AND AALA20161128013.SDR 7C7A2016112700265Battery · dischargedFWD OVERHEAD & RT EMERGENCY LIGHTS OUT. R&R EMERGENCY LIGHT BATTERY 3351-PS2 & AX EMERGENCY LIGHTS. OPS CHECK GOOD REF -8MM CH 33-52-00.SDR DALA2016112809294Battery Pack · inoperativeCOCKPIT AND FWD ENTRY EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED OK IAW AMM 33-50.SDR SIMA20161127001Lamp · inoperativeRH OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RT OVERWING EMERGENCY LIGHT LAMP IAW AMM 33-50-10. OPC GOOD. NO OTHER DEFECTS NOTED.
Back to JASC 3350