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 SWAA2017030212255Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2017030212243Light · inoperativeMID CABIN EMERGENCY EXIT DOOR LIGHTS BULBS INOP. RELAMPED LIGHT PER AMM.SDR ASAA2017022819971Bulb · failedEMERGENCY LIGHT EXTERIOR OVERWING EXIT LIGHT INOPERATIVE AT LEFT FORWARD OVERWING EXIT. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-04-960-801, OPS NORMAL.SDR AALA20170301008Sign · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AFT AISLE IS BROKEN. REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170228004Epsu · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 13WL FAILED TEST. REMOVED AND REPLACED EPSU IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA201703019013Lens · missingDURING CABIN SWEEP, MAINTENANCE FOUND THE G-3 EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR QXEA2017030100078Light · damagedEMERGENCY LIGHT AT ENTRY WAY DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT. NO OTHER DEFECTS NOTED AT THIS TIME.SDR DALA2017022801631Charger · inoperativeFOUND AISLE CEILING LIGHTS POSITION 37-40 INOPERATIVE. R & R THE BATTERY CHARGER ASSY IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2017022801617Light · inoperativeEMERGENCY AISLE CEILING LIGHT ROW 36 INOPERATIVE. R & R THE EMERGENCY AISLE CEILING LIGHT ASSY AT ROW 36 IAW AMM 33-51. OPS CHECKED GOOD.SDR MASA2017022812637Lamp · inoperativeEMERGENCY LIGHTS AT ROW 15 AND 11 INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017022812636Battery Pack · inoperativeEMERGENCY LIGHTS AT ROW 13 INOPERATIVE. REPLACED THE BATTERY PACK.SDR MASA2017022812635Light · inoperativeCEILING EMERGENCY LIGHT INOPERATIVE.SDR VNAA2017071000005Lens · missingEMERGENCY EXIT SIGN LENS MISSING. INSTALLED EXIT SIGN LENS.SDR IPXA2017022714493Relay · failedEMERGENCY LIGHT BATTERY 1 LOW MESSAGE DURING EMERGENCY LIGHT TEST. R & R RELAY R 25100 IAW WDM 33-51-14. OPS CHECKED OK IAW AMM 33-50-00.SDR SWAA2017030212256Light · looseR2 DOOR EMERGENCY EXIT SIGN LIGHT LOOSE. R&R LIGHT IAW AMM.SDR AALA20170301013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L4 DOOR HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170301012Light · dimAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE COCKPIT IS DIM. REMOVED AND REPLACED LIGHT IAW AMM 33-51-00-201. OPERATIONAL CHECK GOOD.SDR AALA20170301011Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT RIGHT AISLE ROW 14 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170301010Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LEFT AISLE ROW 15 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170301009Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT RIGHT AISLE ROW 25 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170301007Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE WALL IN AISLE ADJACENT TO THE FIRST CLASS GALLEY HAS A MISSING LENS COVER. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170301006Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L2 DOOR HAS A BROKEN LENS COVER. REPLACED L1190 EXIT LIGHT IAW AMM 33-52-01. OPERATIONAL CHECK GOOD.SDR AALA20170301005Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN RIGHT AFT OVERWING FAILED TEST. REMOVED AND REPLACED POWER SUPPLY (AALA20170227021) AND BATTERY PACK AB5-3 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170227022Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FIRST CLASS CEILING EMERGENCY EXIT LIGHTS FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY AT ROW 6 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170227021Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN RIGHT AFT OVERWING FAILED TEST. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK AB5-3 (AALA20170301005) IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170227020Battery · dischargedAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS ROW 21-26 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY AT ROW 25 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170227019Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS ON THE LEFT AND RIGHT AFT OVERWING EXITS FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY AT ROW 21 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR SWAA2017030112226Sign · brokenRIGHT OVERWING EMERGENCY EXIT ROW SIGN LIGHT BROKEN. R & R THE SIGN IAW MM.SDR SWAA2017030112225Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. R & R THE SIGN IAW MM.SDR DALA2017022801651Lens · missingEMERGENCY LIGHT LENS MISSING AT CEILING ABOVE SEAT 7G. REPLACED EMERGENCY LIGHT LENS.SDR ASAA2017022719964Light · crackedFOUND CRACK IN THE FLOOR EMERGENCY LIGHT STRIP NEXT TO SEAT ROWS 2DF AND 3DF. ACFT GROUNDED. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-15-960-801.SDR DALA2017022801630Guard · malfunctionedEMERGENCY LIGHTS OVERHEAD SWITCH GUARD WHEN CLOSED, CAUSES THE EMERGENCY LIGHT TO TURN OFF. ADJUSTED THE SWITCH. EMERGENCY LIGHTS OPS CHECKED GOOD IAW AMM 33-51.SDR SWAA2017022812203Cover · missingFORWARD OVERWING EMERGENCY EXIT SIGN COVER MISSING. INSTALLED THE COVER IAW AMM.SDR SIMA20170227001Battery Pack · inoperativeOVERWING EMERGENCY LIGHTS ON BOTH SIDES INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-17.SDR N6WA2017022701Lens · missingEMERGENCY LIGHTS IN CABIN CEILING ARE MISSING RED LENS.SDR AALA201702289010Lens · missingROW 8C EMERGENCY SEATING LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201702289009Lens · missingMISSING LENS ON FLOOR LEVEL EMERGENCY LIGHT). MAINTENANCE REPLACED THE LENS IAW AMM 33-51-12.SDR AALA201702289007Lens · missingTHE LENS IS MISSING FROM THE EMERGENCY EXIT LIGHT. INSTALLED THE LENS.SDR AALA201702289006Lens · missingL2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201702289005Lens · missingAIRCRAFT GROUNDED. L2 DOOR EMERGENCY EXIT SIGN LENS MISSING. INSTALLED A NEW LENS.SDR AALA201702289004Lens · brokenAIRCRAFT GROUNDED. R2 DOOR EMERGENCY LIGHT LENS BROKEN. REMOVED AND REPLACED THE LENS.SDR AALA201702289003Lens · missingAIRCRAFT GROUNDED. L2 LOWER EMERGENCY LIGHT LENS COVER MISSING. INSTALLED NEW LENS.SDR AALA201702289002Lens · missingCLEAR COVER ON EMERGENCY EXIT SIGN AT SEATS 20A MISSING. REPLACED THE LENS AT ROW 20 A.SDR AALA201702289001Lens · brokenEMERGENCY EXIT LIGHT LENS IS BROKEN AND FALLING OUT. REPLACED THE LENS.SDR CALA2017022700502Lamp · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. OPS CHECKED OK.SDR CALA2017022700501Battery Pack · inoperativeEMERGENCY LIGHTS, SEATS 22ABC TO 27ABC INOPERATIVE. REPLACED THE BATTERY PACK AT SEAT ROW 26ABC, LIGHTS OPS NORMAL .SDR CALA2017022700500Lamp · inoperativeLEFT OVERWING, AFT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM 33-51-03. OPS C HECKED GOOD.SDR MASA2017022712633Bulb · inoperativeGALLEY EXIT LIGHT HAD ONE BULB INOPERATIVE.SDR HNAA2017022700069Bulb · inoperativeCABIN FLOOR EMERGENCY LIGHT IS INOPERATIVE AT ROW 5. REMOVED AND REPLACED THE BULBS AT ROW 5 CABIN FLOOR EMERGENCY LIGHTS, OPS CHECKED GOOD.SDR SWAA2017030212219Lens · looseL1 DOOR EXIT SIGN LENS LOOSE. SECURED LENS SIP.
Back to JASC 3350