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 AALA201907289018Sign · detachedAIRCRAFT WAS NOT GROUNDED: 2L BOARDING DOOR EXIT SIGN WAS DETACHED. MAINTENANCE RESECURED EXIT SIGN PER STANDARD PRACTICES.SDR AALA201907289015Light · damagedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED EMERGENCY FLOOR LIGHTING BY ROW 9D DAMAGED. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-19.SDR AALA201907289012Lens · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AISLE LIGHT 8C RED LENS BROKEN OFF. REPLACED LIGHT PER AMM 33-51-18.SDR AALA201907289009Cover · brokenAIRCRAFT WAS NOT GROUNDED: AFT RIGHT EMERGENCY EXIT DOOR LIGHT COVER BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY PER CMM 25-32-30.SDR AALA201907289008Lens · missingAIRCRAFT WAS NOT GROUNDED: LENS MISSING EPL ROW 16L. MAINTENANCE REPLACED LIGHT ASSEMBLY PER CMM 25-20-50.SDR AALA201907289003Lens · out of positionAIRCRAFT WAS NOT GROUNDED: 4R DOOR EMERGENCY LIGHT COVER WAS OFF. MAINTENANCE REPLACED LIGHT LENS ASSEMBLY PER AMM 33-51-00.SDR SIMA20190727003Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-09 OPC GOOD.SDR SIMA20190727002Battery · dischargedEMERGENCY LIGHTS INOP IN GALLEY #1. C/A-RAR EMERGENCY BATTERY IN GALLEY #1 IAW AMM 33-50-01 OPS WAS GOOD.SDR DALA2019072804441Light · inoperativeEMERGENCY LIGHT AT SEAT 14HJ INOPERATIVE. REPLACED LIGHT ASSEMBLY. LP 6296517SDR VNAA2019072611101Battery Pack · dischargedEMERGENCY LIGHTS IN FLIGHT DECK LEFT IN ON POSITION. REPLACED 4 BATTERY PACKS P/N 2013-1A S/N 122525, 122912, 122512, 73206. OPS CHECK GOOD.SDR DALA2019081204713Housing · damagedEMERGENCY LIGHT LENS HOUSING DAMAGED AT 17C, 18C, 20C. REMOVED AND REPLACED EMERGENCY LIGHT LENS HOUSING AT 18C AND 20C AS PER A321 CMM 25-25-52 FIG 15 ITEM 5. 17C. EMERGENCY LIGHT LENSE HOUSING C/W AT SEAT 17C PER A321 AMM 25-21.SDR ASOA201907265088Battery Pack · dischargedDURING COMPLETION OF ADS-B MOD LINE IT WAS DISCOVERED THAT SEVERAL INSIDE AND OUTSIDE EMERGENCY LIGHTS DID NOT ILLUMINATE. MX REMOVED AND REPLACED #2 AND #4 EMERGENCY LIGHT BATTERIES WITH OPERATIONAL CHECKS GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA2019072630208Lens · missing17F MISSING EXIT SIGN. GROUNDED - YES. INSTALLED LENS.SDR SWAA2019072935395Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER AMM.SDR SWAA2019072935394Cover · missingAFT GALLEY EMERGENCY EXIT LIGHT COVER MISSING. R&R EMERGENCY LIGHT ASSEMBLY PER AMM.SDR SWAA2019072935389Cover · looseRT EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER PER MM.SDR AALA201907299013Light · damagedAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY AT 3A FORWARD POSITION DAMAGED. MAINTENANCE REPLACED LIGHT LUMINATOR ASSEMBLY PER AMM 33-51-00.SDR AALA201907289021Light · damagedAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY AT 3A FORWARD POSITION DAMAGED. MAINTENANCE REPLACED LIGHT LUMINATOR ASSEMBLY PER AMM 33-51-00.SDR AALA201907289011Lens · missingAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED LIGHT PER AMM 33-51-19.SDR AALA201907289010Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS AT SEAT 20ABC WAS MISSING. MAINTENANCE REPLACED LIGHT PER MM 33-51-00.SDR AALA201907289005Lens · missingAIRCRAFT WAS NOT GROUNDED: FLOOR PATH LIGHTING LENS MISSING AT ROW 13C. MAINTENANCE REPLACED LENS PER MM 33-50-00.SDR MASA2019072611969Light · inoperative2 GALLEY FLOOR EMERG LIGHTS OUT. PLACED ON MEL.SDR MASA2019072611970Light · inoperative2 EMERG LIGHTS OUT AT ENTRY FLOOR LEVEL. PLACED ON MEL.SDR MASA2019072611967Light · inoperativeCEILING EMER FLOOD LIGHTS 4 INOP ROW 10 MX IS T/S.SDR DALA2019072604421Battery Pack · dischargedOVERHEAD EMERGENCY LIGHT FORWARD OF ROW 1 WAS FOUND TO BE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY PACK IAW AMM 33-57-03. OPERATIONAL CHECK OF THE LIGHTS IS NOW GOOD. (LP #5967728)SDR DALA2019072604414Battery · dischargedEMER. LIGHTS OUT ON OVERHEAD @ ROWS 18,21,24,25. R/R BATTERIES AT B5-103 PER AMM 33-53 AND WM 33-51-12. OPS CK GOOD. (LP5926683)SDR VNAA2019072511102Battery · dischargedEMERGENCY LIGHTS NOT WORKING. REMOVED AND REPLACED #1 AND #2 EMERGENCY POWER SUPPLY UNIT BATTERY P/N AD2013-1A S/N 136305, 79823 OPS CHECK GOOD AT THIS TIMESDR VNAA2019072511101Module · inoperativeFORWARD MOST STRIP OF EMERGENCY FLOOR PATH LIGHTING DOES NOT ILLUMINATE & PAX DOOR EXIT SIGN DOES NOT ILLUMINATE. REMOVED & REPLACED MODULE, DIODE TERMINAL CHECKS GOOD.SDR SWAA2019072935393Lens · brokenFORWARD CENTER AISLE EMERGENCY LIGHT LENS LOOSE AND BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019072935338Sign · missingEMERGENCY ROW EXIT SIGN MISSING. R&R SIGN PER SIP.SDR SWAA2019072935326Battery Pack · low voltageEMERGENCY BATTERY PACK LOW CAPACITY AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019072935306Guard · brokenFLIGHT DECK OVERHEAD PANEL EMERGENCY LIGHTS SWITCH GUARD BROKEN. R&R SWITCH GUARD PER AMM.SDR DALA2019072604474Lens · missingSHIP 697 FOUND AFT RIGHT LAV EMERGENCY LIGHT RED LENSE COVER MISSING. CORRECTIVE ACTION: INSTALLED NEW COVER & OPS CKS LIGHT GOOD IAW AMM 33-52. (6029849)SDR AALA201907269008Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS MISSING AT SEAT 9D. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-11.SDR AALA201907269004Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN FELL OFF THE LEFT AFT ENTRY DOOR. MAINTENANCE REPLACED SIGN PER AMM 33-51-00.SDR 29GA2019072600001Power Supply · failedFLIGHT# 0065 FLL/MHH REPORT: EMERGENCY LIGHT EXTERIOR CONTROL CIRCUIT BREAKER POPS REPEATEDLY. CORRECTIVE ACTION: T/S EMERGENCY LIGHT SYSTEM. FOUND 21LN POWER SUPLY AT FAULT. R/R 21LN EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-10-04-1. EMERGENCY LIGHTING OPS CSDR MASA2019072511965Light · unsecurePAX DOOR EXIT SIGN LIGHTBULBS INOP. RESECURED BULB.SDR DALA2019072504393Cover · missingEMERG EXIT LIGHT COVER @ 2C MISSING, REPLACED EMERG LIGHT EXIT COVER AS 2R DOOR.SDR DALA2019072504392Light · brokenSEAT 39C EMERGENCY LIGHT BROKEN, REPLACED 39C EMERGENCY LIGHT.SDR SWAA2019082766253Light · brokenCENTER CEILING EMERGENCY EXIT LIGHT BROKEN AT BS. 628. R&R LIGHT IAW AMM.SDR AALA201907289001Cover · brokenAIRCRAFT WAS NOT GROUNDED: R2 DOOR EMERGENCY EXIT LIGHT PLASTIC COVER BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-01.SDR SWAA2019072935322Sign · unsecureFORWARD GALLEY EMERGENCY EXIT SIGN FELL OFF. REINSTALLED SIGN PER SIP.SDR AALA201907269005Cover · brokenAIRCRAFT WAS NOT GROUNDED: R2 DOOR EMERGENCY EXIT LIGHT PLASTIC COVER BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-00.SDR SWAA2019072535304Battery Pack · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019072535297Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019072535280Battery Pack · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PACK PER AMM.SDR SWAA2019072535273Battery Pack · dischargedAFT LT EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR IPXA2019072444833Light · inoperativeINSPECTION TYPE:N/A LAV EMER LIGHT INOP. RELAMPED OPS TEST GOOD PER AMM 33-51-21-4.SDR REXA2019072401129Battery · dischargedEMERG LIGHTS WILL NOT TEST. REMOVED AND REPLACED PS35 EMERG BATT. OPS CK GOOD IAW J/C 33-900-701.SDR DALA2019080624616Light · damagedSHIP 3852 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS: 1C / . CORRECTIVE ACTION: REPLACED OUTER LOWER SEAT SHROUD LOC 1C WITH SERVICBLE UNIT REF B737 CMM 25-29 . (1185075).
Back to JASC 3350