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 AALA20180114003Charger · inoperativeDURING PS 2 CHECK STEP 27 C TEST, EMERGENCY LIGHTS, IT WAS FOUND A EMERGENCY LIGHT CHARGER AT R4 DOOR INOPERATIVE. REPLACED THE CHARGER DOOR 4R IAW AMM 33-51-06. GOOD FOR SERVICE.SDR AALA201801189011Cover · detachedAIRCRAFT WAS NOT GROUNDED: DOOR EMERGENCY EXIT LIGHT AT 1L FELL OFF. MAINTENANCE REINSTALLED DOOR 1L EXIT LIGHT COVER PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801169009Light · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT LIGHT INOPERABLE AIRCRAFT LEFT. MAINTENANCE RESET CIDS CIRCUIT BREAKERS PER TSM 24-00-810-818 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018011500284Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROWS 21 - 30 LEFT AISLE. REPLACED THE POWER SUPPLY. THE SYSTEM OPS NORMALSDR DALA2018011600277Sign · looseEMERGENCY EXIT SIGN COVER LOOSE. SECURED THE SIGN.SDR AALA201801169038Cover · brokenAIRCRAFT WAS NOT GROUNDED. AISLE EMERGENCY LIGHT COVER BROKEN AT ROW 20. REPLACED AISLE EMERGENCY LIGHT COVER PER CMM 25-22-52. OPERATIONS CHECK GOOD. (SEE CONTROL #AALA201801169015)SDR AALA201801169034Cover · brokenAIRCRAFT WAS NOT GROUNDED. AISLE EMERGENCY LIGHT COVER BROKEN AT ROW 26 AIRCRAFT LEFT. REPLACED AISLE EMERGENCY LIGHT COVER PER CMM 25-22-52. (SEE CONTROL #AALA201801169012 AND #AALA201801169033)SDR AALA201801169033Cover · brokenAIRCRAFT WAS NOT GROUNDED. AISLE EMERGENCY LIGHT COVER BROKEN AT ROW 25 AIRCRAFT LEFT. REPLACED AISLE EMERGENCY LIGHT COVER PER CMM 25-22-52. (SEE CONTROL #AALA201810169012 AND #AALA201801169034)SDR AALA201801169015Cover · brokenAIRCRAFT WAS NOT GROUNDED. AISLE EMERGENCY LIGHT COVER BROKEN AT ROW 18. REPLACED AISLE EMERGENCY LIGHT COVER PER CMM 25-22-52. OPERATIONS CHECK GOOD. (SEE CONTROL #AALA20189038)SDR AALA201801169012Cover · brokenAIRCRAFT WAS NOT GROUNDED. AISLE EMERGENCY LIGHT COVER BROKEN AT ROW 22 AIRCRAFT LEFT. REPLACED AISLE EMERGENCY LIGHT COVER PER CMM 25-22-52. (SEE CONTROL #AALA201801169033 AND #AALA201801169034) .SDR ASOA201801137001Light · inoperativeFLOOR PROXIMITY EMERGENCY LIGHT STRIP NR 4 INOPERATIVE. REMOVED AND REPLACED NR 4 EMERGENCY LIGHT STRIP.SDR R61A201801130047Power Supply · failedNR 2 EMERGENCY LIGHT POWER SUPPLY FAILED A FUNCTIONAL CHECK. R & R THE POWER SUPPLY IAW AMM 33-50-01.SDR AALA201801169002Battery · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE EPSU BATTERY IAW AMM 33-51-38.SDR SIMA20180113002Charger · failedFIND BOTH OVER WING EMERGENCY LIGHT INOP DOING PS-1 INSP. R&R EPSU NR 4 IAW AMM TASK 33-50-04 OPS CHECK NO GOOD REMOVED AND REPLACED BOTH BULB IAW AMM TASK 33-50-10 OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1ASMI S/N 68503.SDR JJBA20180113007Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AND FOUND IN THE ARMED POSITION. R & R THE BATTERY PACKS IAW AMM 33-50-04. OPS CHECKED GOOD.SDR MASA2018011312914Light · inoperativeEXTERIOR EMERGENCY LIGHTS INOPERATIVE.SDR MASA2018011312913Light · malfunctionedEMERGENCY LIGHTS CYCLE ON AND OFF WHEN ARMED. SDR CALA2018011300186Light · missingEMERGENCY LIGHT MISSING AT ROW 21 ABC, REPLACED THE EMERGENCY LIGHT.SDR CALA2018011300185Lens · looseEMERGENCY LIGHT ON SEAT 36C FOUND LOOSE AND HANGING DOWN. REPLACED THE LENS. OPS CHECKED GOOD.SDR SWAA2018012919374Lens · crackedLT EMERGENCY EXIT LIGHT LENS CRACKED AT ROW 12. R&R LENS IAW AMM.SDR SWAA2018012919373Lens · crackedLT EMERGENCY EXIT LIGHT LENS CRACKED BETWEEN ROW 8 TO ROW 9. R&R LENS IAW AMM.SDR AALA201801199002Lens · brokenEMERGENCY LIGHT LENS BROKEN AT FORWARD SERVICE DOOR. REPLACED THE LENS IAW AMM 33-51-14.SDR AALA201801199001Lens · missingEXIT SIGN LENS AT FORWARD GALLEY AISLE IS MISSING. REPLACED THE LIGHT ASSEMBLY IN FORWARD AISLE IAW MM 33-51-01.SDR AALA20180114001Sign · brokenAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT DOOR, EXIT SIGN FELL OFF LOWER LIGHT SIGN. MAINTENANCE REPLACED EXIT SIGN LIGHT ASSEMBLY PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018011500281Fuse · failedDURING A SERVICE CHECK, FOUND EMERGENCY LIGHTS CABIN RT SIDE ROWS 4, 5, & 6 INOPERATIVE. FOUND THE FUSE IN BATTERY PACK BAD AND REPLACED. SYSTEM OPS NORMAL.SDR SWAA2018011719137Sign · brokenCENTER AISLE OVERHEAD CEILING EMERGENCY EXIT SIGN LIGHT BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2018011719091Lens · brokenLEFT SIDEWALL OVERWING EXIT SIGN BROKEN. R & R THE LENS IAW AMM.SDR SWAA2018011719056Sign · detachedLEFT OVERWING EXIT DOOR SIGN DETACHED. INSTALLED THE SIGN IAW AMM.SDR SWAA2018011719029Lens · missingR2 DOOR EMERGENCY EXIT SIGN LENS MISSING. R & R THE SIGN IAW MM.SDR DALA2018011600274Relay · failedEMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT IAW FIM 33-51-00-815-802. R & R THE EMERGENCY LIGHTS ALTERNATE TRANSFER RELAY K10570 IAW WDM 33-51-11. OPS CHECKED GOOD.SDR ASAA2018011223173Lens · detachedCOVER FELL OFF EMERGENCY EXIT LIGHT BY AFT LEFT LAVATORY. GROUNDED - YES. REPLACED COVER REF AMM 33-51-14. OK FOR SVC.SDR SWAA2018011619054Cover · missingRT LOWER OVERWING EXIT LIGHTED COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2018011619001Lens · missingRIGHT MID LEVEL EMERGENCY EXIT SIGN LENS MISSING. R & R THE LENS IAW AMM.SDR REXA2018011200018Bulb · inoperativeEMERGENCY EXIT LIGHT ABOVE GALLEY SERVICE DOOR IS INOPERATIVE. R & R THE SIGN BULBS IAW AMM 33-51-05. OK FOR SERVICE.SDR AALA201801169016Light · inoperativeCABIN EMERGENCY LIGHT INOPERATIVE. AIRCRAFT WAS GROUNDED. REPLACED EMERGENCY LIGHT OVER THE L2 DOOR.SDR DALA2018011500244Light · inoperativeDURING INSPECTION FOUND R2 DOOR, EXTERIOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE CLEANED CONTACTS. OPS NORMAL.SDR DALA2018011400237Light · brokenEMERGENCY LIGHT ASSY AT SEAT 17 DEF BROKEN FROM SEAT, R AND R THE EMERGENCY LIGHT HOUSING.SDR CALA2018011200173Light · malfunctionedEMERGENCY LIGHT SYSTEM FAILED TO TEST. SHOWS EPSU UNIT FWD LT. RESET SYSTEM. THE EMERGENCY LIGHTS SYSTEM TESTED OK.SDR CALA2018011200167Lens · looseEMERGENCY LIGHT LENS NEXT TO THE FWD CLOSET LOOSE. INSTALLED A NEW LENS.SDR CALA2018011200172Lens · missingMISSING EMERGENCY EXIT LIGHT PROTECTIVE LENS AT BOTH SEATS 34A AND 30A. INSTALLED THE LENS CAP.SDR CALA2018011200171Battery · faultedDURING A SERVICE CHECK, FOUND EPSU FOR THE EMERGENCY LIGHT BATTERY LT FAULT MESSAGE ON CIDS DISPLAY. REPLACED THE EPSU BATTERY AND OP CHECKED GOOD IAW AMM 33-51-39.SDR CALA2018011200170Cids · malfunctionedIN FLT, THE CABIN LIGHTS FLICKERING ALONG WITH THE EMERGENCY LIGHTS. SEAT BELT CHIME DING INTERMITTANT. PERFORMED HIT CIDS2 DATA INTM FAIL AT FLT PH 06. RESET CIDS DIR2 AT CFDS. ALL CIDS LIGHT COTROL. FUNCTIONS NORMAL IAW AMM23-73-00.SDR CALA2018011200169Lens · brokenEMERGENCY LIGHT LENS ON THE FWD LEFT CLOSET FOUND BROKEN. MX REPLACED THE LENS. OPS CHECKS GOODSDR CALA2018011200168Sign · false activationEMERGENCY EXIT SIGN DOES NOT TURN OFF IN THE PASSENGER CABIN. EMERGENCY LIGHT CHECKED, NO DEFECTS NOTED. GOOD FOR SERVICE.SDR CALA2018011200166Light · crackedFLOOR EMERGENCY LIGHT ATTACHED TO SEAT 4B IS CRACKED. REPLACED THE EMERGENCY LIGHT ASSEMBLY. OPS CHECKED GOOD IAW AMM 33-51-11-960-802.SDR CALA2018011200165Lens · detachedPLASTIC EMERGENCY LIGHT SIGN DETACHED IN THE MID CABIN. INSTALLED THE SIGN LENS IAW AMM 33-51-01-960-802, ALL FUNCTIONS NORMAL.SDR CALA2018011200154Lens · detachedEMERGENCY LIGHT LENS DETACHED BY THE L3 DOOR. ATTACHED THE LENS. OK TO CONTINUESDR CALA2018011200152Lens · missingEMERGENCY EXIT LIGHT LENS IS MISSING FROM CEILING PANEL AT 21B. REPLACED THE LENS.SDR CALA2018011200153Light · looseSOME WIRES HANGING DOWN FROM SEAT 24F. FOUND EMERGENCY LIGHT ASSY LOOSE, SECURED THE LIGHT ASSY, OPS CHECKED GOOD.SDR CALA2018011200151Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04, OPS CHECKED NORMAL.
Back to JASC 3350