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 SIMA201805154003Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A, OPS CHECKED GOOD.SDR MASA201805153217Lamp · inoperativeROW 8 CEILING EMERGENCY FLOOD LIGHT WAS INOPERATIVE. REPLACED THE LAMPS.SDR CALA2018051501273Battery Pack · no testMAIN DECK L4 DOOR EMERGENCY LIGHT BATTERY PACK M33407 FOUND TO HAVE LOW CAPACITY. REPLACED BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-803, REV 82.SDR CALA2018051501272Battery Pack · no testM/D R4 DOOR EMERGENCY LIGHT BATTERY PACK M33408 FOUND TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK. OPS TESTED NORMAL IAW AMM 33-51-06-960-803, REV 82.SDR CALA2018051501271Battery Pack · no testM/D L1 DOOR EMERGENCY LIGHT BATTERY PACK M33093 FOUND TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK. OP TESTED GOOD IAW AMM 33-51-06-960-803, REV 82.SDR CALA2018051501270Battery Pack · no testM/D L1 DOOR EMERGENCY LIGHT BATTERY PACK M33093 FOUND TO HAVE LOW CAPACITY. REPLACED BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-803, REV 82.SDR DALA2018051503337Battery Pack · inoperativeEXIT SIGN BY THE LEFT SERVICE DOOR INOPERATIVE. REPLACED THE BATTERY PACK.SDR I5EA20180515005Battery Pack · no testM1695 BATTERY FAILED A FUNCTIONAL CHECK. REMOVED AND REPLACED THE POWER SUPPLY. TESTED GOOD IAW 33-51-06.SDR I5EA20180515004Battery Pack · no testM1672 BATTERY FAILED A FUNCTIONAL CHECK. REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT POWER SUPPLY. TESTED GOOD IAW AMM 33-51-06SDR I5EA2018051503Battery Pack · no testM1694 BATTERY FAILED A FUNCTIONAL CHECK. REMOVED AND REPLACED THE POWER SUPPLY, TESTED GOOD IAW AMM 33-51-06.SDR I5EA2018051502Battery Pack · no testBATTERY PACK M1670 FAILED A FUNCTIONAL CHECK. REMOVED AND REPLACED THE POWER SUPPLY, TESTED GOOD IAW AMM 33-51-06.SDR DALA2018051503328Light · shortedTHE EMERGENCY LIGHTS INTERMITTENTLY CAME ON & OFF DURING FLIGHT. WATER WAS FOUND IN THE EXIT SIGN AT THE TAILCONE. REPLACED IAW WDM 33-51. THE EMERGENCY LIGHTS NOW OPERATE NORMALLY. ALSO REMOVED CONDENSATION ABOVE AFT DROP CEILING PANEL.SDR DALA2018051503326Power Supply · malfunctionedTHE OUTSIDE WING EMERGENCY LIGHTS REMAIN ILLUMINATED AFTER TESTING. MAINTENANCE REPLACED THE THE OVERWING LIGHTS POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD. AIRCRAFT IS OK FOR SERVICE.SDR DALA2018051403302Lamp · inoperativeEMERGENCY FLOOR LIGHT AT SEAT 22B INOPERATIVE. REPLACED THE LAMPS.SDR AALA201805184001Charger · no testL1 DOOR UPPER EXIT SIGN INOPERATIVE DURING A TEST. REPLACED THE BATTERY CHARGER M731 IAW AMM 33-51-07.SDR DALA2018051403333Charger · inoperativeROWS 10, 11 & 12 B,C EMERGENCY ROW LIGHTS INOP. R&R BATTERY CHARTER M33098 IAW AMM 33-52 OPS CK GOOD.SDR DALA2018051403256Fuse · blownSEAT 31 BACK EMERGENCY LIGHTS INOP. REPLACED FUSE PER CMM 25-60-03 OPS CHECK PER AMM 33-53.SDR SWAA2018051421898Light · inoperativeEMERGENCY AREA LIGHT ON SEAT INOP AT ROW 11. RELAMPED LIGHT IAW AMM.SDR SWAA2018051421872Light · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT SLIDE LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018051621972Lens · missingL2 DOOR OVERHEAD EMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS IAW AMM.SDR AALA2018051549049Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 20C. INSTALLED THE LENS, OPS CHECKED GOOD IAW AMM 33-50-00.SDR AALA201805159018Ballast · inoperativeAIRCRAFT WAS NOT GROUNDED. FORWARD RIGHT HAND ENTRY EMERGENCY LIGHT INOPERATIVE. REPLACED RIGHT HAND FORWARD ENTRY LIGHT BALLAST UNIT PER AMM 33-21-11-400-001.SDR AALA201805159017Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT AT DOOR 1L INOPERATIVE. RELAMPED EXIT LIGHT AT DOOR 1L, OPERATIONS NORMAL PER AMM 33-51-16.SDR AALA201805149057Cover · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT COVER ON R1 DOOR IS MISSING. REPLACED EMERGENCY LIGHT COVER ON R1 DOOR PER AMM 33-50-00.SDR SWAA2018051521954Sign · looseOVERHEAD EXIT ROW SIGN LOOSE. SECURED SIGN PER AMM.SDR SWAA2018051521948Cover · missingRT EMERGENCY EXIT SIGN MISSING AT ROW 12. INSTALLED SIGN COVER PER AMM.SDR CALA2018051501269Sign · damagedM/D R2 DOOR AREA OVER EXIT SIGN FOUND CRACKED AND LOOSE. REPLACED THE SIGN HOUSING AND LENS. OPS TESTED NORMAL IAW AMM 33-51-01-960-802, REV 82.SDR CALA2018051501268Sign · brokenM/D L1 DOOR AFT, R1 DOOR FWD & AFT THREE EXIT SIGNS FOUND BROKEN. REPLACED SIGNS. OPS TESTED NORMAL IAW AMM 33-51-01-960-802, REV 82.SDR CALA2018051501267Light · brokenM/D A & B ZONE CTR PARTITION FOUR LWR EMERGENCY LIGHTS FOUND BROKEN. REPLACED THE EMERGENCY LIGHTS AND OPS TESTED NORMAL IAW AMM 33-51-05-960-802, REV 82.SDR SIMA201805143001Light · inoperativeRIGHT AFT EXTERIOR EMERGENCY LIGHT WAS FOUND INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECKED GOOD IAW AMM 33-50-00.SDR DALA2018051403303Power Supply · inoperativeDURING A SERVICE CHECK, THE EMERGENCY LIGHTS AT SEATS 23 - 23 ABC WERE FOUND INOPERATIVE. REPLACED THE BATTERY POWER SUPPLY UNIT.SDR SIMA2018052512007Wire · brokenWIRE FOR EMERGENCY LIGHT WAS BROKEN. REPAIRED EMERGENCY LIGHT WIRE IAW SWPM 20-21-00.SDR SWAA2018052222164Power Supply · inoperativeLT LOWER FUSELAGE EMERGENCY LIGHT INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2018052122047Cover · missingMID CABIN EMERGENCY EXIT SIGN COVER MISSING. SECURED COVER PER AMM.SDR SWAA2018052122085Light · inoperativeEMERGENCY LIGHT CHECK FLIGHT DECK CEILING LIGHT INOP. RELAMPED LIGHT IAW AMM & SIP.SDR DALA2018052003451Housing · damagedEMERG LIGHT HOUSING AT SEAT 19D DAMAGED, REPLACED EMERGENCY LIGHT HOUSING AT SEAT 19D.SDR AALA2018051749035Power Supply · no testDURING A A03 CHECK, EMERGENCY LIGHT TEST, ACTIVE CLASS 1 FAULT CIDS 1335100 EXIT SIGNS, EMERGENCY POWER SUPPLY UNIT 3R 16WL. REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPS CHECK. THE AIRCRAFT WAS GROUNDEDSDR AALA2018051749034Power Supply · no testDURING A A03 CHECK, EMERGENCY LIGHT TEST, ACTIVE CLASS 1 FAULT CIDS 1 335100 EXIT SIGNS/EMERGENCY POWER SUPPLY UNIT 3L 15WL. REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPS CHECK. THE AIRCRAFT WAS GROUNDEDSDR DALA2018051403258Battery · dischargedOVHD EMERGENCY LIGHTS INOP IN FIRST CLASS. RPLD BATTERIES PER AMM 33-53. OP CKS GOOD.SDR MASA201805163214Battery Pack · inoperativeFIRST OFFICER`S FLASHLIGHT INOPERATIVE. REPLACED THE BATTERY.SDR SWAA2018051421899Battery · dischargedEMERGENCY LIGHT INOP AT M1669. R&R BATTERY PER AMM.SDR R61A20180515593Power Supply · inoperativeR2 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE R2 DOOR EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED GOOD.SDR R61A20180515563Power Supply · inoperativeR2 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE R2 DOOR EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED GOOD.SDR SWAA2018051521910Battery Pack · inoperativeFORWARD ENTRY LOWER EMERGENCY EXIT SIGN INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR ASAA201805144601Lamp · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR SIMA2018051400005Lamp · inoperativeOVERWING EMERGENCY LIGHT AT SEAT 12A WAS FOUND INOPERATIVE. R & R THE OVERWING EMERGENCY LIGHT LAMP IAW 33-50-07-000-801-A, AND 33-50-07-400-801-A. OPS CHECKED GOOD.SDR ASAA2018051125023Battery Pack · failedEMERGENCY BATTERY PACK M1675 AT STATION 322 FAILED DEEP CYCLE CHECK. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK S/N 80643 M1675 AND OPS CHECKED GOOD IAW AMM 33 51 06 960 805 STEPS 4D 1-5.SDR ASAA2018051125022Battery Pack · dischargedLEFT AFT OVERWING HATCH, OUTSIDE EMERGENCY EXIT LIGHT INOP. GROUNDED - YES. RELAMPED LT AFT OVERWING EMERGENCY EXIT LIGHT IAW AMM 33 51 04 960 801, AND REPLACED BATTERY PACK S/N 87698 FOR LT AFT EMERGENCY LIGHT IAW AMM 33 51 06 960 805, OPS CKS GOOD IAW AMM 33SDR SWAA2018061122674Light · brokenAFT ENTRY OVERHEAD EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT IAW AMM.SDR ASAA2018051124984Battery Pack · no testEMERGENCY BATTERY PACK M1671 AT BS 727C+13 FAILED A DEEP CYCLE TEST. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51-06-960-805, STEPS 4.D 1 - 5.
Back to JASC 3350