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 SWAA2017091216301Cover · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R&R COVER PER MM.SDR SWAA2017091216276Light · inoperativeLEFT CABIN INTERIOR EGRESS BULLNOSE LIGHT INOPERATIVE BETWEEN ROWS 1 TO 4. R & R THE LIGHT IAW AMM.SDR SWAA2017091216275Battery Pack · inoperativeR2 DOOR INNER SIGN INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017091216274Battery Pack · inoperativeR2 DOOR OUTER SIGN LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017091216273Sign · looseOVERWING EXIT SIGN LOOSE. SECURED THE SIGN IAW SIP.SDR SWAA2017091216271Light · inoperativeRIGHT CABIN INTERIOR EGRESS BULLNOSE LIGHT INOPERATIVE BETWEEN ROWS 16 TO 18. R & R THE LIGHT IAW AMM.SDR SWAA2017091216234Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. R & R THE LENS IAW SOPM.SDR SWAA2017091216229Battery Pack · inoperativeAFT OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR AALA201709089024Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017090800009Light · detachedEVACUATION LIGHT HANGING LOOSE AT LOCATION 41B. SECURED THE LIGHT, OK FOR SERVICE.SDR DALA2017090800005Lamp · inoperativeCEILING EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMAL.SDR DALA2017090800004Bulb · inoperativeLOWER CREW REST VERTICAL EXIT SIGN IS INOPERATIVE. REPLACED THE BULBS, OPS CHECKED NORMAL.SDR DALA2017090800003Bulb · inoperativeLOWER CREW REST HORIZONTAL EXIT SIGN IS INOPERATIVE. REPLACED ALL EIGHT BULBS. OPS CHECKED NORMAL.SDR REXA2017090700990Wire · shortedCIELING EMER EXIT SIGN INOP CREW REPORTED. FOUND SHORTED WIRE LY32A22, REPAIRED IAW ESPM 20-15-00. OPS CHECK GOOD IAW AMM 33-51-00. REF NRWC # 631494 FOR DETAILS ON WORK PERFORMED.SDR AALA201709089025Lens · brokenAIRCRAFT WAS NOT GROUNDED. RED LIGHT LENS COVER BROKEN OFF THE CEILING MOUNTED CALL LIGHT IN THE FLIGHT DECK ENTRY. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170907004Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PROXIMITY LIGHT AT THE G2 GALLEY AISLE WALL IS DAMAGED. REMOVED AND REPLACED LIGHT PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR ASAA2017090721840Battery Pack · intermittentCABIN EMERGENCY LIGHTS RANDOMLY TURN ON AND OFF. ACFT GROUNDED. FOUND THE L1 DOOR & SLIDE LIGHTS ILLUMINATING RANDOMLY. REPLACED THE M1675 BATTERY PACK IAW AMM 33-51-06. OPS NORMAL.SDR DALA2017090806736Lens · missingEXIT LENS ABOVE AISLE AT THE R2 DOOR IS MISSING. INSTALLED A NEW LENS.SDR IPXA2017090721459Bulb · inoperativeEMERGENCY EXIT LIGHT HAS FOUR INOPERATIVE BULBS. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR DALA2017090806730Lamp · inoperativeCREW REPORTED THE L4 SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS. CHECKED GOOD.SDR REXA2017090700983Switch · malfunctionedTHE EXIT LIGHT BY THE SIDE DOOR AT ROW 8 LEFT INOPERATIVE. CYCLED F/A EMERGENCY LIGHT SWITCH AND COCKPIT PANEL SWITCH. ALL CHECKED GOOD IAW AMM 33-50-00.SDR REXA2017090700982Switch · malfunctionedEMERGENCY LIGHT INOPERATIVE. CYCLED F/A EMERGENCY LIGHT SWITCH, AND THE COCKPIT PANEL SWITCH. ALL CHECKED GOOD IAW AMM 33-50-00.SDR MASA2017090712611Light · inoperativeROW 14 EMERGENCY CEILING FLOODLIGHT INOPERATIVE.SDR REXA2017090700981Sign · brokenEMERGENCY EXIT SIGN BY SERVICE DOOR BROKEN. REMOVED AND REPLACED EMERGENCY EXIT SIGN, IAW AMM 33-51-10. OPS CHECKED GOOD.SDR SWAA2017091916424Light · brokenFORWARD LAV EMERGENCY LIGHT BROKEN. R&R LIGHT IAW AMM.SDR SWAA2017091216315Battery Pack · dischargedEMERGENCY BATTERY PACK M1673 LOW CAPACITY. R&R BATTERY PACK IAW AMM.SDR SWAA2017091216283Housing · damagedPASSENGER CABIN SIDEWALL 232YHW EMERGENCY EXIT SIGN HOUSING DAMAGED. R&R SIGN HOUSING IAW AMM.SDR FDEA201709062462Power Supply · failedDURING CA'S PREFLIGHT CHECKS RECEIVED "EMER LT BATT 1 LO" LVL1 ALERT. REMOVED AND REPLACED EMERG POWER SUPPLY REF 33-51-01-4.SDR SWAA2017091216235Lens · missingRIGHT OVERWING LOWER EXIT LIGHT LENS MISSING. INSTALLED THE LENS IAW AMM.SDR DALA2017090706784Lens · missingCABIN CEILING MOUNTED EMERGENCY LIGHT MISSING THE LENS AT ROW 25CDE.SDR AALA201709089027Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT OUTSIDE OF LAVATORY 3F-RC HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR DALA2017090706751Power Supply · no testFWD EPSU FAILED EMERGENCY LIGHT TEST, REPLACED FWD EPSU.SDR SWAA2017090816219Battery Pack · faultyRIGHT EMERGENCY EXIT LIGHTS FAULTY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017090816218Battery Pack · faultyLEFT EMERGENCY EXIT LIGHTS FAULTY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017090816210Sign · inoperativeRIGHT SIDE AFT LOWER EMERGENCY SIGN LIGHT INOPERATIVE. R & R THE SIGN IAW AMM.SDR SWAA2017090816208Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT LOCATION M1674. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017090816202Battery Pack · dischargedEMERGENCY BATTERY PACK M1669 HAD LOW CAPACITY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017090816201Battery Pack · dischargedEMERGENCY BATTERY PACK M1668 HAD LOW CAPACITY. R & R THE BATTERY PACK IAW AMM.SDR ASAA2017090621835Lens · detachedR2 DOOR EXIT SIGN COVER FELL OFF. ACFT GROUNDED. REMOVED & REPLACED THE EXIT SIGN LIGHT ASSY IAW AMM 33-51-01-960-802. OPS CHECKED GOOD.SDR AALA201709079003Lens · missingL4 DOOR LOWER EMGENCY EXIT SIGN MISSING. REPLACED THE SIGN LENS, OK FOR SERVICE.SDR IPXA2017090721448Warning Message · false activationEMERGENCY LIGHT BATTERY 1 LOW ILLUMINATED DURING PREFLIGHT. PERFORMED AN EMERGENCY LIGHT SYS TEST. OPS TESTED NORMAL. OK FOR SERVICE IAW AMM 33-50-00/501.SDR A6WA201745254Battery Pack · inoperativeDURING RON MAINTENANCE, THE AFT OVERWING EMERGENCY EXIT WERE FOUND TO BE INOPERATIVE BOTH RIGHT AND LEFT SIDE. REMOVED AND REPLACED NR 4 BATTERY PACK IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20170906003Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT FLOOR PROXIMITY LIGHT AT THE G2 GALLEY HAS A BROKEN FRAME. REMOVED AND REPLACED LIGHT PER AMM 33-51-14-960-801. OPERATIONAL CHECK GOOD.SDR AALA201709079016Power Supply · faultyAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS ON THE FOUR OVERWING EXITS FLICKERED ON AND OFF DURING CLIMB. REMOVED AND REPLACED TWO OVERWING POWER SUPPLIES (BATTERY PACKS) PER AMM 33-51-06. OPERATIONAL CHECK GOOD. SEE ALSO AALA201709079014SDR AALA201709079014Battery Pack · faultyAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS ON THE FOUR OVERWING EXITS FLICKERED ON AND OFF DURING CLIMB. REMOVED AND REPLACED TWO OVERWING POWER SUPPLIES (BATTERY PACKS) PER AMM 33-51-06. OPERATIONAL CHECK GOOD. SEE ALSO AALA201709079016SDR AALA201709079001Battery · inoperativeRIGHT AFT EXTERNAL EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE BATTERY. AIRCRAFT WAS GROUNDED.SDR DALA2017090706718Fuse · blownDURING INSPECTION, FOUND THE CEILING EMERGENCY LIGHT INOPERATIVE AT ROW 28 RT. BLOWN FUSE NR 3 IN THE BATTERY PACK M2627. MAINTENANCE REPLACED THE FUSE AND TESTED OK IAW AMM 33-51-06.SDR DALA2017090606673Battery Pack · inoperativeOVERWING EMERGENCY LIGHT (AFT) INOPERATIVE. R & R POWER SUPPLY BATTERIES IAW AMM 33-53. OPS CHECKED GOOD, ACFT OK FOR SERVICE.SDR MASA2017090612607Lamp · inoperativeROWS 12 & 13 EXIT SIGNS INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017090612604Lamp · inoperativeROW 18 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.
Back to JASC 3350