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 SWAA2018052322195Light · inoperativeLT OVERWING EXIT LOWER EMERGENCY LIGHT BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018052322184Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER AMM.SDR SWAA2018052322183Lens · missingL1 DOOR EMERGENCY SIGN MISSING RED ARROW. R&R LENS IAW AMM.SDR SWAA2018052322182Lens · missingR1 DOOR EMERGENCY SIGN MISSING RED ARROW. R&R LENS PER AMM.SDR YENA201805220214Battery Pack · no testEPSU BATTERY 12WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY IAW AMM 33-51-38, SYSTEM OPS CHECKED NORMAL.SDR YENA2018052320213Battery Pack · no testEPSU 10WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY IAW AMM 33-51-38, SYSTEM OPS CHECKED NORMAL.SDR YENA2018052320212Battery Pack · no testEPSU BATTERY 11WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY IAW AMM 33-51-38, SYSTEM OPS CHECKED GOOD.SDR MASA2018052213249Switch · inoperativeALL EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED THE COCKPIT EMERGENCY LIGHT SWITCH PANEL.SDR CALA2018060531348Battery Pack · no testR4 DOOR EMERGENCY POWER SUPPLY M33408, BATTERY PACK CAPACITY CHECK FAILED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018060531347Battery Pack · no testL4 DOOR EMERGENCY POWER SUPPLY M33407 BATTERY PACK CAPACITY CHECK FAILED. THE POWER SUPPLY AND BATTERY PACK WERE REPLACED, TESTED NORMAL IAW AMM 33-51-06.SDR ASOA201805250134Control Panel · faultyCREW REPORTED THE EMERGENCY LIGHTS TURNED ON WHEN BRIGHT/DIM SWITCH WAS PRESSED ON THE FA PANEL. MX REMOVED AND REPLACED FLIGHT ATTENDANT CONTROL PANEL ASSEMBLY, CHECKED GOOD. RETURNED TO SERVICE.SDR AALA201805249029Battery Pack · defectiveTHE AIRCRAFT WAS NOT GROUNDED. EXTERIOR EMERGENCY LIGHT ON WITH EMERGENCY LIGHT SWITCH IN ARM POSITION. INTERIOR EMERGENCY LIGHTS NORMAL. REPLACED OVERWING EMERGENCY LIGHTS BATTERY PACK AND TESTED PER AMM 33-53-00. LIGHTS CHECK GOOD.SDR AALA201805239036Power Supply · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT ON BOTH ENTRY DOOR IS INOPERATIVE. REMOVED AND REPLACED CABIN EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-01. OPERATIONS CHECK GOOD.SDR AALA20180522003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS FROM SEAT 29D TO 36D WERE DIM. MAINTENANCE REPLACED BATTERY FOR AFT CABIN EMERGENCY LIGHT PER AMM 33-51-07. SEAT MOUNTED EMERGENCY LIGHTS 29D TO 36D AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805239030Charger · no testSEAT 3A EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY AND CHARGER. PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA201805239029Charger · no testSEAT 2A EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY AND CHARGER. PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA201805232001Battery Pack · inoperativeCABIN EMERGENCY LIGHTS DID NOT TEST AT ROW 10D AND 13D. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-06, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201805231002Battery · no testSEAT 3A EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY AND CHARGER. PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA201805231001Battery · no testSEAT 2A EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY AND CHARGER. PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA201805239017Battery · no testWHILE PERFORMING A PS OPERATIONAL TEST CHECK, THE EMERGENCY LIGHTS FAILED. REPLACED THE 11WL BATTERY IAW AMM 33-51-38.SDR AALA201805239004Light · malfunctionedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS EMERGENCY EXIT LIGHTS ARE ILLUMINATED WHEN EMERGENCY EXIT SWITCH FLIGHT DECK ARMED - ANN LIGHTS BLANK. RESET CIDS PER AMM 23-73-00.SDR SWAA2018052222161Lens · missingRT OVERWING EMERGENCY EXIT SIGN LENS MISSING. R&R LENS ASSEMBLY PER AMM.SDR AALA201805229003Battery Pack · no testCEILING EMERGENCY LIGHTS NEXT TO THE R4 DOOR AND AFT GALLEY AISLE, CEILING DID NOT PASS A TEST, REMAINS OFF. ACCOMPLISHED TROUBLESHOOTING IAW 33-51-00. FOUND A DEFECTIVE BATTERY PACK IN THE EMERGENCY POWER SUPPLY UNIT M33409. REPLACED THE BATTERY PACK IAWSDR REXA201805220400Battery Pack · inoperativeCABIN EMERGENCY FLOOD LIGHTS IN THE FWD CABIN WERE FOUND INOPERATIVE. REMOVED AND REPLACED THE ESPU BATTERY PACK NR 2, IAW AMM 33-51-17, OPS CHECKED GOOD.SDR DALA2018052203508Lens · missingDURING PDC, FOUND OVERHEAD EMERGENCY LIGHT LENS MISSING AT ROW 12ABS. REPLACED THE OVERHEAD EMERGENCY LIGHT LENS.SDR AALA20180522002Battery Pack · dischargedAFT EMERGENCY LIGHTS ARE DIM WHEN POWERED BY THE AB5-3 BATTERY PACK. REPLACED THE BATTERY PACK IAW MM 33-60-98.SDR ASOA201805217087Battery Pack · inoperativeAFT 3 EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT FRAME 52 IAW AMM 33-50-04.SDR FDEA201805211265Lamp · inoperativeLEFT SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM 33-51-06-962-001-001, REV 121.1.SDR MASA2018052113245Light · inoperativeALL EXTERIOR EMERGENCY LIGHTS INOPERATIVE.SDR MASA2018052113244Light · inoperativeALL CABIN EMERGENCY LIGHTS INOPERATIVE.SDR MASA2018052113243Battery Pack · dischargedALL EMERGENCY EXIT LIGHTS FADE OUT PERIODICALLY. CHARGED THE BATTERIES.SDR MASA2018052113242Light · inoperativeCEILING EMERGENCY FLOODLIGHT AT ROW 1 WAS FOUND INOPERATIVE.SDR AALA20180521004Charger · inoperativeSEAT 5A EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-00.SDR DALA2018052103461Power Supply · inoperativeLEFT AND RIGHT OVERWING EMERGENCY EXIT LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE OVERWING EMERGENCY EXIT LIGHT POWER SUPPLY IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2018052903672Housing · brokenEMERGENCY LIGHT ASSEMBLY BROKEN AT SEATS 24D AND 32D. FWD TO MCO/PLAC PER MEL 33-50-03A. REMOVED AND REPLACED EMERGENCY LIGHT HOUSING AT SEATS 24D AND 32D. OPERATION CHECKS GOOD.SDR FDEA2018052301266Power Supply · failedEMERGENCY LIGHT BATTERY 1 LOW ALERT. REPLACED THE POWER SUPPLY. OPS CHECKED GOOD.SDR AALA201805239003Cover · missingAIRCRAFT WAS NOT GROUNDED. PASSENGER SEAT AT 4C ESCAPE PATH LIGHT COVER MISSING. REPLACED ESCAPE PATH LIGHT COVER AT SEAT 4C.SDR MYWA2019052300021Ballast · failedRIGHT AFT EMERGENCY EXIT LIGHTS WERE INOPERATIVE. THE BALLAST WAS REPLACED.SDR MYWA201905230020Ballast · failedDURING THE PRE FLIGHT TRANSIT CHECK, THE RIGHT AFT EMERGENCY EXIT LIGHTS WERE INOPERATIVE. THE BALLAST WAS REPLACED.SDR ASAA201805224728Lens · detachedEXIT SIGN LENS DETACHED BY THE L1 DOOR. ACFT GROUNDED. ATTACHED THE EXIT SIGN LENS.SDR SWAA2018052222167Cover · missingL1 DOOR EMERGENCY EXIT SIGN COVER MISSING. R&R SIGN ASSEMBLY IAW AMM.SDR SWAA2018052222166Sign · looseR2 DOOR EMERGENCY EXIT SIGN LOOSE. R&R SIGN BASE IAW MM.SDR SWAA2018052222160Light · inoperativeRT EMERGENCY BULLNOSE LIGHT INOP AT ROW 8. REPAIRED LIGHT IAW MM.SDR SWAA2018052122132Battery Pack · dischargedLT EMERGENCY EXIT AISLE LIGHTS INOP BETWEEN BS 500C TO BS 560. R&R BATTERY PACK IAW AMM.SDR SWAA2018052122131Battery Pack · failedLT MID CABIN EMERGENCY EXIT BULLNOSE LIGHTS FAILED CAPACITY CHECK. R&R BATTERY PACK IAW AMM.SDR REXA201805220399Light · crackedFOUND THE LEFT OVERWING EMERGENCY LIGHT ASSY CRACKED. REMOVED AND REPLACED THE EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR AALA201805229005Battery · failedSEAT 4A EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-51-00. OPS CHECKED NORMAL.SDR AALA201805221003Charger · failedSEAT 4A EMERGENCY LIGHT INOPERATIVE. REPLACED THE CHARGER IAW AMM 33-51-00. OPS CHECKED NORMAL.SDR SWAA2018052122072Lens · looseG1 GALLEY EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER CMM.SDR SWAA2018052122071Lens · looseL2 DOOR EMERGENCY EXIT SIGN LENS LOOSE OF AFT LAV. SECURED LENS IAW MM.
Back to JASC 3350