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 MASA2018081873492Bulb · inoperativeEMERGENCY EXIT SIGN, AT THE SERVICE DOOR, HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR MASA2018081873491Bulb · inoperativeEMERGENCY EXIT SIGN AT THE PAX DOOR HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR MASA2016081871490Lamp · inoperativeCEILING EMERGENCY FLOOD LIGHT AT ROW 1 WAS INOPERATIVE. REPLACED THE LAMP.SDR CALA2018081701814Lamp · inoperativeAFT GALLEY EMERGENCY EXIT SIGN ON THE CEILING HAD ONE LAMP INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-01-960-801. OPS CHECKED OK.SDR CALA2018081701813Lamp · inoperativeL2 DOOR LOWER EMERGENCY EXIT SIGN AND UPPER EMERGENCY LIGHT HAD TWO LAMPS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-01-960-801. OPS CHECKED OK.SDR CALA2018081701812Lamp · inoperativeRIGHT FWD EMERGENCY EXIT HATCH FWD LWR EMERGENCY EXIT SIGN LAMPS WERE INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-00-960-801. OPS CHECKED OK.SDR CALA2018081701811Lamp · inoperativeLEFT FWD EMERGENCY ESCAPE HATCH EMERGENCY LIGHT FWD LAMP WAS INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-01-960-801. OPS CHECKED OK.SDR DALA2018081705115Battery Pack · inoperativeEMERGENCY LIGHTS AT THE L1, R1, & COCKPIT WERE INOPERATIVE. REPLACED THE BATTERY PACK. OPS OK IAW AMM 33-53.SDR SWAA2018091124990Lens · brokenG1 GALLEY CLOSE OUT PANEL EMERGENCY EXIT LIGHT HOUSING LENS BROKEN. R&R LENS IAW CMM.SDR REXA2018090400797Cover · damagedEMER PATH LIGHTING COVER HAS SEVERAL CRACKS AND DAMAGED SPOTS IN CABIN. REMOVED & REINSTALLED EMERGENCY FLOOR TRACK LIGHTING IAW AMM 33-51-01-000-801 AND AMM 33-51-01-400-801. EMERGENCY FLOOR TRACK LIGHTING OPS CHECKED GOOD IAW AMM 33-51-00-710-801 STEPS 2A & SDR SWAA2018082024320Light · inoperativeEMERGENCY LIGHT INOP AT ROW 6. RELAMPED LIGHT PER AMM.SDR SWAA2018082024316Light · dimRT OVERWING EMERGENCY EXIT LIGHT DIM. R&R LIGHT PER AMM.SDR SWAA2018082024287Sign · detachedMID CABIN OVERHEAD EXIT SIGN DETACHED FROM ITS BRACKET. R&R SIGN IAW AMM.SDR ASAA201808205850Battery Pack · dischargedL2 DOOR EMERGENCY LIGHTS INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06, TESTED NORMAL.SDR QXEA2018082000296Battery Pack · failedALL EMERGENCY LIGHTS ON THE INTERIOR AND EXTERIOR FORWARD OF ROW 7 FAILED TO ILLUMINATE WHEN EMERGENCY LIGHTS TURNED TO THE ON POSITION. REPLACED BATTERY PACKS.SDR YENA20180820316Lamp · inoperativeSEVERAL EMERGENCY EXIT SIGNS INOPERATIVE IN THE CABIN. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-11. OK FOR SERVICE.SDR AALA201808179001Lens · missingROW 15 EMERGENCY LIGHT LENS WAS MISSING. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-00.SDR AALA201808179002Shroud · looseL1 DOOR EMERGENCY LIGHT SHROUD CAME LOOSE. SECURED THE EMERGENCY LIGHT SHROUD. OPS CHECKED GOOD.SDR DALA2018081705116Bulb · inoperativeL1 EMERGENCY LIGHT INOPERATIVE. FOUND THE BULB OUT. REPLACED THE BULB. OPS GOOD IAW AMM 33-50.SDR SIMA20180815016Light · damaged#5 LT EMERGENCY LIGHT STRIP EXTRUSION IS DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED #5 LT EMERGENCY LIGHT STRIP EXTRUSION IAW AMM 33-50-12. SEE BOW301252 FOR OPC.SDR SIMA20180815015Light · inoperativeEXTERNAL EMERGENCY LIGHT ON LT OVERWING PANEL INOP. C/A-COMPLETE:REMOVED AND REPLACED BULB ON EXTERNAL EMERGENCY LIGHT ON LT OVERWING PANEL IAW AMM 33-50-10 OPS CHECK GOOD.SDR SIMA20180815012Light · damaged#1 AND #4 FLOOR EMERGENCY LIGHT STRIPS DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED #4 #1 FLOOR EMERGENCY LIGHT STRIP IAW AMM 33-50-12. SEE BOW301252 FOR OPC.SDR SIMA20180815011Light · damaged#3 LT EMERGENCY LIGHT STRIP EXTRUSION IS DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED #3 LT EMERGENCY LIGHT STRIP EXTRUSION IAW AMM 33-50-12. SEE BOW301252 FOR OPC.SDR SIMA20180815010Light · damaged#1 LT EMERGENCY LIGHT STRIP EXTRUSION IS DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED #1 LT EMERGENCY LIGHT STRIP EXTRUSION IAW AMM 33-50-12. SEE BOW301252 FOR OPC.SDR SIMA20180815009Light · damaged#7 LT EMERGENCY LIGHT STRIP EXTRUSION IS DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED #7 LT EMERGENCY LIGHT STRIP EXTRUSION IAW AMM 33-50-12. SEE BOW301252 FOR OPC.SDR SIMA20180815007Light · damaged#4 LT EMERGENCY LIGHT STRIP EXTRUSION IS DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED #4 LT EMERGENCY LIGHT STRIP EXTRUSION IAW AMM 33-50-12. SEE BOW301252 FOR OPC.SDR SIMA20180815019Structure · damagedRT FLOOR EXTRUSIONS #1 THRU #8 ARE DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED RT FLOOR ECTRUSIONS #1 THRU #8 IAW AMM 33-50-12.SDR SIMA20180815021Light · damaged#5 EMERGENCY LIGHT STRIP IS DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED #5 FLOOR EMERGENCY LIGHT STRIP IAW AMM 33-50-12. SEE BOW 301252 FOR OPC.SDR ASAA2018091125801Fuse · failedWHILE ACCOMPLISHING T/C 7823308, EMERGENCY LIGHT- OPERATIONAL CHECK. R1 DOOR EMERGENCY LIGHT EXTERNAL INOP. GROUNDED - YES. REPLACED EMERGENCY BATTERY CHARGER FUSE ON LIGHT FOR R1 DOOR EXTERIOR LIGHT AND OPS CHECKED, OPS CK GOOD IAW AMM 33-51-06-960-804.SDR SIMA2018091015006Light · inoperativeEMERGENCY EXIT LIGHT ON BOTTOM OF GALLEY SERVICE DOOR INOP. PERFORMED OCK OF EMERGENCY LIGHTS IAW AMM 33-50-00. OPS CHECK GOOD.SDR DALA2018082845324Light · damagedEMERGENCY EXIT LIGHT AT SEAT ROW 16A WAS DAMAGED. REPLACED EMERGENCY LIGHT AND SHROUD.SDR SWAA2018082024443Cover · missingL1 DOOR EMERGENCY EXIT LIGHT COVE MISSING RED ARROW. R&R COVER PER AMM.SDR SWAA2018082024440Lens · fadedLT OVERWING EMERGENCY DOOR LIGHT LENS FADED. R&R LENS IAW MM.SDR SWAA2018082024439Lens · fadedRT OVERWING EMERGENCY DOOR LIGHT LENS FADED. R&R LENS IAW MM.SDR SWAA2018082024438Cover · missingR1 DOOR EMERGENCY EXIT LIGHT COVER MISSING RED ARROW. R&R COVER PER AMM.SDR SWAA2018082024437Battery Pack · dischargedEMERGENCY LIGHT BATTERY M1674 INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018082024436Battery Pack · dischargedEMERGENCY LIGHT BATTERY M1669 INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018082024325Battery · failedLT AFT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018082024324Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018082024323Lens · looseLT EMERGENCY LIGHT LENS COVER LOOSE AT ROW 4. SECURED LENS PER AMM.SDR SWAA2018082024304Light · brokenR1 DOOR LOWER EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR AALA2018082016007Battery Pack · no testEMERGENCY BATTERY PACK M737 LOST ITS CHARGE. REPLACED THE BATTERY PACK.SDR AALA201808179003Power Supply · faultyDURING AN OPERATIONAL TEST OF THE EMERGENCY LIGHTS, FOUND THE POWER SUPPLY 14WL FAULTY. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR DALA2018081605107Lens · missingDURING INSPECTION, FOUND THE EXIT SIGN LENS MISSING AT 20E. MAINTENANCE INSTALLEDTHE EXIT SIGN LENS. OK FOR SERVICE.SDR SWAA2018081624284Battery · failedEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2018081624283Battery · failedEMERGENCY LIGHT BATTERY M1670 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2018081624282Battery · failedEMERGENCY LIGHT BATTERY M1668 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2018081624281Battery · failedEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2018081624276Lens · looseCENTER AISLE EXIT SIGN LENS FELL OUT. REINSTALLED LENS PER MM.SDR SWAA2018081624275Light · contaminatedEEPLS HAS MOISTURE DAMAGE BETWEEN ROWS 3 & 4. R&R EEPLS SECTION PER MM.
Back to JASC 3350