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 DALA201805173101Lens · looseEMERGENCY EXIT SIGN LENS LOOSE. REINSTALLED THE LENS. AIRCRAFT IS OK FOR SERVICE.SDR MASA2018051603190Bulb · inoperativeROW 18 OVERHEAD EMERGENCY FLOODLIGHT INOPERATIVE. REPLACED THE BULB.SDR SWAA2018050721746Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2018050721745Light · inoperativeLT EMERGENCY EXIT LIGHTS INOP BETWEEN ROW 6 TO ROW 24. CHARGED LIGHT IAW AMM.SDR MASA2018051603189Bulb · inoperativeROW 21 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE BULB.SDR DALA201805153106Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND EMERGENCY LIGHTS INOPERATIVE ROW 33 AFT. R & R THE BATTERY PACK AND POWER SUPPLY B5-237 IAW WDM 33-51-12. OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA201805143200Lens · missingEMERGENCY LIGHT LENS WAS FOUND MISSING. REPLACED THE LENS.SDR DALA2018050803134Battery Pack · dischargedDURING EMERGENCY LIGHT TEST DO NOT TURN ON, EXTERNAL LIGHTS ON FUSELAGE. REPLACED BATTERY PACK P/N60-1177-9IN AFT CARGO. OPS CHECKS OK.SDR DALA2018050803130Battery · dischargedEMERGENCY OVERHEAD LIGHTS INOP ROWS 10-14. REPLACED BATTERIES AT BATTERY PACK FOR EMERGENCY OVERHEAD LIGHTS ROW10-14 PER AMM 33-55.SDR DALA20180573103Battery Pack · malfunctionedUPPER AFT CABIN EXIT DOOR SIGN FLASHING WHEN IN ARM POSITION. MAINTENANCE REPLACED LIGHT POWER SUPPLY AND BATTERY ABOVE AFT DOOR CEILING PANEL IAW AMM 33-51. OPERATIONAL CHECK IS NOW NORMAL. AIRCRAFT OK FOR SERVICE.SDR MASA2018051603185Connector · looseRIGHT AFT EMERGENCY EXIT SIGN INOPERATIVE. SECURED A LOOSE CONNECTOR.SDR SWAA2018050721766Light · inoperativeL2 DOOR INTERIOR EMERGENCY EXIT LIGHT BULBS INOP. R&R BULBS PER AMM.SDR SWAA2018050721749Light · inoperativeLT EXTERIOR OVER WING EMERGENCY EXIT LIGHT INOP. R&R LAMP PER AMM.SDR SWAA2018050721742Light · inoperativeR2 DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR YENA201805040199Battery · dischargedFLT 391, BOS-TPA. EMER LIGHT FAILS TEST. R&R EMER LIGHT BATTERY AT 10WL AND 13WL IAW AMM 33-51-38 (FILED BY EMAIL ON 5/8/2018).SDR YENA201805040198Battery · dischargedFLT 391, BOS-TPA. EMER LIGHT FAILS TEST. R&R EMER LIGHT BATTERY AT 10WL AND 13WL IAW AMM 33-51-38 (FILED BY EMAIL ON 5/8/2018).SDR 2018FA0000244Inverter · inoperativeDURING SCHEDULED MX INSPECTION, THE EMERGENCY EXIT SIGN AT SEAT 18D WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY EXIT SIGN INVERTER, OPS CHECKED GOOD.SDR DALA2018051003222Fuse · blownEMERGENCY LIGHTS AT SEATS 15-21FG ARE INOPERATIVE. MAINTENANCE FOUND BLOWN FUSE ON POWER SUPPLY M1209 AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR SWAA2018051721993Sign · looseMID CABIN OVERHEAD EXIT SIGN LOOSE. SECURED SIGN ASSEMBLY PER SIP.SDR DALA201805173116Lens · unsecureDURING INSPECTION, FOUND THE EMERGENCY LIGHT LENS UNSECURE. MAINTENANCE SECURED THE LENS.SDR SWAA2018050721735Cover · looseRT EMERGENCY EXIT ROW LIGHT COVER LOOSE. R&R SIGN ASSEMBLY PER MM.SDR SWAA2018050721734Battery Pack · dischargedLT EMERGENCY LIGHTS EXTERIOR IN THE CABIN INOP AT BS 727C. R&R BATTERY PACK PER AMM.SDR SWAA2018050721733Battery Pack · failedBATTERY PACK FAILED CAPACITY CHECK AT M1675. R&R BATTERY PACK PER AMM.SDR SWAA2018050721732Battery Pack · failedBATTERY PACK FAILED CAPACITY CHECK AT M1672. R&R BATTERY PACK PER AMM.SDR SWAA2018050721731Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PER MM.SDR SWAA2018050721721Light · damagedFORWARD LAVATORY AFT WALL EMERGENCY EXIT LIGHT ASSEMBLY DAMAGED L1 DOOR. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2018050721716Battery Pack · failedBATTERY PACK FAILED CAPACITY CHECK AT M1669. R&R BATTERY PACK PER AMM.SDR SWAA2018050721712Battery Pack · dischargedLT EMERGENCY LIGHTS IN THE CABIN INOP AT BS 727C. R&R BATTERY PACK PER AMM.SDR SWAA2018050721711Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOP AT ROW 1. RELAMPED LIGHT PER AMM.SDR SWAA2018050721710Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R&R BATTERY PER MM.SDR SWAA2018050721703Battery Pack · dischargedEMERGENCY CENTER AISLE LIGHT INOP AT BS 589, RBL 18. R&R BATTERY PACK PER AMM.SDR DALA2018051503057Power Supply · inoperativeEMERGENCY EXIT LIGHT AT SEAT 30 ABC INOPERATIVE. REPLACED THE POWER SUPPLY. OPS CHECKED GOOD IAW AMM 33-51.SDR DALA2018050303024Light · inoperativeEMERGENCY LIGHT AT 24D IS INOP. R&R SEAT MOUNTED EMERGENCY LIGHT FIXTURE PER AMM 33-51.SDR DALA2018050403053Battery · dischargedEMERGENCY LIGHT INOP ON CEILING PANELS ON ROW 21-26. FOUND BATTERY BAD IN BATTERY PACK IN BAG BIN 24E,D. REPLACED BATTERIES. LIGHTS WORK GOOD.SDR DALA201805173005Battery Pack · inoperativeFOUND CEILING EMERGENCY LIGHTS BETWEEN ROWS 14-30 INOPERATIVE, ALSO ALL FOUR OVERWING EXIT IDENTIFIERS INOPERATIVE. TROUBLESHOT IAW SSM 33-51. FOUND BATTERY WITH DEAD CELL AT B5-102. POWER SUPPLY OK. REPLACED THE BATTERIES IAW AMM 33-50. ALL EMERGNECY LIGHTSSDR SWAA2018051601694Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1675. R & R THE BATTERY IAW AMM.SDR SWAA2018051601693Lens · brokenL1 DOOR EMERGENCY EXIT SIGN LENS MOUNTING SCREW BROKEN. R & R THE LENS IAW MM.SDR SWAA2018051601692Lamp · inoperativeLEFT OVERWING EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA201805161664Lamp · inoperativeR1 EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR CALA2018050201216Fuse · inoperativeROWS 21-34 AND DOOR 2R EMERG EXIT LIGHTS INOP INSPECTED EMERGENCY BATTERY PACK 1695, SECURED BATTERY TO PACK AND REPLACED FUSE, OPS CHECKS GOOD. OK TO CONTINUE.SDR CALA2018050201215Battery Pack · dischargedEMERGENCY EXIT LIGHTS OVERWING INOP REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1694, OPS CHECKS GOOD. REF AMM 33-51-06-960-806.SDR DALA2018050203081Lens · missingDURING INSPECTION, FOUND THE EMERGENCY EXIT LIGHT LENS MISSING. MAINTENANCE INSTALLED EMERGENCY LIGHT LENS IAW AMM 33-51.SDR DALA2018051703078Bulb · missingDURING INSPECTION, FOUND SEAT 17DEF EMERGENCY LIGHT COVERS AND BULBS MISSING. MAINTENANCE RELAMPED AND REPLACED THE LENSES IAW AMM 33-51-11. LIGHTS OP CHECKED NORMAL.SDR DALA2018050203058Socket · not seatedEMERGENCY EXIT LIGHTS 10-11 INOP BC. RESEATED SOCKET ASSY AT 11CB RELAMPED 10BC.SDR DALA2018050203028Battery Pack · dischargedON SVC CHK FOUND A GROUP OF EMERGENCY LIGHTS INOP SEAT MOUNTED LIGHTS ROWS 43, 44 & 45 "D" OR RT ABOVE DOOR 3R AND SMALL LIGHT DOOR 3L LWR FWD SIDE. REPLACED AFT CABIN BATTERY PACKS M736 & M9102 REF AMM 33-51.SDR DALA2018050203027Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. 3R LAV EMERGENCY LIGHT BROKEN CRACKED INTERIOR. REPLACED DAMAGED EMER LIGHT LENS.SDR SWAA201805161662Lens · missingLEFT EMERGENCY LIGHT LENS MISSING AT ROW 23. INSTALLED A NEW LENS IAW SIP.SDR SWAA201805161655Lens · missingMID CABIN OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING. R & R THE LENS IAW MM.SDR SWAA201805161609Battery Pack · inoperativeRIGHT EMERGENCY LIGHTS INOPERATIVE BETWEEN ROWS 3 TO 6. R & R THE BATTERY PACK IAW AMM.SDR IPXA2018050129167Light · inoperativeEMERGENCY LIGHT HAS NINE INOP BULBS. RELAMPED NINE BULBS IN THE EMERGENCY LIGHT PER AMM 33-51-01-2.
Back to JASC 3350