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 CALA2016101700767Battery Pack · defectiveEMERGENCY LIGHT BATTERY PACK M1674 AT STA 322 WILL NOT HOLD CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1674 AT STA 322 IN ACCORDANCE WITH AMM 33-51-06-900-805, OPS CHECK OF BATTERY PACK GOOD IN ACCORDANCE WITH AMM 33-51-06-960 -805.SDR CALA2016101700766Light · inoperativeRT EXTERIOR EMERGENCY LIGHT AFT OF RIGHT WING INOP. REMOVED AND REPLACED RT EXTERIOR EMERGENCY LAMP AFT OF RIGHT WING IN ACCORDANCE WITH AMM 33-51-04-960-801. OPS CHECK NORMAL.SDR CALA2016101700765Battery Pack · defectiveEMERGENCY BATTERY PACK M1676 AT STA 500C+7 WILL NOT HOLD A CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1676 AT STA 500C+7 IN ACCORDANCE WITH AMM 33-51-06-960-805. OPS CHECK OF BATTERY PACK GOOD IN ACCORDANCE WITH AMM 33-51-06-9 60-805.SDR CALA2016101700764Battery Pack · defectiveEMERGENCY BATTERY PACK M1672 AT STA 952 WILL NOT HOLD A CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IN ACCORDANCE WITH AMM 33-51-06-960-805. OPS CHECK OF BATTERY PACK M1 672 AT STA 952 GOOD IN ACCORDANCE WITH AMM 33-51-06-960- 805.SDR ASAA2016101418341Battery Pack · failedDURING CLIMB, FA REPORTED FWD EMERGENCY LIGHTS ILLUMINATED. THERE WAS A BRIEF ELECTRICAL ODOR IN THE COCKPIT WHICH DISSIPATED. CIRCUIT BREAKER P18 A11 LIGHTING EMERGENCY CHARGER FWD WAS FOUND TRIPPED. ABOUT 20 MINUTES LATER, FWD EMERGENCY LIGHTS EXTINGUISHED SDR SIMA20161014002Battery Pack · failedSECOND AND THIRD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-50-12.SDR SIMA20161014001Light · inoperativeLEFT WING EMEGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT AW AMM 33-50-10. OPS CHECKED GOOD.SDR JJBA20161014018Connector · unsecureROW 18 EMERGENCY EXIT LIGHT INOPERATIVE. SECURED ELECTRICAL CONNECTOR TO ROW 18 EMG EXIT LIGHT. OPS CHECKED GOOD.SDR 29GA2016101600001Sign · inoperativeFLIGHT 059 TPA/FLL: CABIN FORWARD EXIT SIGN INOP. R&R FOWARD EMERGENCY HORIZONTAL EXIT SIGN, OPS CHECK GOOD IAW AMM 33-50-40-04.SDR AALA20161014002Power Supply · faultyAIRCRAFT WAS IN BASE MAINTENANCE. POWER SUPPLY M1673 FAILED, WORK CARD 2908. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06.SDR AALA20161014001Power Supply · failedAIRCRAFT WAS IN BASE MAINTENANCE. POWER SUPPLY M1671 FAILED, WORK CARD 2908. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06.SDR SWAA2016101308756Light · damagedLEFT EMERGENCY LIGHT DAMAGED BETWEEN BS 380 TO 905. R & R THE LIGHT IAW MM.SDR SWAA2016101308755Light · damagedRIGHT EMERGENCY LIGHT DAMAGED BETWEEN BS 405 TO 903. R & R THE LIGHT IAW MM.SDR HNAA2016101400316Bulb · inoperativeEMERGENCY LIGHT IS INOP. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR DALA2016102107447Battery Pack · failedDURING EMERGENCY LIGHT TEST 2 BATTERY PACKS FAILED. REPLACED M6756 AND M6758. SYSTEM OPERATION IS NORMAL.SDR AALA20161019002Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. LEFT CABIN EMERGENCY LIGHTS BETWEEN FUSELAGE STATIONS 1600 AND 1800 INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33407 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161018001Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. RIGHT CABIN EMERGENCY LIGHTS BETWEEN FUSELAGE STATIONS 846 AND 1000 INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33098 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161015003Indicator · brokenAIRCRAFT IN BASE MAINTENANCE. AFT LEFT DOOR 1 EXIT INDICATOR BROKEN. REMOVED AND REPLACED INDICATOR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161015002Indicator · brokenAIRCRAFT IN BASE MAINTENANCE. FORWARD RIGHT DOOR 1 EXIT INDICATOR BROKEN. REMOVED AND REPLACED INDICATOR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2016101708865Lens · dirtyFUSELAGE EMERGENCY LIGHT LENS DIRTY AT BS 757, LBL 51. CLEANED LENS IAW AMM.SDR SWAA2016101708864Lens · dirtyFUSELAGE EMERGENCY LIGHT LENS DIRTY AT BS 757, RBL 51. CLEANED THE LENS IAW AMM.SDR ASAA2016101318348Cover · brokenEMERGENCY LIGHT COVER NEAR THE L1 DOOR HAS BROKEN GLASS. ACFT GROUNDED. REMOVED AND REPLACED EMERGENCY LIGHT COVER.SDR SWAA2016101408802Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM AND DWG.SDR SWAA2016101408775Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM AND DWG.SDR SWAA2016101408772Light · looseFORWARD GALLEY DOOR LOWER EMERGENCY LIGHT ASSEMBLY LOOSE. R&R LIGHT ASSEMBLY PER MM.SDR AALA20161013007Portable Light · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. FLIGHT DECK PORTABLE EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-51-01.SDR MASA2016101312454Bulb · burned outROW 18 C/D EMRGENCY EXIT SIGN BULBS BURNED OUT.SDR MASA2016101312453Bulb · inoperativeSERVICE DOOR EMERGENCY FLOOD LIGHT HAD TWO BULBS MISSING. REPLACED THE BULBS.SDR MASA2016101312452Lamp · inoperativeROW 11 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR UHLA201610130458Sign · damagedL1 DOOR LOWER EMERGENCY ENTRANCE EXIT IDENTIFICATION LIGHT DAMAGED. R&R L1 DOOR LOWER EMERGENCY EXIT SIGN IAW AMM 22-50-15. OPS CHECKED GOOD.SDR IPXA2016101309354Epsu · inoperativeEMERGENCY LIGHTS WILL NOT GO OUT AFTER TEST. R & R EMERGENCY LIGHT EPSU IAW 33-51-14-0401. OPS OKSDR R61A201610130586Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT NEAR THE CLOSET WAS NOT ILLUMINATING. MAINTENANCE REMOVED AND REPLACED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR N6WA2016101301Bulb · inoperativeRIGHT EMERGENCY EXIT FLOOR LIGHT BULBS INOPERATIVE. PERFORMED OPS CHECK OF EMERGENCY LIGHTS IAW AMM 33-50-00, OPS CHECKED GOOD.SDR CALA2016101300758Battery Pack · dischargedOVERHEAD EMERGENCY EXIT LIGHTING INDICATOR AT SEAT 32F AND 35F INOP. R&R BATTERY PACK ASSEMBLY IAW AMM 33-51-06. OP CHECKS GOOD.SDR MASA2016101312451Bulb · inoperativeMAIN CABIN DOOR EMER LIGHTS-1 BULB INOPERATIVE. REPLACED THE BULB.SDR AALA201610139001Lens · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN MOUNT TAB ON EMERGENCY EXIT LIGHT LENS AT DOOR L3. REPLACED EMERGENCY EXIT LENS PER AMM 33-51-13.SDR RAIA201610120001Bulb · inoperativeEMERGENCY LIGHT AT ROW 22 INOPERTIVE. R & R THE BULB. OPS CHECKED GOOD.SDR SWAA2016101408788Light · inoperativeLT AFT OVERHEAD BIN EMERGENCY LIGHT INOP AT ROW 24. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2016101408784Lens · looseRT EMERGENCY EXIT BULLNOSE LENS LOOSE AT ROW 9. SECURED LENS PER AMM.SDR AALA201610149019Panel · defectiveFOUND LEFT & RIGHT EMERGENCY EXIT LIGHTS DIM AT OVER WING EXITS. WALL MOUNTED LIGHTS 42WL & 43WL. REMOVED RT& LEFT LIGHT DISTRIBUTION PANELS ASSY & OPS TEST OK IAW AMM 33-51-11-000-001-A.SDR ASAA2016101218316Cover · detachedEXIT SIGN COVER AT ROW 17F FELL OFF. ACFT GROUNDED. ATTACHED EXIT SIGN COVER AT ROW 17F.SDR SWAA2016101308731Lens · detachedL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS FELL OFF. SECURED LENS IAW MM.SDR DALA2016101307238Battery Pack · inoperativeMULTIPLE FIRST CLASS EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED & REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2016101307237Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS INOPERATIVE AT ROWS 11 TO 15. REPLACED THE BATTERY PACK IAW AMM 33-53-00 OP CHECKED GOOD.SDR AALA201610139011Lens · unsecureLENS FALLS OFF EMERGENCY EXIT MARKER LIGHT AT DOOR L3. R & R THE LENS IAW AMM 33-51-13-400-001-A, LIGHT OPS CHECKED GOOD.SDR AALA20161013002Battery Pack · inoperativeL2 DOOR EMERGENCY LIGHT BATTERY IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR SIMA20161012001Battery Pack · inoperativeF/A REPORTS THAT CABIN FLOOR EMERGENCY LIGHT MID CABIN ARE INOPERATIVE. R & R THE NR 3 BATTERY IAW WORK CARD 33-700-19.SDR MASA2016101212450Battery Pack · inoperativeEMERGENCY CEILING LIGHT INOPERATIVE ROW 12. REPLACED BATTERY PACKSDR R61A201610120583Light · malfunctionedCREW RECEIVED AN EMERGENCY LIGHT BATTERY FAULT AND THE FORWARD HALF OF EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE RESET AIRCRAFT POWER IAW AMM AND OPS CHECKED GOOD.SDR AALA20161012007Light · brokenEMERGENCY LIGHT IN FIRST CLASS GALLEY IS BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT AND ACCOMPLISHED OPS CHECK IAW MM 33-51-00. SYSTEM CHECKED NORMAL.
Back to JASC 3350