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 DALA2016111008768Fuse · blownROW 14 CTR OVHD AISLE EMERGENCY LIGHT INOP, REPLACED FUSE AT EPSU 15WL.SDR AALA201611109003Lens · missingAIRCRAFT WAS NOT GROUNDED. DOOR L4 EXIT LIGHT LENS MISSING. REPLACED LENS PER 33-51-19.SDR AALA20161111002Lens · missingEMERGENCY EXIT LIGHT LENS COVER MISSING AT RIGHT AFT OVERWING DOOR. INSTALLED LENS COVER IAW 33-51-01. OPS CHECKED GOOD.SDR AALA20161111001Lens · missingEMERGENCY EXIT LIGHT LENS COVER MISSING AT AFT PASSENGER DOOR. INSTALLED LENS COVER IAW 33-51-01. OPS CHECKED GOOD.SDR SIMA20161109001Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ASSY, OPS CHECKED GOOD, IAW AMM 33-50-10SDR AALA20161110001Lens · detachedEMERGENCY FLOOR LIGHT LENS BY FORWARD CLOSET DETACHED. REPOSITIONED LENS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR SWAA2016111009588Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01668. R & R THE BATTERY IAW AMM.SDR SWAA2016111009585Lens · missingR1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R & R THE SIGN IAW MM.SDR SWAA2016111009584Lens · missingL1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R & R SIGN IAW AMM.SDR SWAA2016111009583Bulb · overheatedLEFT OVERWING EMERGENCY EXIT LIGHT BULB OVERHEATED. REPLACED THE BULB IAW AMM.SDR SWAA2016111009553Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY IAW AMM.SDR QXEA2016111000707Relay · malfunctionedEMERGENCY LIGHTS DISARMED CAUTION LIGHT INTERMITTANT. REPLACED RELAY 3351K2. SYSTEM CHECKED GOOD IAW AMM 33-51-00-710-803. RETURNED TO SERVICE.SDR DALA2016111008531Light · disconnected14L EMERGENCY LIGHT INOPERATIVE, CONNECTED THE LIGHTSDR DALA2016111008530Lamp · inoperativeEMERGENCY LIGHTS FAILED TEST. REPLACED THE LAMPS.SDR DALA2016110908525Battery Pack · inoperativeLEFT SIDE CEILING EMERGENCY LIGHTS INOPERATIVE AFT OF ROW 9 AND RIGHT SIDE CEILING EMERGENCY LIGHTS FOR FOR 17-21 ARE INOPERATIVE. REPAIRED BROKEN WIRE AT L321, RESET C/B, CHARGED BATTERIES, REPLACED M9009 BATTERY AND CHARGER. SYSTEM OPERATION IS NORMAL.SDR DALA2016111008524Fuse · failedON SERVICE CHECK, FOUND SEAT 6-9D EMERGENCY LIGHTS INOPERATIVE. REPLACED THE FUSE ON THE POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR DALA2016110908367Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS IN THE TAIL COMPARTMENT INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY AND THE LIGHTS RETURNED TO NORMAL OPERATIONAL CONDITION.SDR MASA2016110712468Battery Pack · dischargedALL FWD EMERGENCY CABIN LIGHTS INOPERATIVE. CHARGED THE BATTERIESSDR UHLA201611080508Power Supply · inoperativeAFT SERVICE DOOR LINER EMERGENCY LIGHT EXIT IDENTIFIER DOES NOT ILLUMINATE. REMOVED AND REPLACED DEAD EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. PERFORMED OPERATIONAL TEST OF OF THE EMERGENCY LIGHT POWER UNIT PASSED NO DEFECT NOTED IAW AMM 33-50-00. ACCOMPLISDR AALA20161111003Charger · failedOVERHEAD EMERGENCY LIGHT AT SEATS 22DEF INOPERATIVE. OPEN WIRE FROM POWER SUPPLY CONNECTOR TO QUICK DISCONNECT CONNECTOR TO INOPERATIVE EMERGENCY LIGHT. REFERENCE WDM 33-51-14. AIRCRAFT GROUNDED. REMOVED AND REPLACED CHARGER ASSEMBLY M735 IAW AMM 33-51-SDR SWAA2016111409676Light · looseCENTER AISLE CEILING OVERWING EXIT LIGHT FIXTURE LOOSE. SECURED LIGHT IAW AMM.SDR DALA2016111508800Light · inoperativeAFT GALLEY 403, LEFT EMERGENCY WHITE LIGHTS ARE INOPERATIVE. REPLACED THE LIGHT. SYSTEM OPERATION IS NORMAL.SDR VNAA2016110800011Light · detachedEMERGENCY LIGHT LOOSE. MAINTENANCE INSPECTED, SECURED THE EMERGENCY LIGHT AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR REXA2016110802206Light · inoperativeEMERGENCY LIGHT ON BACK SIDE OF RIGHT CLASS DIVIDER AND EMERGENCY LIGHT ON RIGHT HAND EXTERNAL SIDE OF SERVICE DOOR INOPERATIVE. OPS TESTED GOOD IAW AMM 33-51-00-710-802-A16.SDR R61A201611080643Light · inoperativeCREW REPORTED THAT THE FLIGHT DECK EMERGENCY LIGHT DID NOT ILLUMINATE WHEN SWITCH WAS TURNED ON. MAINTENANCE REMOVED AND REPLACED COCKPIT OVERHEAD EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR SWAA2016111009582Cover · crackedL1 DOOR EMERGENCY EXIT SIGN COVER CRACKED. R & R THE SIGN IAW AMM.SDR AALA20161109021Power Supply · inoperativeEMERGENCY LIGHTS FAILED TEST AT 15WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 15WL IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR AALA20161109020Power Supply · inoperativeEMERGENCY LIGHTS FAILED TEST AT 14WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 14WL IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR AALA20161109019Power Supply · inoperativeEMERGENCY LIGHTS FAILED TEST AT 12WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 12WL IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR AALA20161109018Power Supply · inoperativeEMERGENCY LIGHTS FAILED TEST AT 10WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 10WL IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR DALA2016110908370Light · inoperativeEMERGENCY LIGHT AT PAX SEAT 24 DEF INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51. CHECKED GOOD.SDR SWAA2016110909552Charger · inoperativeCABIN EMERGENCY LIGHT CHARGER BASES INOPERATIVE AT LOCATION MO1675. R & R THE CHARGER IAW AMM.SDR SWAA2016110909551Battery · no testCABIN EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATIONS MO1674. R & R BATTERY IAW AMM AND DWG.SDR SWAA2016110909550Battery · no testCABIN EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATIONS MO1673. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2016110909549Battery · no testCABIN EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATIONS MO1675. R & R BATTERY IAW AMM AND DWG.SDR SWAA2016110909542Charger · inoperativeCABIN EMERGENCY LIGHT CHARGER BASES INOPERATIVE AT LOCATION MO1673. R & R THE CHARGER IAW AMM.SDR SWAA2016110909541Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY, FAILED CAPACITY CHECK AT LOCATIONS MO1672. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2016110909525Cover · brokenL1 DOOR EMERGENCY EXIT SIGN LIGHT COVER BROKEN. R & R THE SIGN IAW MM.SDR SWAA2016110809519Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK M01673 FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW MT.SDR SWAA2016110809518Lens · missingLEFT EMERGENCY LIGHT LENS MISSING AT ROW 15. REPLACED THE LENS IAW AMM.SDR REXA2016110802176Light · looseEMERGENCY LIGHT PEELED OFF GALLEY FLOOR. INSTALLED IAW AMM 33-51-01. OK FOR SERVICE.SDR UIEA2016110900836Inverter · inoperativeEMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS, CONNECTED THE CONNECTOR FOR SEATS 4-9CA, REMOVED AND REPLACED THE INVERTER, REMOVED AND REPLACED AFT GALLEY EMERGENCY LIGHT ASSY.SDR UIEA2016110900837Power Supply · inoperativeLEFT AND RIGHT OVERWING EMERGENCY LIGHTS FOUND INOPERATIVE. REPLACED THE LAMPS, CLEANED AND REPLACED THE POWER SUPPLY. OPS CHECKED GOOD.SDR AALA20161108010Battery Pack · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EGRESS LIGHTING IS DIM BETWEEN ROWS 9 AND 15. REMOVED AND REPLACED EMERGENCY BATTERY PACK AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-11.SDR JJBA20161108011Light · inoperativeEMERGENCY LIGHT AT ROW 22 IS INOP. REMOVED AND REPLACED BULB.SDR SIMA20161107003Light · damagedPROXIMITY LIGHT FOUND DAMAGED. R & R THE LIGHT IAW AMM 33-50-12. OPS CHECKED GOODSDR HALA2016110900207Light · looseFLOOR LIGHTING STRIP AT LEFT ROWS 25 AND 26 ARE LOOSE. REMOVED DEBRIS FROM UNDER FLOOR LIGHTING AND RE-SECURED LIGHT STRIP.SDR AALA20161110016Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE CEILING EMERGENCY LIGHTS BETWEEN ROW 1D AND 30 FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33098 AMM 33-5SDR AALA20161110015Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE CEILING EMERGENCY LIGHTS BETWEEN ROW 1D AND 30 FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AMM 33-51-06.SDR AALA20161110014Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE CEILING EMERGENCY LIGHTS BETWEEN ROW 1D AND 30 FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33404 AMM 33-
Back to JASC 3350