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 JJBA20171223012Lamp · inoperativeEMERGENCY LIGHT BY THE MAIN CABIN DOOR HAS A LAMP OUT. R & R THE LAMP IAW AMM 33-50-00. OPS CHECKED GOOD.SDR R61A201712230994Light · damagedAFT RT EMERGENCY LIGHT STRIP DAMAGED.SDR CALA2017122304577Power Supply · faultyRIGHT WING EXTERIOR EMERGENCY LIGHT INOPERATIVE. THE POWER SUPPLY M1671 AT ROW 27 DEF IS BAD, REPLACED THE POWER SUPPLY, ALL LIGHTS IN THIS CIRCUIT OPS CHECKED GOOD IAW AMM 33-51-06.SDR CALA2017122304575Battery · no testR2 DOOR AREA EMERGENCY LIGHT BATTERY M33097 CAPACITY IS LOW. REPLACED BATTERY, CARRIED OUT AN OPS TEST IAW AMM 33-51-06-960-802, REV 81. FOUND NORMAL.SDR CALA2017122304580Light · unsecureSLIDE LIGHT ABOVE THE L2 DOOR CAME OUT. SECURED THE SLIDE LIGHT. OPS GOOD WITH DOOR ARMED.SDR SWAA2018010318674Light · inoperativeR1 DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2017122918668Light · looseLEFT AFT EMERGENCY LIGHT LOOSE. SECURED THE LIGHT IAW MM.SDR AALA201712269062Lens · missingEMERGENCY LIGHT LENS AT BS 727 FOUND MISSING. A NEW LENS WAS INSTALLED IAW AMM 25-63-00.SDR AALA201712269054Sign · detachedEXIT SIGN NEAR BOTTOM LEFT OF FORWARD CATERING DOOR IS DETACHED. SECURED THE SIGN. OPS CHECKED OK.SDR DALA2017122608943Battery · weakCOCKPIT EMERGENCY LIGHT BATTERY WEAK. REPLACED THE BATTERY. SYSTEM OPS NORMAL.SDR SWAA2017122818628Lamp · inoperativeLEFT FWD CABIN EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017122818627Lens · missingEMERGENCY EXIT BULLNOSE LIGHT LENS MISSING AT ROW 9 ABC. INSTALLED A LENS IAW MM.SDR AALA201712269041Lens · missingAIRCRAFT NOT GROUNDED. ROW 8 EXIT PATH LIGHT LENS MISSING. REPLACED EXIT PATH LIGHT AT 8C. OPERATIONS CHECK GOOD.SDR HNAA2017122700401Light · contaminatedRIGHT LOWER EMERGENCY LIGHT HAS MOISTURE INSIDE OF THE LENS. REMOVED, CLEANED MOISTURE AND REINSTALLED IAW AMM 33-50-10-000/400-801-A. OK FOR SERVICE.SDR ASAA2017122222990Lamp · failedAFT ENTRY SLIDE LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPED IAW AMM 33-51-04-960-801. CHECKED GOOD.SDR DALA2017122608892Charger · inoperativeDURING A SERVICE CHECK, FOUND SEVERAL EXIT EMERGENCY LIGHTS INOPERATIVE AROUND THE L2 DOOR. REMOVED AND REPLACED THE BATTERY AND CHARGER IAW AMM 33-51. LIGHTS CHECKED NORMAL.SDR SIMA20171222003Power Supply · inoperativeBOTH RT AND LT OVERWING EMERGENCY LIGHTS INOPERATIVE. R & R THE NR 4 POWER SUPPLY AND BATTERY PACK IAW AMM 33-50-04-000-801-A, AND 33-50-04-400-801-A, OPS CHECKED GOOD.SDR SIMA20171222002Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, & 33-50-10-400-801-A. OPS CHECKED GOOD.SDR ASOA201712224068Charger · inoperativeDURING CREW INSPECTION, THE EMERGENCY LIGHTS WOULD NOT TURN OFF. MAINTENANCE REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT BATTERY CHARGER, OPS TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2017122608875Connector · disconnectedEXTERIOR EMERGENCY LIGHTS INOPERATIVE. FOUND THE RT OVERWING EMERGENCY LIGHT NOT CONNECTED. RECONNECTED THE CONNECTOR. ALL LIGHTS CHECKED GOOD.SDR AALA201712249011Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY LIGHTS FAILED FUNCTIONAL CHECK PER J/C 33C20033002 DURING A 4 CHECK. REPLACED 8 EMERGENCY POWER SUPPLY UNIT BATTERIES PER AMM 33-51-38.SDR AALA201712249010Power Supply · no testEMERGENCY LIGHTS FAILED FUNCTIONAL CHECK IAW J/C 33C20033002. REPLACED THE POWER SUPPLY IAW MM 33-57-38. AIRCRAFT WAS GROUNDEDSDR MASA2017122212851Bulb · inoperativeAFT CABIN EMERGENCY FLOOD LIGHT INOPERATIVE.SDR CALA2017122204569Battery Pack · no testSEAT 15ABC, 20ABC, AND 21ABC EMERGENCY LIGHTS TEST FAILED. SEAT 15ABC EMERGENCY LIGHT POWER SUPPLY (M1694) BATTERY PACK WAS REPLACED AND THE LIGHTS TESTED NORMAL IAW AMM 33-51-06.SDR CALA2017122204568Battery Pack · no testSEATS 22ABC - 38ABC EMERGENCY LIGHTS TEST FAILED. SEAT 26ABC EMERGENCY LIGHT POWER SUPPLY (M1670) BATTERY PACK AND AFT GALLEY EMERGENCY LIGHT POWER SUPPLY (M1672) BATTERY PACK REPLACED AND LIGHT TEST NORMAL AS PER AMM 33-51-06SDR FDEA201712223428Lamp · inoperativeDURING POST FLIGHT INSPECTION, EMERGENCY OVERHEAD LIGHT INOPERATIVE DURING TEST. REPLACED THE LAMPS IAW AMM 33-51-03-2. LIGHTS TESTED GOOD. OK FOR SERVICE.SDR ASAA2017122222968Battery Pack · no testPERFORMING T/C 78233001, FOUND THE L2 DOOR EXTERNAL EMERGENCY LIGHT AND BOTH LOWER EXTERIOR EMERGENCY LIGHTS AFT OF TE FLAPS, FAILED AFTER 15 MINUTES IAW MIG 2C 40-0008611. ACFT GROUNDED. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-01. ALL LIGHTS OPS NOSDR DALA2017122208817Light · unsecureEMERGENCY LIGHT AT SEAT 33FED UNSECURE. SECURED EMERGENCY LIGHT, CHECKED OK.SDR SWAA2017122918696Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M1673 FAILED TO TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017122918639Lens · looseCABIN OVERHEAD OVERWING EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2017122818698Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK M1669 FAILED TO TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017122818677Lens · looseR2 DOOR EXIT SIGN LENS LOOSE. SECURED THE LENS IAW MM.SDR SWAA2017122818624Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK, M1675 FAILED TO TEST. R & R THE BATTERY PACK IAW MM.SDR AALA201712239002Sign · out of positionAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVERHEAD AT LEFT AFT GALLEY DAMAGED. REPOSITIONED EXIT SIGN TO PROPER PLACE.SDR HALA2017122100274Lens · detachedEXIT SIGN LENS FELL OFF. SECURED THE LENS.SDR AALA201712249016Lens · missingAIRCRAFT WAS NOT GROUNDED. DOOR 3L EXIT LENS COVER MISSING. INSTALLED DOOR 3L EXIT LENS COVER PER AMM 33-51-16.SDR AALA201712249015Panel · looseAIRCRAFT WAS NOT GROUNDED. L1 DOOR ENTRY LOWER FWD PANEL WITH EMERGENCY LIGHT NOT PROPERLY MOUNTED. RESECURED L1 DOOR ENTRY LOWER FWD PANEL (W/ E.LIGHT) AS REQUIRED.SDR AALA201712239003Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY EXIT SIGN COVER NEAR RIGHT REAR LAVATORY. REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-01-960-802.SDR ASOA201712214067Sign · disconnectedDURING A MAINTENANCE INSPECTION, THE EXIT SIGN AT SEAT 3C WAS FOUND TO BE INOPERATIVE. MAINTENANCE RECONNECTED THE EMERGENCY LIGHT, OPS TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR REXA2017122101280Battery Pack · inoperativeEMERGENCY LIGHTS ROW 12 ARE OUT. BOTH SIDES. FOUND BATTERY PACK AT FAULT. INSTALLED A SERVICABLE BATTERY PACK IAW AMM 33-51-17. ACFT OK FOR SERVICE.SDR ASAA2017122122967Battery Pack · defectiveESCAPE SLIDE LIGHT AT THE RT AFT SERVICE DOOR IS INOPERATIVE. ACFT GROUNDED. REPLACED THE BATTERY PACK FUSE IAW AMM 33-51-06-960-804. OPS CHECKED GOOD.SDR SIMA20171221003Connector · damagedLAST EMERGENCY LIGHT LEAD DAMAGED. REPAIRED THE WIRING CONNECTOR IAW SWPM 20-21-00 OPS CHECKED GOOD IAW AMM 33-50-00SDR MASA2017122112847Light · inoperativeAFT CABIN CEILING EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR SWAA2017122118588Lamp · inoperativeL2 DOOR SLIDE EGRESS LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR QXEA2017122100706Battery Pack · inoperativeDURING DEPARTURE CHECKLIST, NOTICED SEVERAL EMERGENCY LIGHTS OUT, WOULD NOT ILLUMINATE WHEN SELECTED ON FROM FLIGHT DECK OR CABIN. REMOVED FROM SERVICE. REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY BATTERIES IAW AMM 33-51-01-000-801, AND 33-51-01-40SDR CALA2017122104567Light · malfunctionedENTRY THRESHOLD LIGHT INOPERATIVE AT DOOR EXIT. RESET THE EMERGENCY LIGHT SYSTEM. OPS CHECKED GOOD.SDR CALA2017122104566Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE RT WING IS INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04-960-801, OPS. CHECKED GOOD.SDR CALA2017122104562Light · malfunctionedEMERGENCY LIGHTS FLASHING ON OFF OVERWING LEFT SIDE OF AIRCRAFT CABIN CREW STATED THAT THE EMERG EXIT SIGN ON THE CEILING, ADJACENT TO THE OVERWING EMERG EXIT HATCH FLASHED FOR ABOUT 30 SECS DURING CLIMB, ALSO STATED THAT THEY WEREN''T UNSURE IF IT WAS THE EMESDR SWAA2017122918654Lamp · inoperativeLEFT AFT UPPER EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR SWAA2017122918645Lens · missingR2 DOOR EXIT LIGHT LENS MISSING. INSTALLED THELENS IAW MM.
Back to JASC 3350